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 ]