Re: Connector J (3.1.0) - invalid return upon select last_insert_id()

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tea Yu wrote: Not really, I substituted the queryStmt with the actual one but it gave the same result. After some work: select last_insert_id();//getInt() should return 14 //but now it gives

Re: Connector J (3.1.0) - invalid return upon select last_insert_id()

The only way I can debug this is if you give me a repeatable test case. Since the test case I showed you does not repeat the bug, you will need to generate a standalone test case, with schema, data, and the java code that demonstrates the issue. -Mark Hey mark, here are the files that

Re: Connector J (3.1.0) - invalid return upon select last_insert_id()

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tea Yu wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tea Yu wrote: Hi there! Sorry, cause I didn't copy-n-paste those so there were typos, actually I created the table in console: 1) create table test (id INTEGER NOT NULL AUTO_INCREMENT, name

Re: Connector J (3.1.0) - invalid return upon select last_insert_id()

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

Re: Connector J (3.1.0) - invalid return upon select last_insert_id()

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 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

Re: Connector J (3.1.0) - invalid return upon select last_insert_id()

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

Re: Connector J (3.1.0) - invalid return upon select last_insert_id()

Hi there! -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 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

Re: Connector J (3.1.0) - invalid return upon select last_insert_id()

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

Re: Connector J (3.1.0) - invalid return upon select last_insert_id()

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tea Yu wrote: Hi there! -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 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,

Re: Connector J (3.1.0) - invalid return upon select last_insert_id()

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tea Yu wrote: Hi there! Sorry, cause I didn't copy-n-paste those so there were typos, actually I created the table in console: 1) create table test (id INTEGER NOT NULL AUTO_INCREMENT, name VARCHAR(255), primary key (id)); 2) here