Troubleshooting
Problem
ERROR SQL State: 08S01 java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Connection reset by peer: socket write error (SCI87523)
Symptom
When the error occurred, all subsequent executions of the business process
failed with the same error until Gentran Integration Suite was restarted.
ERROR [LightweightJDBCAdapter] Error executing sql query "SELECT COUNT(*) AS
'Count' FROM dbo.Orders ord WHERE ord.GT_key IS NULL AND ord.PaymentsPending =
0 AND ord.Void = 0".
ERROR SQL Error Code: 0
ERROR SQL State: 08S01
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Connection
reset by peer: socket write error
ERROR [JDBCService] got a bad
connection, trying again
Cause
poolName.testOnReserve=true had not been set when the the connection pool was defined in the jdbc_customer.properties file. If poolName.testOnReserve is set to false,? GIS does not test the connections before being placed in the connection pool,? or before being put back into the connection pool after being used. If the? database referenced by the connection pool? is? shutdown for any reason while GIS is still running, then the connections stored in the connection pool become invalid.? Even if the database is restarted, the connections stored in the pool are not refreshed.
In addition, if poolName.testOnReserve is set to true, but the poolName.testOnReserveQuery is not correct, or does not return the correct results, GIS will also display the following error in the system.log file: ERROR [JDBCService] got a bad connection, trying again
Resolving The Problem
The only supported method to reestablish the pool connections in the GIS Release 3.1 is to restart the GIS application. For that reason, the database should never be shut down while GIS is running, even if the database is accessed only through an external pool connection.
Historical Number
PRI6725
Product Synonym
[<p><b>]Fact[</b><p>];Gentran Integration Suite;Release 3.1.00 [<br/>] Lightweight JDBC Adapter [<br/>] ;Microsoft SQL Server database [<br/>] SCI87523
Was this topic helpful?
Document Information
Modified date:
11 February 2020
UID
swg21529877