Hi Yeah your connection pool may allow to setup keep alive queries or test the connection before handing it over to the client.
There is no logic in camel-sql for validating the connection. You can use Camels error handler to retry also which then would get a new connection from the data source etc. On Wed, Jul 31, 2013 at 10:18 AM, Marco Crivellaro <marco.cr...@gmail.com> wrote: > Hi all, > when using camel-sql should connection pooling and connection test be > implemented? > I am building a camel based application which will run as a daemon and might > write the database once every few days. This means between writes the > connection to the database (mysql) might timeout. Is camel testing > connection before writing to the database or will it throw an exception in > case the connection runs in timeout? > > > Thanks, > Marco > > > > -- > View this message in context: > http://camel.465427.n5.nabble.com/camel-sql-connection-test-required-tp5736549.html > Sent from the Camel - Users mailing list archive at Nabble.com. -- Claus Ibsen ----------------- Red Hat, Inc. Email: cib...@redhat.com Twitter: davsclaus Blog: http://davsclaus.com Author of Camel in Action: http://www.manning.com/ibsen
