Hi, I wonder how I can use auto-increament for the primary key in CMP? Since all primary keys are implemented as String in Andromda, I wonder if it can cause any problem when using auto-increament. By the way, I tried to add auto-increament in the jbosscmp-jdbc.xml but JBoss didn't accept the xml. I wonder if anybody ever used auto-increament for hsqldb. Here is what I added in the file:
<unknown-pk>
<unknown-pk-class>java.lang.String</unknown-pk-class>
<column-name>orderId</column-name>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR(256)</sql-type>
<auto-increment/>
</unknown-pk>
<entity-command name="hsqldb-fetch-key">
</entity-command>
<unknown-pk-class>java.lang.String</unknown-pk-class>
<column-name>orderId</column-name>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR(256)</sql-type>
<auto-increment/>
</unknown-pk>
<entity-command name="hsqldb-fetch-key">
</entity-command>
Thank you.
Carol.
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
