Title: JSP connection to database problem
Check out DBTags at jakarta.apache.org/taglibs
 
It has support for stored procedures (I believe) and should greatly simplify what you are trying to do.
 
Lance
----- Original Message -----
Sent: Wednesday, August 22, 2001 8:05 PM
Subject: JSP connection to database problem

Hello,
I am using a database connection (conn1) in my JSP include page which is connecting to the first (SQL 7) database with a stored procedure. The stored procedure is performing a query which utilizes tables in another database on the same server. I have also tried to use a second database connection, and an inline query, but still get an error. Can someone please tell me what I am doing wrong? Is it even possible to do this with JSP? I've been able to use two databases in ASP, so I wasn't sure about making this work in JSP. Below is the JSP page and stored procedure.

TIA,
Bruce Wexler
Programmer/Analyst

Reply via email to