I'm by no means a SQL Server expert, but based on the error I would guess the driver is not communicating with the server.
Can you connect to the database from the Tomcat server but outside of Tomcat (using some query tool)? -----Original Message----- From: John Mattos [mailto:mattosj@;yahoo.com] Sent: Tuesday, November 05, 2002 3:20 PM To: Tomcat Users List; [EMAIL PROTECTED] Subject: Re: JDBC Error with Tomcat 4.0.6 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.createConnectionForTib co(ConnectionFactory.java:59) at com.thoughtworks.clearinghouse.util.ConnectionFactory.createConnection(Conne ctionFactory.java:40) at com.thoughtworks.clearinghouse.util.DatabaseUtility.getUserByName(DatabaseUt ility.java:123) --------------------------------- Do you Yahoo!? HotJobs - Search new jobs daily now --------------------------------- Do you Yahoo!? HotJobs - Search new jobs daily now -- To unsubscribe, e-mail: <mailto:tomcat-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:tomcat-user-help@;jakarta.apache.org>
