Could not open connection [n/a] java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/

Latest response

Hi, I am getting the below error :
Could not open connection [n/a] java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/aa.
The available datasource connections are becoming 0, active connections and max used connections are becoming maximum pool size. I have min pool size set to 10 and prefill and strict minimum enabled to true.

The standalone.xml configuration contains :

<datasource jta="false" jndi-name="aaaaa" pool-name="aa" enabled="true" use-ccm="false" statistics-enabled="true">
                    <connection-url>jdbc:oracle:thin:@(connection_url***)</connection-url>
<driver-class>oracle.jdbc.OracleDriver</driver-class>
                    <driver>OracleJDBCDriver</driver>
                    <pool>
                        <min-pool-size>10</min-pool-size>
                        <max-pool-size>20</max-pool-size>
                        <prefill>true</prefill>
                        <use-strict-min>true</use-strict-min>
                        <flush-strategy>FailingConnectionOnly</flush-strategy>
                    </pool>
                    <security>
                        <user-name>xxxxx</user-name>
                        <password>xxxxxxx</password>
                    </security>
                    <validation>
                        <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"/>
                        <validate-on-match>false</validate-on-match>
                        <background-validation>true</background-validation>
                        <background-validation-millis>300000</background-validation-millis>
                        <use-fast-fail>false</use-fast-fail>
                        <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>
                    <timeout>
                        <set-tx-query-timeout>false</set-tx-query-timeout>
                        <blocking-timeout-millis>50000</blocking-timeout-millis>
                        <idle-timeout-minutes>10</idle-timeout-minutes>
                        <query-timeout>120</query-timeout>
                        <use-try-lock>0</use-try-lock>
                        <allocation-retry>0</allocation-retry>
                        <allocation-retry-wait-millis>0</allocation-retry-wait-millis>
                    </timeout>
                    <statement>
                        <track-statements>false</track-statements>
                        <share-prepared-statements>false</share-prepared-statements>
                    </statement>
</datasource>

Any help is appreciated.

Thanks.

SP

Responses