Link to home
Start Free TrialLog in
Avatar of TadHawkins
TadHawkins

asked on

Sybase JDBC connection dies intermittantly

We have a web service that executes stored procedures on our SYbase database and intermittantly we get the following errors back from Sybase/JDBC:

JZ006: Caught IOException: com.sybase.jdbc2.jdbc.SybConnectionDeadException:
JZ0C0: Connection is already closed.</daws:Errors></daws:Results>

Any ideas on why the connection would unexpected die?

The web server is running on Sun 1.
Avatar of grant300
grant300

This usually happens when the underlying network connection drops.  It may be coming back up fast enough you are not noticing it.  It may also be do to a timeout if the keepalive is not getting a response.

Does it happen when there is fairly constant traffic between the Sybase and WEB servers, or does it happen when things are quite?

Bill
Avatar of TadHawkins

ASKER

Turned out to be a static Java method that did some of the connetion work. Once it was made dynamic and instantiated for each process the problem seems to have gone away.
ASKER CERTIFIED SOLUTION
Avatar of DarthMod
DarthMod
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial