Oracle RAC Connection String

[james nuzzo]

Have a SB application that uses Placeholder Properties file crm.properties

# Placeholders crm.*
#    for ORACLE 10g:
crm.jdbc.driver=oracle.jdbc.driver.OracleDriver
crm.jdbc.url=jdbc:oracle:thin:@(description=(load_balance=on)(address=(protocol=tcp)(host=crmdb3a.isus.emc.com)(port=1521))(address=(protocol=tcp)(host=crmdb3b.isus.emc.com)(port=1521))(connect_data=(service_name=CRM03.isus.emc.com)))
#crm.jdbc.url=jdbc:oracle:thin:@crmdb3a.isus.emc.com:1521:crm03a
crm.jdbc.user=SPRINGBATCH
crm.jdbc.password=supersafe
crm.schema=
crm.schema.script=

Note the commented out crm.jdbc.url line specifies a single node in the RAC and works as expected ... correctly.


to populate my dbcp BasicDataSource for my ItemReader

	<beans:bean id="accnTeamdataSource"  class="org.apache.commons.dbcp.BasicDataSource">
		<beans:property name="driverClassName" value="${crm.jdbc.driver}" />
		<beans:property name="url" value="${crm.jdbc.url}" />
		<beans:property name="username" value="${crm.jdbc.user}" />
		<beans:property name="password" value="${crm.jdbc.password}" />
	</beans:bean>

I get the following error ...only fragment shown.

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io exception: The Network Adapter could not establish the connection)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
	at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:210)
	at $Proxy12.prepareStatement(Unknown Source)
	at com.ibatis.sqlmap.engine.execution.SqlExecutor.prepareStatement(SqlExecutor.java:494)
	at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:176)
	at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
	at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
	... 65 more
Caused by: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

This should work. Bug? or am I missing something (again!).