Yea thanks for correct this, so I'm getting the right resultSet in
console...
but still having problem thru ConnectorJ, "select last_insert_id()" returns
a String to me, rs.getString(1) throws no exception.........
Tea
> You don't select last_insert_id() from table.
> This will return the last_insert_id() for each row of the table.
> You just select last_insert_id().
>
> Tea Yu wrote:
>
> >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
