Definition

1. Java Return_generated_keys
2. Java Sql Insert Statement
3. Sql Return Statement

Java.sql.Statement.RETURNGENERATEDKEYS on v6R1 fails - Hi, I have postet it yesterday, but I got some new information. The following code works fine with V5R4 but not on V6R1 I have created Table: drop table usraf.go1 create table usraf.GO1 ( govdc char(30) ) executed InsertStatement: AS400JDBCDataSource ds= n.

Overloads

Execute(String)Execute(String)	Executes a supplied SQL statement.
Execute(String, Int32)Execute(String, Int32)	Executes a supplied SQL statement.
Execute(String, Int32[])Execute(String, Int32[])	Executes the supplied SQL statement.
Execute(String, String[])Execute(String, String[])	Executes the supplied SQL statement.

Executes a supplied SQL statement.

Java Return_generated_keys

Parameters

Returns

Java Sql Insert Statement

Exceptions

if an error occurs accessing the database.

Remarks

Portions of this page are modifications based on work created and shared by the

Sql Return Statement

Thank you.

Greenhorn

posted 7 years ago

Hi.
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>
<ejb-name>OwnerDataEJB</ejb-name>
<datasource>java:jdbc/controlMysqlDS</datasource>
<datasource-mapping>mySQL</datasource-mapping>
<create-table>false</create-table>
<remove-table>false</remove-table>
<read-only>false</read-only>
<table-name>control.ownerdata</table-name>
<cmp-field>
<field-name>tsInit</field-name>
<column-name>ts_init</column-name>
</cmp-field>
<unknown-pk>
<unknown-pk-class>java.lang.Long</unknown-pk-class>
<auto-increment/>
</unknown-pk>
<entity-command name='mysql-get-generated-keys'>
<attribute name='class-name'>com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper</attribute>
</entity-command>
</entity>
Thanks