This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
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


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "restarting app server" Watch "restarting app server" New topic
Author

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


Bye
Manish
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61106
    
  66

Moving to the Weblogic forum.


[Asking smart questions] [Bear's FrontMan] [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!
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: restarting app server