0 Replies Latest reply on Jun 22, 2016 3:57 PM by rjakkula

    Database connection validation check with different configurations in EAP 6.4

    rjakkula

      There seems to be different options to check if the connection to a database is valid when configuring a data source connection pool in Jboss EAP 6.4.

       

      Is a there a potential conflict or performance implication if all the options are configured at the same time? Like in the example below in colored options

       

        <validation>

        <valid-connection-checker

        class-name="org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker"></valid-connection-checker>

        <check-valid-connection-sql>select 1 from dual

        </check-valid-connection-sql>

        <validate-on-match>false</validate-on-match>

        <background-validation>false</background-validation>

        <use-fast-fail>false</use-fast-fail>

        <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleExceptionSorter"></exception-sorter>

        </validation>