File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JSP and the fly likes jsp and jdbc Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Java » JSP
Bookmark "jsp and jdbc" Watch "jsp and jdbc" New topic

jsp and jdbc

viral patel

Joined: Feb 25, 2003
Posts: 16
Hi..I have jsp page call sucess.jsp. which is basically get data from a form and stors in database. In my all table i created Sequences to generate accountID and stuff. Now when write my sql query..for example:
Insert into('"+accountId_sequence.NEXTVAL+"','"+viral+"'...);
it gives me error that it can find variable call accountID_squence...
SO my question is how can i store data from a form using Sequence from jsp page..
Praful Thakare
Ranch Hand

Joined: Feb 10, 2001
Posts: 641
Hi virla
try this out
Insert into.....("accountId_sequence.NEXTVAL"....)
i.e as accountId_sequence is defined in ur database give it in quotes !!!
or u can do this as well
rs=stmt.executeQuery("select accountId_sequence.NEXTVAL from dual");
String accountId_seq=rs.getString(1);
and then ur insert stuff ...
Hope this helps u
[ March 19, 2003: Message edited by: Praful Thakare ]

All desirable things in life are either illegal, banned, expensive or married to someone else !!!
subject: jsp and jdbc
It's not a secret anymore!