I configured a JDBC database connecion with these paameters :
Connection Type JDBC Adapter Connection
Connection Properties
Transaction Type NO_TRANSACTION
DataSource Class com.microsoft.sqlserver.jdbc.SQLServerDataSource

Connection Management Properties
Enable Connection Pooling true
Minimum Pool Size 1
Maximum Pool Size 1000
Pool Increment Size 1
Block Timeout (msec) 1000
Expire Timeout (msec) 1000
Startup Retry Count 0
Startup Backoff Timeout (sec) 10

This connection is just used once a wek.
But each week ath the first use I get this error :
Connection reset by peer: socket write error

Do you know what can I do ?

Thanks by advance

first set Minimum Pool Size to 0 and check same error occurs , if yes increase

Block Timeout (msec) to 3000
Expire Timeout (msec) to 3000 and check.

Regards,
Anil Kumar Ellendula