Mailing-List: contact camel-user-help@activemq.apache.org; run by ezmlm
Precedence: bulk
Reply-To: camel-user@activemq.apache.org
Received-SPF: pass (athena.apache.org: domain of roman.kalukiewicz@gmail.com
 designates 64.233.184.238 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=W3Z01j3KV6b5gofi7fO8qNcZeZe2GlV/KcZp0n2oJx12zHO2DLJd6tdEq991QS7ggIa6nOhBkEtON4jk4iPHgBQ1s4Ik1Dd9N4UwfYtAGhdUWWA7RAt4Bj1eFn9LRNuxYH/tr2VJvJdj7OfLgZNRXK5zTBF7e5qEdHY/niN+Fwk=
Message-ID: <f1c427510802040619k31f651aey3b9e4b968f9cab5f@mail.gmail.com>
Date: Mon, 4 Feb 2008 15:19:16 +0100
From: "Roman Kalukiewicz" <roman.kalukiewicz@gmail.com>
To: camel-user@activemq.apache.org
Subject: Re: JdbcEndpoint - Consumer
In-Reply-To: <ec6e67fd0802040530m37b4d56ex286400c74be4799f@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <15183848.post@talk.nabble.com>
	 <ec6e67fd0802040530m37b4d56ex286400c74be4799f@mail.gmail.com>

> in both cases the idea is generally to make a bean to represent a row.
>
> We could write an SDO component and use that to avoid the user having
> to write a bean...

My $0.02 is that it is not very natural what we currently have in jdbc
component. Event it is, then it is not in sync what we have in other
components (to compare it with JPA for example). Maybe we should think
about creating another component that could express database flows
like this:

from("sql:select a, b, c from d").to("sql:insert into t values :a, :c, :d");

so we pool a database using some select statement - the result is a
Map that maps column names to values. Then it could be sent to some
other sql endpoint that simply could use placeholders to generate
another query.

This way a sql component should be configured with a DataSource.

What do you think about something like this? I can try to create such
a component.

Roman