This week's book giveaway is in the Reactive Progamming forum.
We're giving away four copies of Reactive Streams in Java: Concurrency with RxJava, Reactor, and Akka Streams and have Adam Davis on-line!
See this thread for details.
Win a copy of Reactive Streams in Java: Concurrency with RxJava, Reactor, and Akka Streams this week in the Reactive Progamming forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Junilu Lacar
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Knute Snortum
  • Tim Cooke
  • Devaka Cooray
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Ganesh Patekar

StaleConnectionException

 
Ranch Hand
Posts: 116
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,
We are using Websphere 4.0 and it throws StaleConnectionException when the server is left unused for sometime. To get over this we are catching this exception and attempt to get the connection again. But unfortunately at times something weird happens and NullPointerException is thrown circumventing the StaleConnectionException.
has anyone faced this problem? I'm pasting below the stack trace during both the circumstances.
1. When StaleConnectionException is covered by NullPointerException

2. When StaleConnectionException is thrown.

I think this has to do something with the place where the exception is thrown. Notice in the 1st case I think it is being thrown in the Preparedstatement.executeQuery( ) method and in the second case it is thrown in the Connection.prepareCall( ) (Not sure though !!!)
Your response would be highly appreciated.
Thanks & Regards,
Nijeesh.
 
Ranch Hand
Posts: 178
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Nijeesh,
What database are you using as your WAS repository and your application database? We are using Sybase 12.0 for both. We are also on WAS 4.0.3 on AIX 4.3.3. We have been receiving the StaleConnectionExceptions for a long time now. We opened a case with IBM and with Sybase in July, and it is still not resolved. They have told us that other customers haven't had the same problem that we have. Please give me more details on your situation so I can pass this along to IBM and Sybase if appropriate.
Thanks!
 
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
we are having the same problem too. We are using DB2 for the repository but we use Sybase 12.0 for our other data. We have WAS 4.0.3 on Windows 2000 Server. So if IBM tells you that other people are not getting the same problem, they are not being accurate.
Meddie
[ November 07, 2002: Message edited by: meddie katongole ]
 
Have you no shame? Have you no decency? Have you no tiny ad?
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!