Go4Expert (http://www.go4expert.com/)
-   JSP (http://www.go4expert.com/forums/jsp/)
-   -   JSP to mainframe DB2--global connection? (http://www.go4expert.com/forums/jsp-mainframe-db2-global-connection-t22669/)

mhb22079 9Jul2010 20:19

JSP to mainframe DB2--global connection?

I've built some JSP pages on my corporate Tomcat server that successfully attach to DB2 however the performance is pretty bad. I'm using JDBC. I believe it is related to opening and closing the connection multiple times but am unsure how to proceed.

My site uses 3 vertical frames (header, menu, and content pages) accepts several fields from a user and executes a DB2 query based on the data entered. A submit button calls the same JSP and displays the result of the query.

The issue I am having is that it seems that on each load of the JSP the connection seems to be automatically closed. If I open the connection on the first load of the JSP (when called from menu) and don't close it, on the query when the page is called again I get a Null pointer exception.

Sorry to be so wordy but I'm a mainframe programmer and pretty new to the workings of JSP and database connections. I would greatly appreciate any guidance as the best means to handle a database connection that would span multiple JSP pages (or the same JSP called to return results).


All times are GMT +5.5. The time now is 05:24.