1 Reply Latest reply on Sep 5, 2011 11:05 AM by Wolf-Dieter Fink

    Which is the best data source selection for Oracle?

    Massimo Gentilini Newbie

      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