A better place to post a message like this is the USER list where there are more people to help you.
Though, this strategy is not directly related to Struts. You might want to check other resources, like JSP-Interest and JGuru. http://archives.java.sun.com/jsp-interest.html http://www.jguru.com/faq/home.jsp?topic=JSP -- Ted Husted, Husted dot Com, Fairport NY US -- Developing Java Web Applications with Struts -- Tel: +1 585 737-3463 -- Web: http://husted.com/about/services Georges wrote: > > Hi, > > I'm trying to build a small pilot application with Struts. > My ultimate goal is a dynamic web application with > intensive use of database. > My database is Oracle 8. > The problem is following: > in 'LoginAction' I set up a database connection > (java.sql.Connection variable) with Oracle > database. I "save" it > in the User session bean as a bean-variable. > Then I test it in a jsp-page. > Everything seems to work: the variable containing > the database connection is created and put into > User bean (something like ...setConnection(connection)). > The first time the jsp-page works well: the connection > comes from "conn=user.get_connection()", I can send > a select-query to the database and display the > outcome etc. > But if I refresh the jsp-page, then at a certain > moment an error message is displayed: > java.sql.SQLException: Closed Connection > > I undestand that the connection gets somehow > lost in the session bean. This happens especially > when I test with two parallel sessions > (one from IE and another from Netscape). > > Can anyone help me? Where could the connection go lost? > > Thanks, > George. > > P.S > I have to save a connection with every session > because this way I can get user info from > the database and administer database privileges. > I can't use just a connection pool and > get a connection from there every time I need > something from the database. > I have to lock records, maintain transactions etc., > so every user/session needs to have an > individual database connection. > > ----------------------------------------- > Teatri- , kino- ja kontserdipiletid nüüd hiirekliki kaugusel! > http://www.hot.ee > > ------------------------------------------------------------------------ > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
