[jboss-user] [Datasource Configuration] - Which is the best data source selection for Oracle?

Massimo Gentilini do-not-reply at jboss.com
Mon Sep 5 06:45:50 EDT 2011


Massimo Gentilini [http://community.jboss.org/people/massimogentilini] created the discussion

"Which is the best data source selection for Oracle?"

To view the discussion, visit: http://community.jboss.org/message/624732#624732

--------------------------------------------------------------
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
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/624732#624732]

Start a new discussion in Datasource Configuration at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20110905/40eec106/attachment.html 


More information about the jboss-user mailing list