Mailing-List: contact users-help@camel.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@camel.apache.org
Date: Mon, 26 Oct 2015 02:42:05 -0700 (MST)
From: dermoritz <tanteanni@hotmail.com>
To: users@camel.apache.org
Message-ID: <1445852525942-5773060.post@n5.nabble.com>
Subject: [camel-jdbc] how to fast batch update/insert?
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I need to write many updates and inserts very fast. The speed of running many
prepared statements is to slow because of server round trip/network.

At the moment my route uses jdbc component to read and write date.

The only way i see with this setup to batch- update/insert is to aggregate
and create a big multi-insert/update. But this query would be very data base
specific.

Is there a way to leverage  statement.executeBatc
<http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#executeBatch()> 
h in some way. Or let camel do the batching in general?

thanks in advance


--
View this message in context: http://camel.465427.n5.nabble.com/camel-jdbc-how-to-fast-batch-update-insert-tp5773060.html
Sent from the Camel - Users mailing list archive at Nabble.com.