Hi,

i want to get back a auto generated key from v8.1 DB2 express.
So i used a JDBC 3.0 feature:

s.execute(sql, Statement.RETURN_GENERATED_KEYS);
ResultSet generatedKeysRes = s.getGeneratedKeys();

i got the error:

com.ibm.db2.jcc.c.SqlException: JDBC 3 method called - not yet supported

But an IBM document says that:
supportsGetGeneratedKeys | Yes | No | No

YES: DB2 Universal JDBC Driver support
NO: JDBC/SQLJ 2.0 Driver for OS/390 support
NO: DB2 JDBC Type 2 Driver support

http://publib.boulder.ibm.com/infoce...d/rjvjdapi.htm

So is the Type4 db2jcc.jar the same as the Type2 Driver. And how can i find the DB2 Universal JDBC Driver? Is it db2java.jar ?

Thanks for infos.

com.ibm.db2.jcc.DB2Driver can be used as type 2 or type 4

The distinction comes beased on the connection URL parameter:

if the URL pattern is "jdbc:db2://server:port/DB_INSTANCE" it points Type 4

&

if the URL pattern is "jdbc"db2:DB_INSTANCE" it points to Type 2.

-Jeeva

yeah thanks for pointing that out, but also with Type2 access, i cant get getGeneratedKeys() working. Db2 allways says "JDBC 3 Method not supported yet".

This is crazy.

yeah,

the documentation you had reads:

In addition to the other forms of execute or executeUpdate, the DB2 Universal JDBC Driver supports the following JDBC 3.0 forms:
executeUpdate(String sql, int autoGeneratedKeys)
execute(String sql, int autoGeneratedKeys)


That means type 2 wouldnt support but type 4 should...


Dont know why it wouldnt!

-Jeeva

Did you make sure that your server version corresponds to that of this documentation?

No, since my 8.1 is not too old, i thought it must be current.
But i can check if there are any updates available, just to be sure.

This is my version:
Stufe des DB2-Verwaltungstools:
Produkt-ID SQL08012
Aktualitäts-ID 02030106
Level DB2 v8.1.2.169
Buildlevel s030508
PTF WR21318

Just in case you havent notices, the documentation seem to refer upto 8.1.4.
You may to find when exactly JDBC 3.0 support was added.
I tried to search, but no use..

Good Luck!

Yeah, i know. I am just downloading FixPack4, just to be sure thats not a version problem. (cant imagine though)

after upgrading to Fixpack4, getGeneratedKeys() is supported now. I am still using Type4 Universal JDBC driver (db2jcc.jar). The addition was not mentioned in the FIxPack release docs though. Anyway, i am happy that i can proceed...