On Wed, Sep 17, 2008 at 10:11 AM, <glassfish_at_javadesktop.org> wrote:
> Hi,
>
> You could create a JDBC Connection pool , after copying the oracle driver jar to the lib directory. While creating a pool for Oracle datasource, you should set the property "implicitCachingEnabled" to true and along with it, the "maxStatements" property to some value, say 50.
That enables the prepared statement cache, not the connection cache.
--
Rasputnik :: Jack of All Trades - Master of Nuns
http://number9.hellooperator.net/