aspose file tools*
The moose likes JDBC and the fly likes JDBC Connection error to SQLSERVER 2005 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC Connection error to SQLSERVER 2005" Watch "JDBC Connection error to SQLSERVER 2005" New topic
Author

JDBC Connection error to SQLSERVER 2005

Revathy Raj
Greenhorn

Joined: Aug 16, 2008
Posts: 2
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 ]

Reva
Jaikiran Pai
Marshal

Joined: Jul 20, 2005
Posts: 10288
    
168

jdbc:sqlserver://127.0.0.1\MSSMLBIZ,1433


Are you sure this database URL is correct?


[My Blog] [JavaRanch Journal]
Revathy Raj
Greenhorn

Joined: Aug 16, 2008
Posts: 2
Tried with url="jdbc:sqlserver://REVATHY-PC\MSSMLBIZ,1433;DatabaseName=DW; SelectMethod=cursor" But the same issue comes. Any help??
Rene Larsen
Ranch Hand

Joined: Oct 12, 2001
Posts: 1179

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:



Regards, Rene Larsen
Dropbox Invite
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC Connection error to SQLSERVER 2005