Statement.getLastInsertID( ) returns a different number than what I expect

[supun edirisinghe]

I'm using connector/J 3.0 - general release.

I'm inserting a row to an autoincremented int primary keyed table and then inserting the id of that insert into another able. I want to use Statement's getLastInsertID( ), but that gives me a number much smaller than the actual biggest ID in the table. I'm managing my connections so that only one thread goes through the code at any one time, and my application is the only client that will access the db. When I execute my statements in the command line mysql client and get the last inserted ID via "select LAST_INSERT_ID()" it works as expected.

Is there a bug in the in my version of connector J? anybody else see this behavior?

thanks