By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,237 Members | 1,228 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,237 IT Pros & Developers. It's quick & easy.

getGeneratedKeys() problem

P: n/a
Hi,

I am using IBM DB2 JDBC 2.0 Type 2 driver and understandably I am
getting an exception when I call getGeneratedKeys() (Not supported on
the webspehere java.sql.conenction implementation).
Is there any other to get the keys other than doing another query to
get the key. It may not be relaiable if the key is the only unique
column.

Any help would be greatly appreciated.

Thanks.

- MK

Oct 14 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
SELECT <keycolFROM NEW TABLE(INSERT INTO T(c1) VALUES (?))

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Oct 14 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.