[jboss-jira] [JBoss JIRA] Updated: (JBAS-7068) Wrong timeout-valiue in OracleValidConnectionChecker

Tue Oct 27 07:38:05 EDT 2009

     [ https://jira.jboss.org/jira/browse/JBAS-7068?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Vadim Kopichenko updated JBAS-7068:
-----------------------------------

    Attachment: OracleValidConnectionCheckerFixed.jar

Hi, All.
Attaching version with configurable timeout defaulting to 5 seconds.
It provides some additinal logging to help resolve issues like http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3883751 and http://theblasfrompas.blogspot.com/2008/02/classcastexception-casting-to.html.
As a little misplaced bonus, it's also capable of unwrapping net.sf.log4jdbc.ConnectionSpy connections for log4jdbc since 1.2 alpha 2. 
OracleValidConnectionCheckerFixed.jar contains both renamed source and compiled class file. So it can be used as drop-in replacement util this issue gets fixed.
Hope, this would help someone.

> Wrong timeout-valiue in OracleValidConnectionChecker
> ----------------------------------------------------
>
>                 Key: JBAS-7068
>                 URL: https://jira.jboss.org/jira/browse/JBAS-7068
>             Project: JBoss Application Server
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: JCA service
>    Affects Versions: JBossAS-5.1.0.GA
>            Reporter: Christian Daszenies
>            Assignee: Jesper Pedersen
>         Attachments: OracleValidConnectionCheckerFixed.jar
>
>
> OracleValidConnectionChecker calls 
> oracle.jdbc.driver.OracleConnection.pingDatabase(5000) - 5000 is used as timeout in seconds! by pingDatabase
> furthermore it would be nice if the timeout would be configurable (or at least easy to override)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira