This week's book giveaway is in the OCPJP forum.
We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line!
See this thread for details.
The moose likes JBoss/WildFly and the fly likes Adding Statement.RETURN_GENERATED_KEYS in jbosscmp-jdbc.xml Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "Adding Statement.RETURN_GENERATED_KEYS in jbosscmp-jdbc.xml" Watch "Adding Statement.RETURN_GENERATED_KEYS in jbosscmp-jdbc.xml" New topic

Adding Statement.RETURN_GENERATED_KEYS in jbosscmp-jdbc.xml

C Va

Joined: Feb 25, 2013
Posts: 1

I am using Xdoclet to generate an EJB. I am trying to migrate from mysql 4 to mysql 5 but I get an error:
Caused by: java.sql.SQLException: Generated keys not requested. You need to specify Statement.RETURN_GENERATED_KEYS to Statement.executeUpdate() or Connection.prepareStatement().

The question is, how can I specify Statement.RETURN_GENERATED_KEYS to JDBCMySQLCreateCommand?

My jbosscmp-jdbc.xml looks like this:



<entity-command name="mysql-get-generated-keys" class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCMySQLCreateCommand">
<attribute name="class-name">com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper</attribute>

Don't get me started about those stupid light bulbs.
subject: Adding Statement.RETURN_GENERATED_KEYS in jbosscmp-jdbc.xml