JDBC Error with Tomcat 4.0.6

[John Mattos]

All,

I need a little help with this one. I'm porting an app to Tomcat 4.0.6 from WebSphere 
4.03 and I'm getting a JDBC Error, 

java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Error establishing socket.

I've included a bit about my app to see if anyone can help me figure out where my 
misconfiguration is.

Am I using the right driver for SQL Server 2000? (I'm using msutil.jar, 
mssqlserver.jar and msbase.jsr, the native drivers) Should I be using a different 
class? Is my JDBC URL not formed properly? 

I guess I need help from a SQL Server/Tomcat guru...

Thanks!

John 

Server.xml file snippet : 
<ResourceParams name="jdbc/indemand">
         <parameter>
           <name>validationQuery</name>
           <value>select top 100 * from Subscriber</value>
         </parameter>
         <parameter>
           <name>url</name>
          
<value>jdbc:microsoft:sqlserver://vc34:1433;databaseName=TibcoClearHouse</value>
         </parameter>
         <parameter>
           <name>password</name>
           <value>tibco_pass</value>
         </parameter>
         <parameter>
           <name>maxActive</name>
           <value>12</value>
         </parameter>
         <parameter>
           <name>maxWait</name>
           <value>5000</value>
         </parameter>
    <parameter>
            <name>driverClassName</name>
            <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
    </parameter>
         <parameter>
           <name>username</name>
           <value>tibco_user</value>
              </parameter>
</ResourceParams>

Web.xml file snippet:
  <resource-ref>
      <description>DB Connection</description>
      <res-ref-name>jdbc/indemand</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
  </resource-ref>

Partial Stack trace:
java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Error establishing socket.
        at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
        at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
        at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
        at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
        at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
        at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
        at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
        at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:140)
        at 
com.thoughtworks.util.pool.JDCConnectionPool.getConnection(JDCConnectionPool.java:174)
        at 
com.thoughtworks.clearinghouse.util.ConnectionFactory.createConnectionForTibco(ConnectionFactory.java:59)
        at 
com.thoughtworks.clearinghouse.util.ConnectionFactory.createConnection(ConnectionFactory.java:40)
        at 
com.thoughtworks.clearinghouse.util.DatabaseUtility.getUserByName(DatabaseUtility.java:123)



---------------------------------
Do you Yahoo!?
HotJobs - Search new jobs daily now