on 02-08-2007 8:25 PM
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 ?????
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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'.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.