Hi Omar, > will we hit DB using new JDBC connection for every hit ? > or will we using the same JDBC template for all ?
First of all your question is not related to Camel. From what you wrote, I understand that you are using Camel to expose Jetty endpoint. That implies that database connectivity is beyond the governance of Camel. The connection pooling is handled by DataSource, not by the JdbcTemplate. The latter calls the former without any assumptions related to connection pooling. If you are using singleton instance of pooling data source (like DBCP), then your connections to Oracle will be reused. Best regards. -- Henryk Konsek http://henryk-konsek.blogspot.com
