This content has been marked as final.
Show 2 replies
-
1. Re: How to resolve SQL Error: 17008, SQLState: 99999 wildfly 12 and oracle connection pool?
lafr Dec 31, 2018 9:07 AM (in response to alireza.alallah)1 of 1 people found this helpfulDo you really need such a huge pool? 500 connections at max? Did you tweak the oracle instance to handle this (sessions per used, ...)?
Anyhow: you should add validation settings to your datasource configuration to get only checked valid connections from the pool:
<validation> <background-validation>true</background-validation> <background-validation-millis>60000</background-validation-millis> <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"/> </validation>
-
2. Re: How to resolve SQL Error: 17008, SQLState: 99999 wildfly 12 and oracle connection pool?
alireza.alallah Jan 21, 2019 1:28 AM (in response to lafr)It's works fine, thanks a lot Frank