One database per SqlmapConfig - that's the rule. If you have two databases, then you need two instances of the SqlMapConfig. IIRC you are using Spring, so...
1. Declare two datasources 2. Declare two SqlMapConfigs - inject a datasource accordingly 3. Inject the appropriate SqlMapConfig into the appropriate DAO. So, a particular instance of a DAO is tied to one and only one database. In general, you should keep the SQL for the different databases in different XML files - although this is not strictly required. Jeff Butler On 10/24/07, Vinaya Tirikkovalluru <[EMAIL PROTECTED]> wrote: > > Hi, > > > > I am connected to 2 different databases from the application. > > > > How would ibatis know which database to go when I try to access a > procedure? > > Can I access procedures from 2 databases within the same xml? > > > > Thanks in advance > > Vinaya > > ------------------------------ > This electronic message is intended only for the use of the individual(s) > or entity(ies) named above and may contain information which is privileged > and/or confidential. If you are not the intended recipient, be aware that > any disclosure, copying, distribution, dissemination or use of the contents > of this message is prohibited. If you received this message in error, please > notify the sender immediately. > >
