You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@camel.apache.org by takidean <ta...@hotmail.fr> on 2013/03/26 14:07:48 UTC

from databaes to other

hi everybody when i use to send rows from database to an other it don't work
this is what i did:
<choice>
            <when>
                <xpath>/person/city = 'SMON'</xpath>
                <setBody>
                    <constant>SELECT * FROM REPORT.T_INCIDENT WHERE
INCIDENT_REF = '001' OR INCIDENT_REF = '002';</constant>
                </setBody>
            
            <to uri="jdbc:reportdb"/> 
            <to uri="jdbc:db"/> 
            </when>

any one can help me ?



--
View this message in context: http://camel.465427.n5.nabble.com/from-databaes-to-other-tp5729847.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Re: from databaes to other

Posted by Christian Müller <ch...@gmail.com>.

Because you do not provide the proper insert statements. Like
INSERT INTO FOO (...) VALUES (...).

Best,
Christian

On Tue, Mar 26, 2013 at 2:07 PM, takidean <ta...@hotmail.fr> wrote:

> hi everybody when i use to send rows from database to an other it don't
> work
> this is what i did:
> <choice>
>             <when>
>                 <xpath>/person/city = 'SMON'</xpath>
>                 <setBody>
>                     <constant>SELECT * FROM REPORT.T_INCIDENT WHERE
> INCIDENT_REF = '001' OR INCIDENT_REF = '002';</constant>
>                 </setBody>
>
>             <to uri="jdbc:reportdb"/>
>             <to uri="jdbc:db"/>
>             </when>
>
> any one can help me ?
>
>
>
> --
> View this message in context:
> http://camel.465427.n5.nabble.com/from-databaes-to-other-tp5729847.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
>