Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Programming > Java Beans > Obtaining SQL i...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 4 Topic 1386 of 1403
Post > Topic >>

Obtaining SQL insert auto generated key from query within JSP

by Damon Getsman <dgetsman@[EMAIL PROTECTED] > Sep 11, 2008 at 07:26 AM

Okay, this posting is about JSP, not pure Java, but I couldn't find a
more proper newsgroup(s) for it.

I am doing an <sql:insert> from within a .jsp file.  Unfortunately at
this point doing the insert from within a bean is not possible.
Unfortunate, but that's the way it is.  Anyway, I need to be able to
determine the auto generated primary index field for the record that I
am inserting for further processing beyond this point.  For the life
of me I have not been able to find out how to do this.  I've tried
googling, researching on sun.com, looking in the ORA book on JSP, and
the book Beginning JSP 2: From Novice to Professional.  I have yet to
turn up anything that tells me how to retrieve this key.

Can anybody give me a pointer on how to do this from within JSP?  I
have a deadline to meet here and this small issue is really cutting it
close for me.

Thanks in advance.

Damon Getsman
-=-=-
Programmer/Systems Administrator
ITRx - http://www.itrx-nd.com/
-=-=-
 




 4 Posts in Topic:
Obtaining SQL insert auto generated key from query within JSP
Damon Getsman <dgetsma  2008-09-11 07:26:04 
Re: Obtaining SQL insert auto generated key from query within JS
Damon Getsman <dgetsma  2008-09-11 07:30:10 
Re: Obtaining SQL insert auto generated key from query within JS
Mark Space <markspace@  2008-09-11 11:51:43 
Re: Obtaining SQL insert auto generated key from query within JS
Damon Getsman <dgetsma  2008-09-11 13:21:43 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed Dec 3 23:47:07 CST 2008.