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.SybC onnectionD eadExcepti on:
JZ0C0: Connection is already closed.</daws:Errors></daw s:Results>
Any ideas on why the connection would unexpected die?
The web server is running on Sun 1.
JZ006: Caught IOException: com.sybase.jdbc2.jdbc.SybC
JZ0C0: Connection is already closed.</daws:Errors></daw
Any ideas on why the connection would unexpected die?
The web server is running on Sun 1.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Does it happen when there is fairly constant traffic between the Sybase and WEB servers, or does it happen when things are quite?
Bill