Can we Oracle sequnce for Id Generation in j2ee 5.0 compatible sap appsever

[Former Member]

Hi,

Please let me know can we use oracle sequence for primary key generation in j2ee5.0 compatible sap application server?.

My requirement is to use continuous numbers for the primary key column.

BR

Karthika

[adrian_goerler · Accepted solution]

Hi,

yes, you can use Oracle Sequences provided you are using a data source configured for Native SQL.

If you want to use the Oracle Sequence using SAP JPA, please have a look at this docu page:

http://help.sap.com/saphelp_nw73/helpdata/en/0b/64c151148c4d83843ab278421dce87/frameset.htm

-Adrian

[Former Member · Accepted solution]

Hi Adrian,

Thanks for your answer.

In our project we are using J2EE5.0. I would like to know whether this edition 5.0 will support Sequence strategy for primary key generation.

We are using CE7.2 with J2EE5.0, JPA 1.0

The created oracle sequences are not listed in the drop down list. So I would like to ensure it.

Best Regards,

Karthika

Edited by: SAKarthika on Mar 29, 2011 11:31 AM

[adrian_goerler · Accepted solution]

Hi,

I am not sure which drop-down list you are referring to. But I can confirm that you can use GenerationType.SEQUENCE with NetWeaver AS Java 7.2 and SAP JPA 1.0 on Oracle.

-Adrian

[Former Member · Accepted solution]

Thanks for your reply.

It is solved.

BR

Karthika