Re: Please help on my DB pool problem --- I followed the struction on the web

[Eric Noel]

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]