Hi! I just tried
Windows ME + MySQL Server - 4.0.9/4.0.11 +
ConnectorJ - 3.0.4/3.0.6/3.1.0
with an InnoDB table
test (id bigint not null auto_increment, name varchar(255))
also tried
test (id int not null auto_increment, name varchar(255))
and did an SQLQuery thru JDBC
insert into TABLE (name) values ('test');
select last_insert_id() from TABLE;
but got the Exception
java.sql.SQLException: Invalid value for getInt() - 'q'
while successive running of program returns
'r', 's', 't'...
Query from console returns the correct result, but it returns n rows in set
if last_insert_id() is n
e.g. if select last_insert_id() = 7, 7 rows are returned in set
Is there a bug in ConnectorJ regarding this... seems nobody else is having
such a problem...?
Best regards
Tea
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
