MySQL auto-increment problem

[vincentchun]

How to set auto-increment in JBoss with MySQL 4?

I use jboss-3.2.1_tomcat-4.1.24 and I have set auto_increment in MySQL.

In my jbosscmp-jdbc.xml, I have set the following:
<cmp-field>
<field-name>MessageID</field-name>
<column-name>MESSAGEID</column-name>
<auto-increment/>
</cmp-field>

In my ejb-jar.xml, I have set the following:
<prim-key-class>java.lang.Integer</prim-key-class>
......
<cmp-field >
<field-name>MessageID</field-name>
</cmp-field>
<primkey-field>MessageID</primkey-field>
......

It do not work, is there any extra setting for auto-increment setup?

or Can anyone post a MySQL auto-increment example?

[gonzaljo]

Hi


Enter below your last cmp-field entry in every entity which use auto-increment:

<entity-command name="mysql-fetch-key"/>

Then the auto-incremen will be generated.

[gonzaljo]

Sorry wrong key in entity command

Change like this

name="mysql-get-generated-keys"

[vincentchun]

Thanks for your help!

I have solve my problem!