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


    bruno bruno Newbie

      Hi All,


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




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



          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...



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


            <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"/>




            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...




            Message was edited by: Daniel Cote

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

              Hi Daniel,


                 thanks for the info..