3 Replies Latest reply on Jul 4, 2013 1:30 AM by bruno bruno

    valid-connection-checker

    bruno bruno Newbie

      Hi All,

       

          What would be the side effect i there is no valid-connection-checker define in config file?

       

      Regards,

         Argel

        • 1. Re: valid-connection-checker
          erasmo2 marciano2 Master

          Hi

           

          You probably want to use the Oracle validation classes.

          These tags are not mandatory


          • 2. Re: valid-connection-checker
            Daniel Cote Newbie

            Hi Bruno,

             

            for empirical experience, the behavior varied a lot between DB provider...

            I find out that, for Oracle, the connection pools tends to not correctly beeing managed when I tested with high volume and I did create database errors (shutdown abort for example).

            Adding the recommanded methods helped to have a sound behavior and better recover from database lost...

            Here my config...

             


            <validation>

            <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"/>

            <background-validation-millis>60000</background-validation-millis>

            <stale-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleStaleConnectionChecker"/>

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

            </validation>

              regards,

             

            In addition...

             

            Note that, adding those method increased a bit the CPU consumption I mesured...

            For the same traffic, it went from, let say, 31% of a core to 35% ....

            Not a big chunk, but I just want to pass the information...

             

            dc

             

            Message was edited by: Daniel Cote

            • 3. Re: valid-connection-checker
              bruno bruno Newbie

              Hi Daniel,

               

                 thanks for the info..

               

              Regards,

                Argel