JDBC Connection error to SQLSERVER 2005

[Revathy Raj]

When I trying to start Tomcat I am getting the below error in stdout.log of tomcat. Can please someone help on this.

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The connection to the named instance has failed. Error: java.net.SocketTimeoutException: Receive timed out.)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at org.fourfive.lowservice.SimpleResourceManager.getConnection(SimpleResourceManager.java:536)


my operating system is vista and sql server is running as named instance

The connection string that i am using in server.xml is



<Resource type="javax.sql.DataSource" auth="Container" name="jdbc/sample" url="jdbc:sqlserver://127.0.0.1\MSSMLBIZ,1433;DatabaseName=DW;SelectMethod=cursor" maxIdle="2" validationQuery="select 1+2 " driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" maxActive="10" maxWait="500" autoCommit="true" username="newarcuser" password="newarcuser" factory="org.apache.commons.dbcp.BasicDataSourceFactory" removeAbandoned="true"></Resource>
[ August 16, 2008: Message edited by: Revathy Raj ]

[Jaikiran Pai]

jdbc:sqlserver://127.0.0.1\MSSMLBIZ,1433

Are you sure this database URL is correct?

[Revathy Raj]

Tried with url="jdbc:sqlserver://REVATHY-PC\MSSMLBIZ,1433;DatabaseName=DW; SelectMethod=cursor" But the same issue comes. Any help??

[Rene Larsen]

Here is how to build the connect URL: http://msdn.microsoft.com/en-us/library/ms378428.aspx

The 'instanceName' and 'portNumber' are not correct writen in your URL.

A correct URL should look like:

jdbc:sqlserver://localhost:1433;instanceName=instance1;integratedSecurity=true;.....