-
1. Re: valid-connection-checker
erasmomarciano Jul 3, 2013 8:44 AM (in response to hohokampeople)Hi
You probably want to use the Oracle validation classes.
These tags are not mandatory
-
2. Re: valid-connection-checker
daniel.cote.qc.ca Jul 3, 2013 4:58 PM (in response to hohokampeople)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
hohokampeople Jul 4, 2013 1:30 AM (in response to daniel.cote.qc.ca)Hi Daniel,
thanks for the info..
Regards,
Argel