ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <lmead...@apache.org>
Subject Re: Calling procedures from 2 different databases
Date Fri, 26 Oct 2007 12:32:16 GMT
On 10/24/07, Jeff Butler <jeffgbutler@gmail.com> wrote:
> One database per SqlmapConfig - that's the rule.
> If you have two databases, then you need two instances of the SqlMapConfig.

Not necessarily - you need two instances of the sql map *client*, but
they can be created by passing different properties to the builder.

This is one of those conversations that may need some clarification:
Does 2 databases mean 2 different Oracle servers, or does it mean an
Oracle server and a M$ SQL Server?

In the either case, as long as the servers are the same structurally,
and dialect differences are masked by stored procedures - it should be
simple.

In the second case, if the databases are not the same
structurally...then Jeff's right. Don't try this. :-)

Larry

Mime
View raw message