MySQL Forums
Forum List  »  InnoDB

Re: Failed to read auto-increment value from storage engineI
Posted by: Frank Paterra
Date: February 06, 2009 01:15PM

I just started to get this as well. Is there a known solution?

My table looks like:
+---------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+------------------+------+-----+---------+----------------+
| submissionKey | int(10) unsigned | NO | PRI | NULL | auto_increment |
| fromAddress | varchar(128) | NO | | NULL | |
| fromName | varchar(128) | NO | | NULL | |
| subject | varchar(128) | NO | | NULL | |
| sentTime | datetime | NO | | NULL | |
| state | varchar(45) | NO | | NULL | |
+---------------+------------------+------+-----+---------+----------------+
6 rows in set (0.05 sec)

And my code looks like:
statement = dbCon.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY,java.sql.ResultSet.CONCUR_READ_ONLY);
statement.execute(query,Statement.RETURN_GENERATED_KEYS);

where statement is of type Statement and query is of type String. For fun I tried removing the argument java.sql.ResultSet.CONCUR_READ_ONLY from the statement.execute call and I still get the same error.

Thanks for any help!

Frank

Frank Paterra
fcp@wittykids.com

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Failed to read auto-increment value from storage engineI
6010
February 06, 2009 01:15PM


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.