Mailing-List: contact users-help@camel.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@camel.apache.org
Received-SPF: pass (nike.apache.org: domain of claus.ibsen@gmail.com
 designates 209.85.218.211 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to
         :content-type;
        b=TRWv0N1PjTJJK/vP2GnIbwlNgvEcaIpKOFUPJHbvWMZnRm7JyoRI4Dad7dV/xcJc8z
         WA/q8+gBkkPdbw1IyXLa0njuTYCwC16CuyHfm9EDxN52coy+NpB9pE8wAjcd2twiA7eg
         UXBFBn5QvhL9Z3zU91DDpHtowCP9KrlDpLBLU=
MIME-Version: 1.0
In-Reply-To: <26060031.post@talk.nabble.com>
References: <26030539.post@talk.nabble.com>
 <5380c69c0910240000p38c68d4el3628145ce77b066d@mail.gmail.com>
	<26060031.post@talk.nabble.com>
From: Claus Ibsen <claus.ibsen@gmail.com>
Date: Mon, 26 Oct 2009 14:54:49 +0100
Message-ID: <5380c69c0910260654q256a563bn5195591ecc41ec82@mail.gmail.com>
Subject: Re: Camel iBatis : management of real-time recording of a database?
To: users@camel.apache.org
Content-Type: text/plain; charset=ISO-8859-1

On Mon, Oct 26, 2009 at 2:46 PM, titexe <titexe@yahoo.fr> wrote:
>
> you're right, the best solution is to use triggers
>
> DB [Triggers -> Stored Procedure ->. Net (put in the tail)] -> Queue ->
> [Camel (Get Message) -> (Insert to DB)]
>
> my question is: is that iBatis will offer a solution in relation to my
> problem?
>

No triggers a native in the Database. You have to setup the triggers
inside the database.
You do this using a SQL like syntax that is specific for your database.

You can talk with the people in your organization that works with
databases for help.

iBatis is used from Java to access the database. It cannot use triggers.


> Thanks in advance,
>
> titexe
>
> PS : I am still reading the book "camel in action", all my comments and my
> suggestions, you'll find in the forum.
>
>
> Claus Ibsen-2 wrote:
>>
>> On Fri, Oct 23, 2009 at 7:41 PM, titexe <titexe@yahoo.fr> wrote:
>>>
>>> Hello,
>>>
>>> We would like to copy in real time the inserted records in a database to
>>> another,
>>>
>>> my question is: the component ibatis camel can manage this mode(real
>>> time)?
>>>
>>
>> People can solve this in the DB itself by using triggers to copy data
>> from one table to another.
>> Then its "real time"
>>
>>
>>> Best regards,
>>>
>>> titexe
>>>
>>> PS : I bought your book camel in action, it has served me well, I wish
>>> you
>>> good continuation
>>> --
>>> View this message in context:
>>> http://www.nabble.com/Camel-iBatis-%3A-management-of-real-time-recording-of-a-database--tp26030539p26030539.html
>>> Sent from the Camel - Users mailing list archive at Nabble.com.
>>>
>>>
>>
>>
>>
>> --
>> Claus Ibsen
>> Apache Camel Committer
>>
>> Author of Camel in Action: http://www.manning.com/ibsen/
>> Open Source Integration: http://fusesource.com
>> Blog: http://davsclaus.blogspot.com/
>> Twitter: http://twitter.com/davsclaus
>>
>>
>
> --
> View this message in context: http://www.nabble.com/Camel-iBatis-%3A-management-of-real-time-recording-of-a-database--tp26030539p26060031.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
>
>


-- 
Claus Ibsen
Apache Camel Committer

Author of Camel in Action: http://www.manning.com/ibsen/
Open Source Integration: http://fusesource.com
Blog: http://davsclaus.blogspot.com/
Twitter: http://twitter.com/davsclaus