Oct 9th, 2009, 02:51 PM
How to configure SqlMapClient for multiple Oracle RAC services
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.
Oct 13th, 2009, 10:16 AM
Tags for this Thread