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: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)