You are correct. Brandon Goodin On Fri, May 1, 2009 at 1:48 PM, Srinivas Doddi <srinivas_do...@gap.com>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. ( 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 > > > > also, we have a spring-for-ibatis.xml file where we have code like this > > > > <bean id="IbatisDataSource" > class="org.springframework.jndi.JndiObjectFactoryBean"> > > <property name="jndiName" value="jdbc/RSGH/IJA/twy/ftwdb"/> > > </bean> > > > > <bean id="BTHSqlMapClient" > class="org.springframework.orm.ibatis.SqlMapClientFactoryBean"> > > <property name="configLocation" value="classpath:sql-map-config.xml"/> > > <property name="dataSource" ref="IbatisDataSource"/> > > </bean> > > > > <bean id="UsageIfaceDAO" > class="biv.data.dao.reports.auditreports.UsageReportDAO"> > > <property name="sqlMapClient" ref="BTHSqlMapClient"/> > > <property name="dataSource" ref="IbatisDataSource"/> > > </bean> > > > > so can I then just add another bean with jndi like this: > > <bean id="IbatisDataSource2" > class="org.springframework.jndi.JndiObjectFactoryBean"> > > <property name="jndiName" value="jdbc/RSGH/IJA/twy/<mynewDBNAME>"/> > > </bean> > > > > then another bean for sql-map-client (I will have to make another xml > right? say sql-map-client1.xml) > > <bean id="BTHSqlMapClient1" > class="org.springframework.orm.ibatis.SqlMapClientFactoryBean"> > > <property name="configLocation" value="classpath:sql-map-config1.xml"/> > > <property name="dataSource" ref="IbatisDataSource"/> > > </bean> > > > > and then start registering my DAO's like this > > <bean id="SomeNewDAO" > class="biv.data.dao.reports.auditreports.SomeReportDAO"> > > <property name="sqlMapClient" ref="BTHSqlMapClient1"/> > > <property name="dataSource" ref="IbatisDataSource"/> > > </bean> > > > > Thanks > > -bhaarat > > On Fri, May 1, 2009 at 2:09 PM, Bhaarat Sharma <bhaara...@gmail.com> > wrote: > > Hi > > > > Currently our sql-map-config looks like this: > > > > <sqlMapConfig> > > <settings enhancementEnabled="true" useStatementNamespaces="true" /> > > <transactionManager type="JDBC"> > > <dataSource type="JNDI"> > > <property name="DataSource" > value="jdbc/RSGH/IJA/twy/ftwdb" /> > > </dataSource> > > </transactionManager> > > > > <sqlMap resource="existingSearch.xml" /> > > <sqlMap resource="deceased_search.xml"/> > > <sqlMap resource="multiLoanSearch.xml"/> > > </sqlMapConfig> > > > > 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 some of > our sqlMaps reference that NEW JDBC connection. Can this be done in iBatis? > can we have multiple data sources, and if so, then how do > we differentiate which DB a sqlMap references. > > > > Thanks! > > >