Sorry, I should have specified that I am using mysql version:
Server version: 5.1.30-community MySQL Community Server (GPL)
and jdk 1.5.0_17.
Frank
Frank Paterra Wrote:
-------------------------------------------------------
> 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_FORW
> ARD_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