Re: JBoss keeps sending select 'hello' from dual

Hello,
you can configure the "is session alive?" in the datasource, e.g.:

  <local-tx-datasource>
    <jndi-name>name</jndi-name>
   <connection-url>jdbc:oracle:thin:@...</connection-url>
<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.
OracleValidConnectionChecker</valid-connection-checker-class-name>

This is the default implementation. You can remove it.

Another way to perform "something" upon getConnection() is to set the
<new-connection-sql> Parameter, e.g.:

<new-connection-sql>alter session set events '10046 trace name context
forever, level 8'</new-connection-sql>

or simly:

<new-connection-sql>begin null; end;</new-connection-sql>

Cheers,
Martin

--
http://www.freelists.org/webpage/oracle-l