Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

AutoIncrement primaryKey

 
Mukti Furtado
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 172
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic