Would you be able to tell me how i should tie poolman to tomcat. this is what my server.xml looks like <ResourceParams name="SQLServerDS"> <parameter> <name>validationQuery</name> <value></value> </parameter> <parameter> <name>user</name> <value>sa</value> </parameter> <parameter> <name>maxWait</name> <value>5000</value> </parameter> <parameter> <name>maxActive</name> <value>5</value> </parameter> <parameter> <name>password</name> <value>sa</value> </parameter> <parameter> <name>url</name>
<value>jdbc:microsoft:sqlserver://dnas07:1113;DatabaseName=Northwind</value> </parameter> <parameter> <name>driverClassName</name> <value>com.codestudio.sql.PoolMan</value> </parameter> <parameter> <name>maxIdle</name> <value>10</value> </parameter> </ResourceParams> But tomcat still seems to use the DBCP factory. What do i need to change in the above code in order to make tomcat use poolman. i neeed to have a module ready by end of the week and hence the hurry. Thanks a ton Amitabh -----Original Message----- From: Mike Jackson [mailto: Sent: Monday, September 23, 2002 5:28 PM To: Tomcat Users List; [EMAIL PROTECTED] Subject: RE: Poolman Configuration Use poolman. Poolman good. If you can wait until next week I can send you a copy of my config file (out of the office until then). And I'll even throw in a sql server example as well (even though I use Oracle primarily). --mikej -=----- mike jackson [EMAIL PROTECTED] -----Original Message----- From: Amitabh Dubey [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 11:11 AM To: Tomcat Users List Subject: RE: Poolman Configuration DBCP does not work well with SQL Server, so i was told. I guess i will have to look into some commercial product then. Any suggestions? Thank you Amitabh -----Original Message----- From: Rick Fincher [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 1:06 PM To: Tomcat Users List; [EMAIL PROTECTED] Subject: Re: Poolman Configuration Is anybody still developing Poolman? I heard the original developer retired it. If you are just starting out you might want to use another connection pooling package like DBCP in the Jakarta Commons project, so you don't get locked into a defunct product. This is from the web site listed on SourceForge as Poolman's home page (www.codestudio.com): PoolMan is no longer available or supported through this site. It did exceedingly well during its lifetime, and I appreciate the important role it played in so many distributed applications over the past three years. If you are looking for connection and object pooling mechanisms, they can now be found in application servers such as JRun, Tomcat and the Jakarta Project, and other J2EE products and servers. -PS Neville Rick ----- Original Message ----- > Does anyone have poolman successfully configured. If so, please could you > post your poolman.xml. If you have used it with SQL Server, then that would > be perfect. > > Thanks > Amitabh -- 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]>