JSP --> Servlet --> JDBC

[Don Clarke]

hello,
i'm having a problem figuring out how to tie together an JSP page that calls a servlet, with a JDBC java class i have. the jdbc class makes a connection with the database. separatly, i have a working JSP page that calls a servlet. i'm trying to tie together the variables i'd enter into my jsp page with the stored procedure call in my JDBC class that connects to the database.
please help, i'm stumped.

[Steve Granton]

Hi,
How are you calling the servlet from the JSP? Are you using the request dispatcher, sending a redirect or doing something in a jsp scriptlet? Or is your user submitting a page to the servlet that was produced by the jsp?
If you could give a general description of your architecture, how things work and what classes you have that would be good.
Generally, if the user submits a form then the servlet would process the request (retrieving any parameters it needs), possibly with helper classes. The parameters can then be used raw or encapsulated in value objects. Any calls to the database could be made from the servlet or helper/DAO classes.
Cheers,
Steve
[ April 16, 2002: Message edited by: Steve Granton ]

[Jessica Sant]

Also, try to use JDBC 2 Datasources -- that way you'll take advantage of any Connection Pooling your Application Server Provides.
Check out Chapter 7, "Connecting to Resources" in the HP-AS Developer's Guide:
[ April 16, 2002: Message edited by: Jessica Sant ]