Re: ID of last insert from DB2 table - JDBC JAVA

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Dundonald wrote:

>
> mark.dun... wrote:
>> I may have to migrate the database a Java application uses from
>> MySQL
>> to DB2. I am currently assessing the impact. One item I'm
>> currently looking at is that of obtaining the ID of an insert
>> immediately after the operation.
>>
>> For example with the MySQL database I would perform the following
>> command:
>>
>> long lastInsertedID =
>> ((com.mysql.jdbc.Statement)statement).getLastInsertID();
>>
>> The statement variable is of type java.sql.Statement.
>>
>> If I port over to DB2 I am concerned I cannot replace this
>> functionality. A method such as .getLastInsertID() is not
>> available from java.sql.Statement.
>>
>> Is there a solution if I port to DB2?

Hi,

How about the standard method java.sql.Statement.getGeneratedKeys()? I
know it works with MySQL, but I'm not sure about DB2 (never used it).
It's all dependent on whether the driver implements the method or
not.

Chrs
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (GNU/Linux)

iD8DBQFCBmU/gxSrXuMbw1YRAlyFAKCkN9Jzq2nNzBauwfRynNrKynRDzQCdHOZO
nkKxoVdVhDYZ8dnwTqLG3Bc=
=Pg17
-----END PGP SIGNATURE-----