Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (athena.apache.org: domain of david.mcreynolds@gmail.com
 designates 72.14.220.156 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:mime-version:content-type;
        b=g2WenwqtzZfAR0CniUXwJeTvqoFV8oQfcHTeK0RE/RrXyY3UKgV3Av/nRoY0awz7i8
         iSajUbXd/d26q/fUaoX6+i5BI3pi+zs67EHNpiZ0p3aan5C1n0+cxUiSfIXt94UVD9Ok
         z3KfTrwPFanlESzvU3HM+iwsyl/37towO4OYk=
Message-ID: <20c3fff50810210653w4c28b321h150f5f85b1727135@mail.gmail.com>
Date: Tue, 21 Oct 2008 09:53:36 -0400
From: "David McReynolds" <david.mcreynolds@gmail.com>
To: ibatis-user-list <user-java@ibatis.apache.org>
Subject: duplicate databases
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_12872_10614024.1224597216264"

------=_Part_12872_10614024.1224597216264
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Precondition: I know this is a screwy set up. But, it is, what it is. What I
need, are ideas for dealing with it, and any heads up dor potential
nightmares.

We have two databases that are supposed to remain synchronized. For some
reason, there is no abstraction layer (hardware or otherwise) that presents
the databases as one to the application layer.

What I have done so far, is create two sqlMapConfig files which define the
two datasources and include the map files.

Then, I have an SqlMapClientFactory that accepts a "resourceName" and a
"resourceType", the latter being "Primary" or "Secondary", the former being
one of many different datasources the application must deal with.

Finally, I altered the iBator generated DAO constructors to accept the
"resourceName". Then each method has to be get the SqlMapClient instance
from the factory (which is caching the references: Primary and Secondary).
The bodies of the DAO methods are written with try/catch and the catch
blocks attempt the same operation but with the "Secondary" SqlMapClient.
Only if the secondary fails is the standard ibatis sql exception allowed to
propagate up.

--
dlm

------=_Part_12872_10614024.1224597216264
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Precondition: I know this is a screwy set up. But, it is, what it is. What I need, are ideas for dealing with it, and any heads up dor potential nightmares.<br><br>We have two databases that are supposed to remain synchronized. For some reason, there is no abstraction layer (hardware or otherwise) that presents the databases as one to the application layer.<br>
<br>What I have done so far, is create two sqlMapConfig files which define the two datasources and include the map files.<br clear="all"><br>Then, I have an SqlMapClientFactory that accepts a &quot;resourceName&quot; and a &quot;resourceType&quot;, the latter being &quot;Primary&quot; or &quot;Secondary&quot;, the former being one of many different datasources the application must deal with.<br>
<br>Finally, I altered the iBator generated DAO constructors to accept the &quot;resourceName&quot;. Then each method has to be get the SqlMapClient instance from the factory (which is caching the references: Primary and Secondary). The bodies of the DAO methods are written with try/catch and the catch blocks attempt the same operation but with the &quot;Secondary&quot; SqlMapClient. Only if the secondary fails is the standard ibatis sql exception allowed to propagate up.<br>
<br>--<br>dlm<br>

------=_Part_12872_10614024.1224597216264--