How to return Primary Key (autonumber) after an Insert
posted 14 years ago
Hi all, I am developing an Intranet system. Anyway I'm purely using JSPs to do it. And I have no problem doing the usual SQL commands. However, I have a problem now. I need to return the automatically incremented Primary Key after I insert a new record. I have also developed web apps using ASP before and used the cursor bookmarks. JSP is a tad different so if someone could help me, I'd be forever in their debt!! Other Information: I'm using DB2 as my database. Using Websphere Studio as my development environment. Using Websphere Test Environment (in VAJ) to run the JSPs. Thanks in Advance! -Tony
Unlike ASP, Java code is expected to be able to "run anywhere", which often means not supporting features that are unique to a given vendor's DBMS, such as auto-incrementing keys (I know it's a common feature, but it's not in the SQL standard). So from a purely portable perspective, there's nothing you could latch on to. For a particular vendor's DBMS, however, you may find an extra driver function or the like - check their jdbc docs. Or, if you're using SQL Server, someone else's jdbc docs, since Microsoft doesn't provide a Java driver. This problem gets even worse when working with Enterprise JavaBeans, where the key is expected to be known BEFORE the record is added - so much so, that I expect Sun will eventually have to provide a rathole for it.
An IDE is no substitute for an Intelligent Developer.