CMP and sequence in oracle

[william kane]

How do i handle the following situation?
I have a CMP bean whose create method takes 4 paramters.These fields are inserted into the database by the container after I deploy the bean.But i also have a field in my oracle database table(primary key) that is sequence.
Oracle doesnot autogenerate sequences and i cannot insert code into a CMP.How do i go about it?How do i tell the container that my PK is a sequence that has to be generated before insertion?
Any pointers for the same will also do.

[Pradeep bhatt]

Pasted from Oracle 9ias ejb doc
Defining an Auto-Generated Primary Key
If you specify a java.lang.Object as the primary key class type in <prim-key-class>, but do not specify the primary key name in <primkey-field>, then the primary key is auto-generated by the container.
The employee example defines its primary key as a java.lang.Object. Thus, the container auto-generates the primary key.

<enterprise-beans>
      <entity> 
         <display-name>Employee</display-name>
         <ejb-name>EmployeeBean</ejb-name>
         <local-home>employee.EmployeeLocalHome</local-home>
         <local>employee.EmployeeLocal</local>
         <ejb-class>employee.EmployeeBean</ejb-class>
         <persistence-type>Container</persistence-type>
         <prim-key-class>java.lang.Object</prim-key-class>
         <reentrant>False</reentrant>
         <cmp-version>2.x</cmp-version>
         <abstract-schema-name>Employee</abstract-schema-name>
         <cmp-field><field-name>empNo</field-name></cmp-field>
         <cmp-field><field-name>empName</field-name></cmp-field>
         <cmp-field><field-name>salary</field-name></cmp-field>
      </entity>
...
</enterprise-beans>
  

Once defined, the container creates a column called autoid in the entity bean table for the primary key of type LONG. The container uses random numbers for the primary key values.

[Pradeep bhatt]

The doc is for Oracle 9ias 9.0.3