Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (athena.apache.org: local policy)
Content-Class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
Subject: RE: How to configure SqlMapClient for multiple Oracle RAC services?
Date: Wed, 14 Oct 2009 17:39:52 -0500
Message-ID: <07094E40F055C34FA35BB28DB1670E7FB36463@bibbmail.bibb.com>
In-Reply-To: <25900036.post@talk.nabble.com>
Thread-Topic: How to configure SqlMapClient for multiple Oracle RAC services?
Thread-Index: AcpNHdC2dW0yTbfJTRqUS6pEc1fUMwAAD8Kw
References: <25849614.post@talk.nabble.com> <25900036.post@talk.nabble.com>
From: Rick.Wellman <Rick.Wellman@kiewit.com>
To: <user-java@ibatis.apache.org>

(from the way you wrote your question)
Assumption #1: You have N web-applications that each have their own
Spring 'applicationContext.xml' file.
Assumption #2: Until now, each configLocation property of the
sqlMapClient bean has been identical.

If Assumptions #1 and #2 are correct, then you have answered your own
question without knowing it.
Configure each application's .xml file according to the service that you
identified in your original question.
(No, I do not believe a single application can be configured to use more
than one connection string.)

-----Original Message-----
From: gunacesun_ibatis [mailto:gunacesun_iBatis@yahoo.com]=20
Sent: Wednesday, October 14, 2009 5:29 PM
To: user-java@ibatis.apache.org
Subject: Re: How to configure SqlMapClient for multiple Oracle RAC
services?


Does the question make sense? Is it too trivial? Why no response?:-(

gunacesun_ibatis wrote:
>=20
> I've been using Spring 2.5 and iBatis 2.3 to connect to Oracle 10g.
>=20
> 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.
>=20
> For example, currently the connection string I use is something like
> jdbc: oracle:thin:@host: port:SID
>=20
> With RAC, I have to use 2 different connection strings like
> jdbc: oracle:thin:@host: port/service1
> jdbc: oracle:thin:@host: port/service2
>=20
> I'm not sure how to set 2 different values for the configLocation
property
> of the sqlMapClient bean in the applicationContext.xml file.
>=20
> Is this the right approach or is there a diiferent way to do this?
>=20
> 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.
>=20
> Thanks in Advance.
> Ganesh=20
>=20

--=20
View this message in context:
http://www.nabble.com/How-to-configure-SqlMapClient-for-multiple-Oracle-
RAC-services--tp25849614p25900036.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org