Focal Point
[CLOSED] Communications link failure during commit().

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/3977078096

October 24, 2018, 10:43 AM
Suga
[CLOSED] Communications link failure during commit().
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,


WebFOCUS 8
Windows, All Outputs
October 24, 2018, 04:51 PM
Suga
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"


WebFOCUS 8
Windows, All Outputs
October 26, 2018, 01:16 PM
FP Mod Chuck
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.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats