Re: JSP connection to database problem

[Duffey, Kevin]

Title: JSP connection to database problem

Might I add that if this is not a prototype I would strongly suggest moving all business logic and connections out of your JSP pages and into an MVC framework like Struts or Theseus. If your application is anything more than a few pages and you might possibly have others having to eventually maintain this, it will end up a holistic nightmare. Using Struts or Theseus with JSP only to display a View (and at that, use Tag-libs for things like form elements, iterations of lists, etc), and allow the servlet/action classes control how the business logic is done, then possibly use EJB for the business logic you will improve the managability of your application by a magnitude, not to mention you will most likely be that much closer to having a scalable application if it is something you require.   FYI.   -----Original Message----- From: Lance Lavandowska [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 22, 2001 6:41 PM To: [EMAIL PROTECTED] Subject: Re: 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 ----- From: Bruce Wexler To: [EMAIL PROTECTED] 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