tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Parsons Technical Services" <parsonstechni...@earthlink.net>
Subject Re: Please help on my DB pool problem --- I followed the struction on the web
Date Mon, 03 May 2004 01:17:39 GMT
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" <ericnoel@mylife.ph>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
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: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message