Hi,
We have been connecting to a single instance Oracle DB with the following properties:
<jdbc-connection-pool allow-non-component-callers="false" associate-with-thread="false"
connection-creation-retry-attempts="0" connection-creation-retry-interval-in-seconds="10"
connection-leak-reclaim="false" connection-leak-timeout-in-seconds="0" connection-validation-method="auto-commit"
datasource-classname="oracle.jdbc.pool.OracleDataSource" fail-all-connections="false" idle-timeout-in-seconds="300"
is-connection-validation-required="false" is-isolation-level-guaranteed="false" lazy-connection-association="false"
lazy-connection-enlistment="false" match-connections="false" max-connection-usage-count="0" max-pool-size="32"
max-wait-time-in-millis="60000" name="OraclePool" non-transactional-connections="false" pool-resize-quantity="2"
res-type="javax.sql.DataSource" statement-timeout-in-seconds="-1" steady-pool-size="8"
validate-atmost-once-period-in-seconds="0" wrap-jdbc-objects="false">
<property name="DataSourceName" value="OracleDataSource"/>
<property name="ImplicitCachingEnabled" value="false"/>
<property name="NetworkProtocol" value="tcp"/>
<property name="DatabaseName" value="DB_VIRTUOSO_CIMB"/>
<property name="Password" value="password"/>
<property name="LoginTimeout" value="0"/>
<property name="URL" value="jdbc:oracle:thin:@10.100.16.17:1521:VTSCIMB"/>
<property name="User" value="VIRTUOSO_USR"/>
<property name="ExplicitCachingEnabled" value="false"/>
<property name="PortNumber" value="1521"/>
<property name="ServerName" value="10.100.16.17"/>
<property name="MaxStatements" value="0"/>
</jdbc-connection-pool>
I've been scouring Google for a configuration on Glassfish to connect to the RAC DB but without much success. Does anybody have any sample configuration or can point me to the right way?
Thanks!
Wong
[Message sent by forum member 'lilwong' (lilwong)]
http://forums.java.net/jive/thread.jspa?messageID=248182