When you say "Tomcat's connection pooling" what do you mean exactly?
As far as I know, there is no connection pooling built-in to tomcat that actually works. The traffic I have seen on this list has people rolling their own, using open source pooling solutions like poolman or DBCP, or using the pooling that comes from third-party driver vendors. Which one are you using? That might give the list a better indicator of what's wrong. John Turner [EMAIL PROTECTED] > -----Original Message----- > From: Rick Reumann [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 28, 2002 9:37 AM > To: Tomcat Users List > Subject: tomcat conn pooling question > > > Sorry if this is a repeat post. (I'm not sure if I posted > this question > here or not as I was trying to switch from digest mode to regular list > mode on this list and I ended up unsubscribing from the list so didn't > get messages for a while). > > QUESTION: > > I've configured Tomcat's connection pooling according to Tomcat's docs > http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-resources > -howto.html > any everything seems to work fine unless someone manually kills the > open connections (or something else causes the connections to go > down). When the connections are manually killed the connection pooling > ceases to work and the application breaks since it gets sql errors > from the conn pool of > java.sql.SQLException: ORA-01012: not logged on > > Is there a way to make sure the connection pooling goes back to > working if the app somehow has it's open connections killed? > I thought adding the validationQuery to the ResourceParams configured > in the server.xml file would help, but it doesn't. > > <parameter> > <name>validationQuery</name> > <value>SELECT 'CRAP' FROM DUAL</value> > </parameter> > > Thanks for any help. > > -- > > Rick > mailto:[EMAIL PROTECTED] > > > -- > 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]>