Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Sybase JDBC connection dies intermittantly

Posted on 2006-07-06
4
Medium Priority
?
1,363 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
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

High user turnover can cause old/redundant user data to consume valuable space. UserResourceCleanup was developed to address this by automatically deleting user folders when the user account is deleted.
Take a look at these 6 Outlook Email management tools which can augment the working and performance of Microsoft Outlook to give you a more rewarding emailing experience.
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Suggested Courses

916 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