470,821 Members | 1,983 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,821 developers. It's quick & easy.

getGeneratedKeys() problem

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
1 1969
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.

Similar topics

reply views Thread by Bruce Davis | last post: by
11 posts views Thread by Kostatus | last post: by
9 posts views Thread by Sudesh Sawant | last post: by
117 posts views Thread by Peter Olcott | last post: by
28 posts views Thread by Jon Davis | last post: by
6 posts views Thread by Ammar | last post: by
2 posts views Thread by Mike Collins | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.