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

2009-05-01 Thread Warren Bell
I have objects that are made up of data from two different datasources. I am currently using spring and my configuration is like that below. I guess this is a design question, but I have always constructed these type of objects in a service layer. It doesn't look like you can access two data so

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

2009-05-01 Thread Brandon Goodin
You are correct. Brandon Goodin On Fri, May 1, 2009 at 1:48 PM, Srinivas Doddi wrote: > We were using two separate Sql Map Configuration files for this kind of > scenario. In IBATIS, I guess there is no way of specifying two different > Sql maps clients in a single configuration file. ( Correc

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
We were using two separate Sql Map Configuration files for this kind of scenario. In IBATIS, I guess there is no way of specifying two different Sql maps clients in a single configuration file. ( Correct me, if I am wrong) Thank you. SRINIVAS DODDI From:

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

Re: iBator + sqlMapConfig.xml

2009-05-01 Thread maciego
Thanks... Regards Maciego -- View this message in context: http://www.nabble.com/iBator-%2B-sqlMapConfig.xml-tp23331608p2001.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

RE: gracefuly exit from row handler

2009-05-01 Thread Jose Lora
Is there any way you can move the error checking logic to the database instead of running it on the java server? If you need data from other systems to perform the error checking process, it may be better for you to temporarily move that data to DB2. To move the data across you could use database s

Re: iBator + sqlMapConfig.xml

2009-05-01 Thread Kai Grabfelder
Hi Maciego, have you read the documentation at http://svn.apache.org/repos/asf/ibatis/trunk/java/ibatis-2/ibatis-2-docs/en/ ? Best Regards Kai Grabfelder --- Original Nachricht --- Absender: maciego Datum: 01.05.2009 13:13 > Hi, > I am preparing to use iBatis in my application (for my studies

iBator + sqlMapConfig.xml

2009-05-01 Thread maciego
Hi, I am preparing to use iBatis in my application (for my studies). I generated model, dao and mapping via iBator and configured SqlMapConfig.xml. I see all 'impl' classes extends SqlMapDaoTemplate class. What I should do next? How make a connection - should I have another base class? Thanks