2 Replies Latest reply on Feb 20, 2017 4:27 PM by Tomasz Serafin

    database performance issue after migration from JB7+JDK7 to WF10+JDK8

    Tomasz Serafin Newbie

      Hi all,

       

      Recently we have done migration with our application running on JBoss 7 + JDK 7 to Wilffly 10 + JDK 8, including upgrade to current versions of Hibernate (3.6.4 -> 4.3.11), Spring, CXF, etc. Our database was and is Oracle 11, with no changes. We use ojdbc6 as an Oracle driver.

       

      After migration we realized that performance of sql statements radically droped down, about 3 times on production. We looked for different solutions, such as other driver, some data source options, using common datasource rather than XA, but without required effects.

       

      Have you got any idea?

       

      Here is our datasource configuration:

       

       

                      <xa-datasource jndi-name="java:jboss/datasources/ds" pool-name="ds">

                          <xa-datasource-property name="URL">

                              jdbc:oracle:thin:@//192.168.0.48:1521/ORADB1

                          </xa-datasource-property>

                          <driver>oracleXA</driver>

                          <xa-pool>

                              <min-pool-size>5</min-pool-size>

                              <max-pool-size>50</max-pool-size>

                              <prefill>true</prefill>

                          </xa-pool>

                          <security>

                              <user-name>...</user-name>

                              <password>...</password>

                          </security>

                          <validation>

                              <check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>

                          </validation>

                      </xa-datasource>

                      <drivers>

                          <driver name="oracle" module="com.oracle">

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

                          </driver>

                          <driver name="oracleXA" module="com.oracle">

                              <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>

                          </driver>

                      </drivers>

       

      Thanks in advance,

      Tom

        • 1. Re: database performance issue after migration from JB7+JDK7 to WF10+JDK8
          Tomaz Cerar Master

          Tomasz Serafin wrote:

           

          including upgrade to current versions of Hibernate (3.6.4 -> 4.3.11), Spring, CXF, etc.

           

          Current hibernate in wildfly 10 is 5.0.10.Final ....

          • 2. Re: database performance issue after migration from JB7+JDK7 to WF10+JDK8
            Tomasz Serafin Newbie

            Hi,

             

            For some reasons we user Hibernate 4.x. We have solved the problem of slow database operations by setting hibernate batch size property.

             

            After that we still have another problem. Our database operations (now quite fast) are permormed inside a web service we make accessible to client applications. This web service is exposed by CXF library. After we get request from client to the web service, when job is done, for unknown reasons the answer doesn't get to the client. Our WildFly instance /web service is not accessible directly by the client, but throught Apache load balancer. After some time (sometimes seconds, sometimes minutes) apache detects timeout and our web service throws "Stream is closed" IO exception. When client application requests our web service directly rather then by Apache load balancer, it works fine.

             

            Any idea?