This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets 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: 613
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 !!!
jQuery in Action, 2nd edition
subject: jsp and jdbc
Similar Threads
Login Validation In JSP
jsp insert into database error(java.lang.NumberFormatException: For input string: "")
java.sql.SQLException: General error
Null data issue