I’m using JDBC Adapter 6.0.2 to connect to a DB/2 database on an AS/400 with these settings:
Transaction Type: NO TRANSACTION
Datasource Class: com.ibm.as400.access.AS400JDBCDataSource
Other Properties: libraries=<library>
Services I create using this connection work fine. When I try to use anything the next day, however, I get this error:
com.wm.pkg.art.error.DetailedServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service EKANBAN.send:lookupOrder.
[ADA.1.316] Cannot execute the SQL statement “<sql>”. "
(HY000/-99999) Internal driver error.(Connection reset by peer: socket closed)"
Internal driver error.(Connection reset by peer: socket closed)
If I disable and re-enable the connection in wM Administrator, it works for the rest of the day.
I suspect something is happening to the connection during the AS/400’s overnight processing. Is there any way I can programmatically disable and re-enable the connection, so I don’t have to do it manually?