On Wednesday, August 28, 2002, 9:51:29 AM, John wrote:
TJ> As far as I know, there is no connection pooling built-in to tomcat that
TJ> actually works. The traffic I have seen on this list has people rolling
TJ> their own, using open source pooling solutions like poolman or DBCP, or
TJ> using the pooling that comes from third-party driver vendors. Which one are
TJ> you using? That might give the list a better indicator of what's wrong.
I apologize for not being more clear. I see that now looking at
the documentation that DBCP is not Tomcat's pooling, which is the
one I am now trying to use.
I've also tried
http://connpool.jensn.de/index.html which I saw recommended on the
list and ran into the same problems when connections get killed.
I also tried this one with the same results:
http://www.bitmechanic.com/
Thanks for any more information. I do appreciate it.
>> -----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]>
