Re: Failed to read auto-increment value from storage engineI

[Frank Paterra]

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
[e-mail]