2 Replies Latest reply on Jan 21, 2019 1:28 AM by alireza alallah

    How to resolve SQL Error: 17008, SQLState: 99999 wildfly 12 and oracle connection pool?

    alireza alallah Newbie

      We use `Hibernate/JPA` as orm and Wildfly12 as Application server in our project that connect to `Oracle11g`, our problem is that application thrown `SQL Error: 17008` and `connection closed` after work several minutes with database. my `DataSource` configuration exists in wildfly as below:

       

       

       

       

          <datasource jta="true" jndi-name="java:jboss/datasources/myDs" pool-name="myDs" enabled="true" use-java-context="true">

                                      <connection-url>jdbc:oracle:thin:@192.168.1.1:1521:mydb</connection-url>

                                  <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>

                                  <driver>ojdbc6.jar</driver>

                                  <pool>

                                      <min-pool-size>100</min-pool-size>

                                      <max-pool-size>500</max-pool-size>

                                      <prefill>true</prefill>

                                  </pool>

                                 ....

          </datasource>

       

       

      how we can resolve this problem?