1 Reply Latest reply: Oct 24, 2013 1:59 PM by dsurber RSS

    Oracle Datasource validate connection

    Mirian

      Hi

       

      I have a question about ValidateConnection property of Oracle Datasource. We are going to use it in our production because it shows performance increase comparing with Apache Basic Datasource which we are using now. BasicDS has a property that validate connection during returning and borrowing from and to cache. It call simple query to understand is connection still alive or not. Since we should always have the valid connections in our pool it helps to take a pool in consistent state.

       

      We use OracleDS with Implicit connection caching. OracleDS has a ValidateConnection property that helps to check connection during getting one. In case if connection is broken it will be removing from cache and SQLException is thrown.

      My question is OracleDS recreate connection at the next getConnection call in order to have a MaxLimit active connections in the cache?