wood burning stoves 2.0
The moose likes BEA/Weblogic and the fly likes restarting app server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "restarting app server" Watch "restarting app server" New topic

restarting app server

manish ahuja
Ranch Hand

Joined: Oct 23, 2003
Posts: 312
Hi All

I have started working on this application which is 3 tier app with web tier (apache) - app server (weblogic6.1) & database (oracle9i).

The problem which I encounter is at the database interaction between the app layer & the database.
Whenever I recompile any stored procedures in Oracle my app server fails to recognize the latest one & gives me an Oracle error ORA-04068: existing state of packages has been discarded.

Only when I restart the app server are the changes made in the database stored proc recognised by the middle tier application.

HOw do I overcome this. Its really frustrating to restart the app server on any change we make to the database side packages.
How do I make my app tier force to see the latest package structure

Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63848

Moving to the Weblogic forum.

[Asking smart questions] [About Bear] [Books by Bear]
manish ahuja
Ranch Hand

Joined: Oct 23, 2003
Posts: 312
Very surprsing that no one has ever encountered this error. Either very few projects use weblogic app along with an Oracle database.
or is that I have some error in my configuration

Can someone take a call on this
Karthik Guru
Ranch Hand

Joined: Mar 06, 2001
Posts: 1209
I have heard of such problems wrt Prepared Statements when the Prepared Statement Cache is enabled in weblogic. Now that you are having problems with a oracle SP , it means the Callable Statement is also being cached :roll:
That's wierd unless you are changing the SP IN/OUT parameters.
Anyways, guess I have'nt been able to answr your question!
jQuery in Action, 3rd edition
subject: restarting app server
It's not a secret anymore!