Daxin, I think this would be well worth your time and effort to change to this. I was unaware of it or I would have recommended it.
The reason for the other stuff you were asking about was because that is how microsoft had set it up to be used. This should give much cleaner and portable code. As I am running against MySQL I cannot test it, but will help you get it going. Thanks for the info Eric. Doug ----- Original Message ----- From: "Eric Noel" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> Sent: Sunday, May 02, 2004 8:55 PM Subject: Re: Please help on my DB pool problem --- I followed the struction on the web > why not use jtds instead http://jtds.sourceforge.net/ > > ## download the jtds jar > http://heanet.dl.sourceforge.net/sourceforge/jtds/jtds-0.7.1.jar > ## place it in your common/lib > > ## server.xml > <Resource name="jdbc/DirectSQL" auth="Container" > type="javax.sql.DataSource"/> > <ResourceParams name="jdbc/DirectSQL"> > <parameter> > <name>factory</name> > <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> > </parameter> > <parameter> > <name>maxActive</name> > <value>3</value> > </parameter> > <parameter> > <name>maxIdle</name> > <value>1</value> > </parameter> > <parameter> > <name>maxWait</name> > <value>10000</value> > </parameter> > <parameter> > <name>username</name> > <value>DBUSERNAME</value> > </parameter> > <parameter> > <name>password</name> > <value>DBPASSWORD</value> > </parameter> > <parameter> > <name>driverClassName</name> > <value>net.sourceforge.jtds.jdbc.Driver</value> > </parameter> > <parameter> > <name>url</name> > <value>jdbc:jtds:sqlserver://SERVERNAME/DBNAME</value> > </parameter> > </ResourceParams> > > > ## web.xml > <context-param> > <param-name>javax.servlet.jsp.jstl.sql.dataSource</param-name> > <param-value>jdbc/DirectSQL</param-value> > </context-param> > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]