Hello,
For some reason when i use tomcat 's (4.1.30 ) jndi pooling with
MSSQL, i get this
error. Connection reset by peer: socket write error(CODE=-1)
I suspect that the problem is with the fact that connections go
stale. is there a way for me to force connection to be renewed, or
for connection pooling to check if connection is stale?
alex k.
<Resource auth="Container"
name="jdbc/WBTPCDataSource" scope="Shareable" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/WBTPCDataSource">
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>10</value>
</parameter>
<parameter>
<name>driverName</name>
<value>jdbc:microsoft:sqlserver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=WB_TPC;SelectMethod=Cursor</value>
</parameter>
<parameter>
<name>password</name>
<value>password</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
<parameter>
<name>username</name>
<value>user</value>
</parameter>
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>
<value>2</value>
</parameter>
<parameter>
<name>logAbandoned</name>
<value>true</value>
</parameter>
</ResourceParams>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
