hi

ERROR1:
I am getting
nj2c.readAndExecuteCommand():exception
ibi.ntj2c.ntjprerr.0001 008007 76Communications link failure during commit().
Transaction resolution unknown
(FOC1400) SQLCODE IS -1(HEX: FFFFFFFF)XOPEN: 08007
(FOC1415)COMMIT WORK ERROR


ERROR2:
ibi.ntj2c.ntjprerr.0001 008S01 483 The last packet successfully recevied from the server was 28,800,123 milliseconds ago. Server configure value of 'wait-timeout'.

You should consider either expiring and/or testing connection validity before use in your application
Connector/J connection property 'autocReconnect-true' to avoid. Please assist.

Thanks
Suga

This message has been edited. Last edited by: FP Mod Chuck,

I am reading the source file
ibi.ntj2c.ntjprerr.0001 008S01 483 The last packet successfully recevied from the server was 28,800,123 milliseconds ago. Server configure value of 'wait-timeout'.
You should consider either expiring and/or testing connection validity before use in your application Connector/J connection
property 'autocReconnect-true' to avoid.

I have my properties file:
client.url=jdbc.mysql://server1.5306/Database
client.driver=com.mysql.jdbc.driver
client.uid='user1'
client.pawd='pass'

Can I append these to resolve the above error?
client.autoreconnect=true
client.tesonBorrow="true"
client.validationQuery="SELECT 1"
client.validationInterval="50000"

Suga

Since no one has been able to provide you any guidance on this I suggest you open a case with techsupport if you haven't already.