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

[Bhaarat Sharma]

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!