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

[Daxin Zuo]

I thought Microsoft was the best.
My jsp file is in tomcat\webapps\ROOT\zuo. In my
tomcat\webapps\ROOT\WEB-INF\web.xml, there is no <context> block, should I
create one or use <resource-ref>?
If I need ot create a <context> block, Is the code bellow correct:
<context path="/zuo" docBase="ROOT" debug="0" privileged="true">
....
</context>

Thanks

-----Original Message-----
From: Eric Noel [mailto:[EMAIL PROTECTED]
Sent: Sunday, May 02, 2004 5:55 PM
To: Tomcat Users List
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]