getGeneratedKeys returns an empty resultset
Posted by: amol k
Date: December 09, 2004 10:11AM

I am using mysql jdbc driver 3.0.16
The code inserts a row in a table which has one auto_inc column of type int using a preparedstatement.
The row gets inserted which I can see from the querybrowser (with the right data in all the 3 columns including auto_inc column) but when I do a getGeneratedKeys() on the prepared statement, it returns an empty result set.
Any idea?

I tried execute() instead of executeQuery() but still the same blank resultset.

Options: ReplyQuote

Written By
getGeneratedKeys returns an empty resultset
December 09, 2004 10:11AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.