Subject Re: [Firebird-Java] Getting back auto-generated primary key...
Author Roman Rokytskyy
> What I need to do, is when I create a new record, I need to know
> what the primary key of this newly created record is. I've tried
> with the getGeneratedKeys method of the PreparedStatement this is
> there for this reason, but it seem that this method as not been
> implemented in the latest version of the JDBC driver.

The problem is not the driver, but the database server - there is no chance
to get it back.

> What should I use to get back this value?

No change. You have to get the value first with SELECT gen_id(my_generator,
1) FROM rdb$database and then set that value in the INSERT statement. You
can optimize the database calls by fetching a block of IDs with, for
example, gen_id(my_generator, 100) and then increment them in your
application.

> I really need a solution for this problem.

That's the only solution available at present time. But please post a
feature request either to firebird-support or firebird-devel list. The more
often people request that feature, the more probable is that it will be
implemented.

Roman