Announcement Announcement Module
Collapse
No announcement yet.
How to configure SqlMapClient for multiple Oracle RAC services Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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.
    Ganesh

  • #2
    What nobody?

    Comment

    Working...
    X