Error communication link failure...

[Former Member]

Hi all,

we r using RECEIVER JDBC adapter. whenever we leave JDBC adapter idle for some time & try process more messages after that.

we face a follwowing error :->>>

Java.SQLException:Communication link failure.(COnnection timed out(errorno:238))

What can i do to resolve this problem...

To make it work again we have to make it INACTIVE & ACTIVE again.....

Is this problem realted to server or anything else ?????

[Former Member]

Hi,

For sql server there is a connection property -loginTimeout - wchihc says how long the connection will be active before timing out...

Please the link below...

http://msdn2.microsoft.com/en-us/library/ms378988.aspx

Check also if for the particular user there can be a "no-timeout" property that can be set in the db properties(i donot know whether something like that is available)...

Thanks.

[former_member431549]

How often do messages come through this comm channel ? The suggestion below will help if not too often, but might cause performance issues if interface runs frequently.

Try selecting 'advanced mode' and 'disconnect from database after processing each message'.