Weblogic question Ver 8.1sp3/jdk 1.4.2_06

Posted on 2005-03-07
Medium Priority
Last Modified: 2013-12-10
Hi all,

would appreciate help please..

My app is in weblogic 8.1 sp3. Evrything works fine for a while, and suddenly at some point (after few days), we start getting below error in log4j error log..

all errors are related to Connection is already closed..

What can be wrong?? Anything wrong we are doing in our code..

we are using weblogic JDBC conn pools... We usually close the conn after work is done .. (since it is large code.. so not sure if we are doing this everywhere.. )  but what can be the problem?? what to look for to fix this? any ideas?? once we restart the app servers, everything works well...

please help urgently..

Level: ERROR
thread: Thread-23
logger: com.citi.soft.trade.threads.TradeWorkQueue
<type>Exception</type><msg>Exception caught in SuspendTask::run()</msg><throwable>SQL ErrorCode: 0, java.sql.SQLException: JZ0C0: Connection is already closed.
      at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:539)
      at com.sybase.jdbc2.jdbc.SybConnection.checkConnection(SybConnection.java:1866)
      at com.sybase.jdbc2.jdbc.SybConnection.createStatement(SybConnection.java:659)
      at weblogic.jdbc.wrapper.Connection.createStatement(Connection.java:323)
      at com.citi.soft.trade.threads.TradeWorkQueue.checkSuspended(Unknown Source)
      at com.citi.soft.trade.threads.TradeWorkQueue.run(Unknown Source)
      at java.lang.Thread.run(Thread.java:534)
<type>State</type><msg>Suspending trade processing since cannot determine state due to exception</msg>
Question by:shivani
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

Expert Comment

ID: 13484849
Update to latest service patch .. there is a fix related to JDBC connections not being garbage collected otr smthn like that . may be related to the same.

Expert Comment

ID: 13497342
try monitering the connection pool when ur application is running.. this will show you whether connections are getting closed and being returned to the pool.. then you can know whether there is some place in your code where you are not closing connections.

Expert Comment

ID: 13501916
To make sure that you are closing all connections. you can take thread dumps are analyse them further. Take thread dumps once you know that all connections are closed and then the thread may show if there is any thread still trying to access.
LVL 23

Accepted Solution

rama_krishna580 earned 2000 total points
ID: 13528585

Odd. This definitely sounds like a driver bug. The first thing to do is to download Sybase's very latest driver *and* whatever EBF may relate to the driver, and get that driver ahead of the weblogic stuff in the server startup script's classpath, and retry.
If that exception ever hapens again, send me the actual Sybase driver being used, and I will take it apart and make a patch for it that is more explicit about where it thinks the connection was closed before you got that exception.

LVL 23

Expert Comment

ID: 14175922

My Above provided solution serves to solve the problem >> Weblogic question Ver 8.1sp3/jdk 1.4.2_06...


Featured Post

Plug and play, no additional software required!

The ATEN UE3310 USB3.1 Gen1 Extender Cable allows users to extend the distance between the computer and USB devices up to 10 m (33 ft). The UE3310 is a high-quality, cost-effective solution for professional environments such as hospitals, factories and business facilities.

Question has a verified solution.

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

Verbose logging is used to diagnose garbage collector problems. By default, -verbose:gc output is written to either native_stderr.log or native_stdout.log.   It is also possible to redirect the logs to a user-specified file. This article will de…
Upgrading Tomcat – There are a couple of methods to upgrade Tomcat is to use The Apache Installer is to download and unzip and run the services.bat remove|install Tomcat6 Because of the App that we are working with, we can only use Tomcat 6.…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Suggested Courses

801 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