Return-Path: 
 <users-return-9669-apmail-camel-users-archive=camel.apache.org@camel.apache.org>
Delivered-To: apmail-camel-users-archive@www.apache.org
Received: (qmail 75292 invoked from network); 13 Nov 2009 14:21:16 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 13 Nov 2009 14:21:16 -0000
Received: (qmail 21598 invoked by uid 500); 13 Nov 2009 14:21:16 -0000
Delivered-To: apmail-camel-users-archive@camel.apache.org
Received: (qmail 21527 invoked by uid 500); 13 Nov 2009 14:21:16 -0000
Mailing-List: contact users-help@camel.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@camel.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@camel.apache.org>
List-Post: <mailto:users@camel.apache.org>
List-Id: <users.camel.apache.org>
Reply-To: users@camel.apache.org
Delivered-To: mailing list users@camel.apache.org
Received: (qmail 21517 invoked by uid 99); 13 Nov 2009 14:21:16 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 13 Nov 2009 14:21:16 +0000
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of claus.ibsen@gmail.com
 designates 209.85.218.211 as permitted sender)
Received: from [209.85.218.211] (HELO mail-bw0-f211.google.com)
 (209.85.218.211)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 13 Nov 2009 14:21:05 +0000
Received: by bwz3 with SMTP id 3so3787637bwz.36
        for <users@camel.apache.org>; Fri, 13 Nov 2009 06:20:45 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:mime-version:received:in-reply-to:references
         :from:date:message-id:subject:to:content-type;
        bh=aCk1IyBAqqv/ZzJRPWbInV++JZDqwNXDIa9HZaGosZw=;
        b=QtbdD31Sv03iIApAnZXkQh1gC1fwT73JSI41ghdxEdms4YAI0FjbcL4/zbMv/Mm/W6
         abak+la5eEPc8TTeQkLyck2POIj3CtEwbiLUx0fUiQEtPLp5El+CbSbsFU/K6+irJ1jt
         b4ZaTIirsQNXXT4CDrabckjJwbzcQAxKskHxw=
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=tvU/Q3yPmwENjsj6Jdw7AfSPE6Auo3+y5Ph0Xt6V6d4ISp8iWhfmZONe8jiPBkLA6X
         FmirPPUNZ1+ut2EJGQou7UaAohRYkQVEXzXrSPXKuN6eeJZwTqyHjpuU3c2QnaB/JfzF
         anODIOQQS+aISF+iA4HLUFHJ9MDinmNOqqvEU=
MIME-Version: 1.0
Received: by 10.204.6.65 with SMTP id 1mr4883bky.186.1258122045133; Fri, 13
	Nov 2009 06:20:45 -0800 (PST)
In-Reply-To: <26337091.post@talk.nabble.com>
References: <26337091.post@talk.nabble.com>
From: Claus Ibsen <claus.ibsen@gmail.com>
Date: Fri, 13 Nov 2009 15:20:25 +0100
Message-ID: <5380c69c0911130620s41d5686fuf19d9b137fe2f77f@mail.gmail.com>
Subject: Re: Camel Database : Connection management database by Camel?
To: users@camel.apache.org
Content-Type: text/plain; charset=ISO-8859-1
X-Virus-Checked: Checked by ClamAV on apache.org

Hi

You need to use a pooled datasource for connections so they are reused.


On Fri, Nov 13, 2009 at 3:06 PM, titexe <titexe@yahoo.fr> wrote:
>
> Hello,
>
> I have a route camel that take the message in queue OUT and makes an update
> in the database.
>
> In fact that I receive many messages in 10,000 messages.
> I receive an error:
> java.sql.SQLException: Network error IOException: Address already in use
> error.
>
> By checking on the system, I found many connections to the database.
>
> Camel is what creates every time a connection for each message?
>
> What is the solution to share the same connection for a pool of messages?
>
> below my configuration :
>
> <route errorHandlerRef="myDeadLetterChannel">
> <from uri="activemq:queue:OUT"/>
> <t uri="activemq:queue:IN"/>
> <setBody>
> UPDATE SET <simple> InterfaceMonitor CamelSent = CURRENT_TIMESTAMP WHERE Id
> = '$ (in.header.MessageId)' </ simple>
> </ setBody>
> <t uri="jdbc:testdb"/>
> </ route>
>
> <bean id="testdb" class="net.sourceforge.jtds.jdbcx.JtdsDataSource">
> <property name="serverName" value="192.167.10.55"/>
> <property name="portNumber" value="1433"/>
> <property name="databaseName" value="IP"/>
> <property name="user" value="appuser"/>
> <property name="password" value="Passw0rd"/>
> </ bean>
>
>
>
> Thank you in advance
>
> titexe
> --
> View this message in context: http://old.nabble.com/Camel-Database-%3A-Connection-management-database-by-Camel--tp26337091p26337091.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