How to configure SqlMapClient for multiple Oracle RAC services

[gunacesun_spring]

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 1 service and others use a different service. So I need to use 2 different URLs to connect to the DB.

For example, currently the connection string I use is something like
jdbc: oracle:thin:@host: port:SID

With RAC, I have to use 2 different connection strings like
jdbc: oracle:thin:@host: port/service1
jdbc: oracle:thin:@host: port/service2

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?

Thanks in Advance.
Ganesh

[gunacesun_spring]

What nobody?