WebSphere Application Server & Liberty

WebSphere Application Server & Liberty

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only

  • 1.  Validating Connection before query Execution

    Posted 08/11/10 10:36 AM
    Validating Connection before query Execution

    --------------------------------

    Hi All,

    I have a connection pool configured in IBM WebSphere V6.0. Database is sql server 2000.

    I am accessing this connection pool using JNDI from my application deployed in Websphere. I want to validate every connection before it is used to execute a query like /"testonborrow=true/" property used in DBCP. There is a property /"Pretest new connections/" in web sphere but it doesn't work as is see queries running in sql profiler /"select 1/" never appears. However if use tomcat and dbcp i see /"select 1/" running before every query execution.

    Please help

    --------------------------------

    Posted By: asif baloch at May 8 2009 11:30PM


  • 2.  Validating Connection before query Execution

    Posted 08/11/10 10:44 AM
    The pre-test SQL should work. If you don't see it happening, first assure that you are on a recent version of WAS (I.e install fixpacks), second, if the problem still occurs then I would suggest you open a SR with IBM Support to gather some tracing data and figure out what the issue is.

    --------------------------------

    Posted By: jpapejr at May 26 2009 12:45PM