1 Reply Latest reply on Sep 5, 2011 11:05 AM by wdfink

    Which is the best data source selection for Oracle?

    massimogentilini

      We've a java application running inside JBoss EAP version 5.1 and until today we've always used the standard thin driver to connect to Oracle.

       

      Upon further investigation after having upgraded all our clients to Oracle 11.2.0.2 Jdbc driver and having downloaded all the related files from Oracle site we've found three possible connections than could be used by JBoss

       

      <connection-url>jdbc:oracle:thin:@...</connection-url> 
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>

      <connection-url>jdbc:oracle:thin:@...</connection-url>
      <driver-class>oracle.jdbc.pool.OracleDataSource</driver-class>

      <connection-url>jdbc:oracle:thin:@...</connection-url>
      <driver-class>oracle.ucp.UniversalConnectionPool</driver-class>

       

      The latest requires the copy of the UCP.JAR file in the JBoss lib directory.

       

      Question is: does somebody experienced the different configurations and found one better than the others in terms of performance and stability?

       

      It could be useful to modify JBoss to not use its internal connection and use the UCP feature of Oracle?

       

      Regards

      Massimo

        • 1. Re: Which is the best data source selection for Oracle?
          wdfink

          I use the first one (for a long time).

          AFAIK the second is a Oracle internal pool and there might be trouble if you have a chain of pools because the JBoss DS pool itselve and hold the connections longer, I'm not sure what happen.

          The ucp universalpool is (AFAIK) related to the Oracle cluster.

           

          So I would recommend to use the OracleDriver.