Strange Exception on getGeneratedKeys() with JDBC for MySQL 5.1

Question

Hello,

I'm using JDBC to insert a row into a MYSQL database. I build a parameterized command, execute it and attempt to retrieve the auto generated keys as follows:

String sql = "INSERT IGNORE INTO `users` (`email`, `pass-hash`) VALUES (?, ?)";
Connection conn = SQLAccess.getConnection();
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, login);
ps.setString(2, passHash);

int count = ps.executeUpdate();

if (count == 1) {
    ResultSet rs = ps.getGeneratedKeys();
    rs.next();
         //some more stuff...
}

For some reason, I get the following SQLException on the line containing ResultSet rs = ps.getGeneratedKeys();:

!Statement.Generated Keys Not Requested!

Any thoughts? When I run the same query, as generated by running the app through the debugger, in a MySQL browser it executes without incident.

Thanks, brian

Answer 1

I think you want to call prepareStatement(sql, RETURN_GENERATED_KEYS)

Answer 2

The method getGeneratedKeys() is in JDBC 3.0 API and this is not useable on all platform.

And PreparedStatement does not have getGenerateKeys() 's implement and it is only in Statement and is a abstract method.

Here is a topic about this method's issue : http://forums.sun.com/thread.jspa?threadID=260818