14 Replies Latest reply on Oct 6, 2014 3:57 AM by Philippe Marschall

    Java/OJDBC performance issue with JBoss 7.1.1

    Kalyan Kantam Newbie

      Suggestions Please



      Guys,  i am actively working on migrating an application running on JBoss 5 to JBoss 7.



      After migration, I have noticed that the database calls took a huge performance hit.



      I was using ojdbc14 with a pool(min - 5 max - 100) on JBoss 5 and it was working pretty good for me.


      With JBoss 7, I have installed the driver as a module.


      All my queries are now taking 10 times longer.

      For ex, if a query took 30ms while I was on JBoss 5 , it is taking 400-600ms on JBoss 7.


      I have tried with both the drivers shown in the config below (ojdbc6, ojdbc14)


      An Observation is that , the perfomance decrease is more noticable on a linux box(i.e. terribly slower) than a OS X box.


      FYI. I have tried running JBoss 7.1.1Final on both Java 1.6 and 1.7


      My application itself contains:

      - struts 2 front end (used for request processing, no web ui involved)

      - Session Beans in the backend

      - QuartzPlugin for batch jobs.

      - a custom MBean


      I have tried

      1. lowering and increasing the pool size

      2. prefill = true and false

      3. switching between ojdbc6 and ojdbc14






              <subsystem xmlns="urn:jboss:domain:datasources:1.0">


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



                          <connection-property name="defaultRowPrefetch">
















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




                              <exception-sorter class-name="org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter"/>













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



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