Re: JBoss keeps sending select 'hello' from dual

I'd love to know what the answer was.... Right now I'm left thinking jboss
is a bit stupid, though that rather plays to my antagonism to j2ee and so
on.

On Thu, Oct 23, 2008 at 9:47 PM, <Jay.Miller@xxxxxxxxxxxxxxxx> wrote:

> Never mind.
>
> I tried some different search terms in Google after sending this out and
> think I've found the answer.  Sorry about that.
>
>
> Jay Miller
>
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
> Jay.Miller@xxxxxxxxxxxxxxxx
> Sent: Thursday, October 23, 2008 4:34 PM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: JBoss keeps sending select 'hello' from dual
>
> While investigating some performance issues on two unrelated databases
> one of the odd things we found was a huge number of "select 'hello' from
> dual"
> statements hitting the databases (as in over a million/hour).
>
> Further investigation leads us to believe that this is a standard
> feature of JBoss connection pooling and the method it uses to check if a
> connection is still alive but we couldn't find any real details on it.
>
> Just wondering if anyone else has encountered this before and can point
> me to additional information or any way of reducing its impact.
>
> Thanks,
> Jay Miller
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>


-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

Other related posts: