Hello All,
We have tomcat running on the Linux and MSSQL on the
win2k .
after few queries to database tru servlet we get
following exception.We are using JNDI DBCP for the
conntionpooling.
Error -----
RemoveAbandonedTimeout: 300
java.sql.SQLException: [Microsoft][SQLServer 2000
Driver for JDBC]Connection reset
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.TDSRequest.processReply(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.getImplConnection(Unknown
Source)
at
com.microsoft.jdbc.base.BaseStatement.setupImplConnection(Unknown
Source)
at
com.microsoft.jdbc.base.BaseStatement.<init>(Unknown
Source)
at
com.microsoft.jdbc.base.BasePreparedStatement.<init>(Unknown
Source)
at
com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown
Source)
at
com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown
Source)
at
org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:216)
at
org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:323)
at
com.apsora.servlet_1.AvailServlet.getAvailableTickets(AvailServlet.java:303)
at com.apsora.servlet
Till now I have two options :
Use autoReconnect =true
and use validation query.
But not sure which is correct and could not get the
exact syntxz to add AutoReconnect=true.
Thanks in advance...
We are in BIG trouble,.
Sincerly
rahul
__________________________________
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
