I have configured a Datasource with upto a max of 10 connections and there are some java classes that invoke certain SQL packages using the datasource connection. There is also a background SQL job that puts the packages in invalid state then compiles them and makes them valid when it completes. For some reasion JBoss does not seem to update the cache when the packages become valid.
It still seems to throw an error to the Java program that is accessing the SQL package saying that it's in invalid state when actually it's in a valid state.
Can I schedule a flush of the cache? or configure it to keep the cache in synch?