Re: how to have two datasources in sql-map-config.xml

2009-05-01 Thread Warren Bell
SRINIVAS DODDI** *From:* Bhaarat Sharma [mailto:bhaara...@gmail.com <mailto:bhaara...@gmail.com>] *Sent:* Friday, May 01, 2009 2:24 PM *To:* user-java@ibatis.apache.org <mailto:user-java@ibatis.apache.org> *Subject:* Re: how to have two datasou

Re: how to have two datasources in sql-map-config.xml

2009-05-01 Thread Brandon Goodin
tion file. ( Correct me, if I am > wrong) > > > > Thank you. > > > > *SRINIVAS DODDI* > -- > > *From:* Bhaarat Sharma [mailto:bhaara...@gmail.com] > *Sent:* Friday, May 01, 2009 2:24 PM > *To:* user-java@ibatis.apache.org > *Subject:*

Re: how to have two datasources in sql-map-config.xml

2009-05-01 Thread Brandon Goodin
Hey Bhaarat, The example you provided is the approach I would take in your situation. Brandon Goodin On Fri, May 1, 2009 at 1:25 PM, Bhaarat Sharma wrote: > Brandon, > I think your reply came as I was tying up my reply. Please check out my > second reply to see if that makes sense. > > Thanks

RE: how to have two datasources in sql-map-config.xml

2009-05-01 Thread Srinivas Doddi
: Bhaarat Sharma [mailto:bhaara...@gmail.com] Sent: Friday, May 01, 2009 2:24 PM To: user-java@ibatis.apache.org Subject: Re: how to have two datasources in sql-map-config.xml also, we have a spring-for-ibatis.xml file where we have code like this

Re: how to have two datasources in sql-map-config.xml

2009-05-01 Thread Bhaarat Sharma
Brandon, I think your reply came as I was tying up my reply. Please check out my second reply to see if that makes sense. Thanks On Fri, May 1, 2009 at 2:21 PM, Brandon Goodin wrote: > Why not create a separate SqlMapClient for the Oracle database? > > Brandon Goodin > > > > On Fri, May 1, 2009

Re: how to have two datasources in sql-map-config.xml

2009-05-01 Thread Bhaarat Sharma
also, we have a spring-for-ibatis.xml file where we have code like this so can I then just add another bean with jndi like this: then another bean for sql-map-client (I will have to make another xml right? say sql-map-client1.xml) and then start re

Re: how to have two datasources in sql-map-config.xml

2009-05-01 Thread Brandon Goodin
Why not create a separate SqlMapClient for the Oracle database? Brandon Goodin On Fri, May 1, 2009 at 1:09 PM, Bhaarat Sharma wrote: > Hi > Currently our sql-map-config looks like this: > > > > > > > > > > > > > > In the above we only have one JDBC connection

how to have two datasources in sql-map-config.xml

2009-05-01 Thread Bhaarat Sharma
Hi Currently our sql-map-config looks like this: In the above we only have one JDBC connection and this connection goes to a SQL Server. However, now we will have to access another DB which is in Oracle. So we will have to create another JDBC connection and have s