George Sexton MH Software, Inc. 303 438-9585 www.mhsoftware.com
> -----Original Message----- > From: Bill Wang [mailto:bw57...@gmail.com] > Sent: Sunday, October 09, 2011 10:02 PM > To: Tomcat Users List > Subject: Re: two questions about the session timeout in tomcat > > Hi Chris, Pid & Geroge, > > ******************** > 6. @ Geroge > > Sorry, I don't understand your question. We DO have Oracle Database in > the > backend. > *********************************************************************** > ******************** > Are you storing objects on the session, in particular JDBC connections > or result sets? > *********************************************************************** > ******************** Sometimes developers will store JDBC connections or result sets on the session as attribution. They'll use the command session.setAttribute("ResultSet",MySQLResultSet); This makes things like paging easier, but you're holding open database connections for each session. It also consumes memory to hold them. I run a SaaS business with tomcat and each server has several hundred virtual hosts, and sees thousands of clients each day. Something's wrong with your app and this is almost certainly it. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
