Solved

We are getting a 'Connection is already closed' exception from WebSphere 5 and jConnect 5.5

Posted on 2004-03-25
3
600 Views
Last Modified: 2013-12-10
We have an web application that uses a Sybase/JDBC Datasource.  We are utilziing the standard connection pooling provided by WebSphere 5 and the jConnect JDBC provider.  We are experiencing intermittent SqlExceptions "JZ0C0: Connection is already closed." when attempting to use connections returned from the Datasource.  We're fairly confident we are dutifully closing all of our statements, result sets and connections when we are done using them.  It is our understanding that when we close a connection, it is returned to the connection pool and is available for further use.

This appears to work properly most of the time.  We have not been able to reproduce it reliably.

-jon
0
Comment
Question by:jonprettyman
3 Comments
 
LVL 9

Accepted Solution

by:
mmuruganandam earned 250 total points
ID: 10877123
Make sure that all your connections are closed in the finally block of all your code.  There are chances that your connection might be closed based on one data condition and try to use the same connection in the same block for some other reason.

It is purely a code bug.


Regards,
Muruga
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Most of the developers using Tomcat find it easy to configure the datasource in Server.xml and use the JNDI name in the code to get the connection.  So the default connection pool using DBCP (or any other framework) is made available and the life go…
This article is about some of the basic and important steps to be used to improve the performance in web-sphere commerce application development. 1) Always leverage the Dyna-caching facility provided by the product 2) Remove the unwanted code …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

867 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now