Recompile any PL/SQL object: worry about app server jdbc cache ??

Thread view:

Spendius - 26 Nov 2006 13:22 GMT

Hi,
I was about to recompile a trigger in one of our 9.2 database,
and our app server admin told me not to do it because I
would've then invalidated what his WebSphere jdbc cache
contains... The version of the driver is the same as that of
the db involved.

Is he right ? Should he really stop his application server
before I can safely recompile a trigger ?

Thanks.

Reply to this Message

joeNOSPAM@BEA.com - 26 Nov 2006 18:00 GMT

> Hi,
> I was about to recompile a trigger in one of our 9.2 database,
[quoted text clipped - 7 lines]
>
> Thanks.

Well, yes there is an issue. If an app-server is caching prepared
statements
along with it's pooled connections, those statements are associated
with
a compiled query plan in the DBMS. If you alter/recompile anything in
the
DBMS that is referred to by those query plans, they become invalidated.
That being said, the app-server should have an easy way to flush the
statement caches so they get repopulated automatically. A full shutdown
of the app-server shouldn't be necessary. I am sure of this for the BEA
product at least...

Joe Weinstein at BEA Systems

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...