Why not create a separate SqlMapClient for the Oracle database? Brandon Goodin
On Fri, May 1, 2009 at 1: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! >