RE: JBoss keeps sending select 'hello' from dual
Date: Fri, 24 Oct 2008 13:07:04 +0000
BEA Weblogic does it for each JDBC call if you have the 'TestConnectionsOnReserve' parameter enabled.
You can disable this parameter in Weblogic - you may be able to do the same in JBOSS.
However, you should check what the impact is on the app server / application before doing so (in our case we disabled it and haven't noticed any serious problems as a result).
> Date: Fri, 24 Oct 2008 08:04:44 +0200
> From: martin.a.berger_at_gmail.com
> To: niall.litchfield_at_gmail.com
> Subject: Re: JBoss keeps sending select 'hello' from dual
> CC: Jay.Miller_at_tdameritrade.com; oracle-l_at_freelists.org
> I don't know JBoss, but BEA Weblogic does the same (or similar) to
> ensure the connection pool is helathy.
> I assume (!), JBoss is similar in this case.
> best regards,
> --Martin Berger
Catch up on all the latest celebrity gossip http://clk.atdmt.com/GBL/go/115454061/direct/01/ Received on Fri Oct 24 2008 - 08:07:04 CDT