This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes java.sql.SQLException: ORA-00028: your session has been killed Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "java.sql.SQLException: ORA-00028: your session has been killed" Watch "java.sql.SQLException: ORA-00028: your session has been killed" New topic
Author

java.sql.SQLException: ORA-00028: your session has been killed

Annasaheb Sunthe
Greenhorn

Joined: Jan 19, 2009
Posts: 2
Hello,
I am getting "java.sql.SQLException: ORA-00028: your session has been killed" error while executing a stored procedure using Oracle Thin driver Oracle. The application is running on App server WebLogic 9.2.
According to oracle documentation the reason for this error is that a privilaged user has killed the session. But I don't think that has happened. Is it issue with WebLogic connection pool? or issue with oracle driver or oracle 10g db.
Any help will be appreciated.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

This can only happen when an admin user kills your session. They may be explicitly doing this, or implicitly doing this by setting limits in your profile. Speak to your Oracle admin.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Annasaheb Sunthe
Greenhorn

Joined: Jan 19, 2009
Posts: 2
Thanks for quick reply Paul,

"or implicitly doing this by setting limits in your profile" is it session time out limit?

Actual setup is like this:
Application is deployed on TWO weblogic domains (with one managed server in each domain), both pointing to same database. Connection pool on both weblogic domains configured with same user credentials. I run cron job on first weblogic server, which inturn calls stored procedure through java code. After completing cron job, we are firing browser requests on both weblogic servers. Request on first weblogic serves correctly, while request on second server fails with java.sql.SQLException: ORA-00028 error.

appreciate your help.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336


"or implicitly doing this by setting limits in your profile" is it session time out limit?

Could be. Your DBA could set up almost any trigger they like to do this in the profile your account uses. Speak to them.

 
Don't get me started about those stupid light bulbs.
 
subject: java.sql.SQLException: ORA-00028: your session has been killed