Java Mailing List Archive

http://www.java2.5341.com/

Home » user-java.ibatis »

How to configure SqlMapClient for multiple Oracle RAC services?

gunacesun_ibatis

2009-10-11

Replies: Find Java Web Hosting

Author LoginPost Reply

I've been using Spring 2.5 and iBatis 2.3 to connect to Oracle 10g.

I'm testing our move to Oracle 11g RAC. In the RAC setup, some of my apps
use one service and others use a different service. So I need to use 2
different connection strings to connect to the DB.

For example, currently the connection string I use is something like
jdbc: oracle:thin:@(protected)

With RAC, I have to use 2 different connection strings like
jdbc: oracle:thin:@(protected)
jdbc: oracle:thin:@(protected)

I'm not sure how to set 2 different values for the configLocation property
of the sqlMapClient bean in the applicationContext.xml file.

Is this the right approach or is there a diiferent way to do this?

I posted this question on the Spring Data Access forum and I haven't had a
response in 2 days. If you have seen it on that forum I apologize.

Thanks in Advance.
Ganesh
--
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@(protected)
For additional commands, e-mail: user-java-help@(protected)

©2008 java2.5341.com - Jax Systems, LLC, U.S.A.