The Artima Developer Community
Sponsored Link

Java Answers Forum
stale connection exception with db2

0 replies on 1 page.

Welcome Guest
  Sign In

Go back to the topic listing  Back to Topic List Click to reply to this topic  Reply to this Topic Click to search messages in this forum  Search Forum Click for a threaded view of the topic  Threaded View   
Previous Topic   Next Topic
Flat View: This topic has 0 replies on 1 page
sachin tendulakar

Posts: 1
Nickname: sachin
Registered: Oct, 2002

stale connection exception with db2 Posted: Oct 3, 2002 4:33 AM
Reply to this message Reply
Advertisement
Stale connection Exception while running a Db2 stored procedure from java in Websphere application server. The stored procedure is invoked by clicking a link on the browser. After this if the browser is left idle for 10 minutes and then when we click on any link we are getting stale connection exception. If we dont keep the browser idle and keep on clicking some links for 10 minutes we are not getting any stale connection exception. We are using WAS 4.0 on SOLARIS. DB2 7.0 on MVS. Stored procedure is written in cobol. On the mainframe DB2 side we see the threads for our Stored procedure and packages SQLL7D04 and SQLL7D05 left open even after the stored procedure is finished executing. We are under the assumption that these two packages is causing the stored procedure thread not to close. Any help in this would be greatly appreciated.

Topic: ')' expected at line 22 Previous Topic   Next Topic Topic: Java applet on Pocket PC

Sponsored Links



Google
  Web Artima.com   

Copyright © 1996-2019 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use