AutoIncrement primaryKey

[Mukti Furtado]

Hello,

I want to automatically increment the primary key field in the database(MySql) in a CMP bean. I have written the following lines in the jbosscmp-jdbc.xml
<unknown-pk>
<unknown-pk-class>java.lang.Integer</unknown-pk-class>
<field-name>userID</field-name>
<column-name>userID</column-name>
<jdbc-type>INTEGER</jdbc-type>
<sql-type>INT(11)</sql-type>
<auto-increment/>
</unknown-pk>
<entity-command name="mysql-get-generated-keys"/>
But when i get a Nullpointer exception when i try to insert a record through my CMP.
Can you please tell me where i am going wrong
Thanks

[Yuan Ye]

looks like you need the class name and method to be defined for the entity-command. You can refer to the following link.
http://www.coredevelopers.net/library/jboss/cmp/keygen.jsp#mysql