anyone? 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 : validationQuery select top 100 * from Subscriber url jdbc:microsoft:sqlserver://vc34:1433;databaseName=TibcoClearHouse password tibco_pass maxActive 12 maxWait 5000 driverClassName com.microsoft.jdbc.sqlserver.SQLServerDriver username tibco_user Web.xml file snippet: DB Connection jdbc/indemand javax.sql.DataSource Container 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.(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 --------------------------------- Do you Yahoo!? HotJobs - Search new jobs daily now
