can jboss generate a different primarykey per bean using ora

[bentins]

I have my system configured with an entity - command using oracle secuemce to generate the Primary-Key for my cmp beans.

The way it is now is one sequence for all beans. I wan't to use a different sequence for each bean, can I configure Jboss to do so?

Thanks

Shai

[imhotep]

Hi Shai,

Why not use Hibernate?

-Imho

[lafr]

The entity-command oracle-sequence has a attribute named sequence which takes the name of the used sequence.

I my EB I have this tags for XDoclet:
* @jboss.entity-command name="oracle-sequence"
* @jboss.entity-command-attribute name="sequence" value="afpos_seq"

This goes to jbosscmp-jdbc.xml as:
<entity-command name="oracle-sequence">
afpos_seq
</entity-command>

[bentins]

It is my understanding that I need a diferent entity-command for each class I will have a difference sequence so my solution was:

* @jboss.entity-command name="folder-sequence" class=""
* @jboss.entity-command-attribute name="sequence" value="FOLDER_SEQ"

which created the following under folder entity in my jbosscmp-jdbc.xml:

<entity-command name="folder-sequence" class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCOracleCreateCommand">
 <attribute name="sequence">FOLDER_SEQ</attribute>
 </entity-command>

I think this is the right way to do it don't you?

[lafr]

No, a different entity-command is not needed.
The standard entity-command "oracle-sequence" with different sequence-names per EntityBean is enough.