If DBCP is a problem, then do you have a working example of how i can use it with PoolMan?
Amitabh -----Original Message----- From: Barney Hamish [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 9:50 AM To: 'Tomcat Users List' Subject: RE: Tomcat Connection pooling Be careful if you decide to use DBCP with SQL Server. I found SQL Server drops open connections every 10 minutes or so, even while you're in the middle of retrieving query results!!! (so the verify connection thing doesn't work) DBCP needs some way of automatically dropping and recreating connections (like poolman does) if it's to be used with SQL Server. I haven't got around to submitting a patch to the DBCP Commons team to fix this. Hamish > -----Original Message----- > From: Turner, John [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 23, 2002 4:43 PM > To: 'Tomcat Users List' > Subject: RE: Tomcat Connection pooling > > > > I guess some advice is better than none. > > Have you checked out the Jakarta Commons DBCP pooling solution like I > recommended? Here's a link to how it was done with MySQL: > > http://marc.theaimsgroup.com/?l=tomcat-user&m=102225547106556&w=2 > > Have you checked out third-party SQL Server drivers? The drivers I am > familiar with have fully-functional trial periods and they > not only support > pooling but also JDBC 3.0. > > Have you checked out open source pooling solutions besides DBCP, like > poolman? > > John > > > > -----Original Message----- > > From: Amitabh Dubey [mailto:[EMAIL PROTECTED]] > > Sent: Monday, September 23, 2002 10:39 AM > > To: Tomcat Users List > > Subject: RE: Tomcat Connection pooling > > > > > > John, you are the only one who replied, and hence i took your > > advice and > > changed my subject and am reposting it. hopefully someone > > with an actual > > example of pooling with sql server can help me. > > > > Amitabh > > > > -----Original Message----- > > From: Turner, John [mailto:[EMAIL PROTECTED]] > > Sent: Monday, September 23, 2002 9:37 AM > > To: 'Tomcat Users List' > > Subject: RE: Tomcat Connection pooling > > > > > > > > Check your message list threads. I already replied to this > post this > > morning! Perhaps others have as well. > > > > John > > > > > > > -----Original Message----- > > > From: Amitabh Dubey [mailto:[EMAIL PROTECTED]] > > > Sent: Monday, September 23, 2002 10:33 AM > > > To: Tomcat > > > Subject: Tomcat Connection pooling > > > > > > > > > Hello Guys, > > > I have been working on this problem for 3 days now and > > > have not been able > > > to make Tomcat create a connection pool for me. This is my setup > > > > > > Database - SQL Server 2000 > > > Driver - JDBC Driver by microsoft > > > Tomcat - 4.1.2 (Packaged as part of JWSDK from SUN) > > > > > > I was able to successfully create and use connections using a > > > DataSource. > > > However, I want to use connection pooling and have no idea of > > > how I can do > > > so. If there is anyone who has been successful in creating a > > > DataSource > > > using a Connection pool with SQL Server, please could you > > > either send me a > > > snippet of your server.xml or tell me how i can go about > > > achieving pooling. > > > > > > Also, do i need Tyrex if i want to use connection pooling. I > > > have downloaded > > > it from their website anyways and placed in my > > > tomcat\common\lib directory. > > > How do i go about using this pool manager if this i what i > > > have to use with > > > tomcat to achieve pooling. > > > > > > Please HELP!! > > > > > > Thank you > > > Amitabh Dubey > > > > > > > > > > > > -- > > > 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]> > > > > > > > > -- > > 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]> > -- 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]>
