Solved

Sybase JDBC connection dies intermittantly

Posted on 2006-07-06
4
1,352 Views
Last Modified: 2008-02-01
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.
0
Comment
Question by:TadHawkins
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 19

Expert Comment

by:grant300
ID: 17063310
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
0
 
LVL 2

Author Comment

by:TadHawkins
ID: 17091043
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.
0
 
LVL 1

Accepted Solution

by:
DarthMod earned 0 total points
ID: 17738847
PAQed with points refunded (250)

DarthMod
Community Support Moderator
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is written by John Gates, CISSP. Gates, the SNUG President-Elect, currently holds the position of Manager of Information Systems at Lake Park High School in Roselle, Illinois.
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

634 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question