Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

restarting app server

 
manish ahuja
Ranch Hand
Posts: 312
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 64858
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving to the Weblogic forum.
 
manish ahuja
Ranch Hand
Posts: 312
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1209
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic