No I'm afraid I don't. I don't use datasources at the moment just the old vanilla way of creating database connections.
> -----Original Message----- > From: Amitabh Dubey [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 23, 2002 4:51 PM > To: Tomcat Users List > Subject: RE: Tomcat Connection pooling > > > 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]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
