• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Tim Cooke
  • Liutauras Vilda
  • Jeanne Boyarsky
Sheriffs:
  • Paul Clapham
  • Rob Spoor
  • Junilu Lacar
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Piet Souris
  • Carey Brown
Bartenders:

restarting app server

 
Ranch Hand
Posts: 312
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Sheriff
Posts: 67693
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Moving to the Weblogic forum.
 
manish ahuja
Ranch Hand
Posts: 312
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 1209
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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!
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic