title: Maintain db connection inside Camel Route
body: <p><strong>Requirement</strong>: We create a database connection inside a java application. We need to run all the statements through the same connection on the entire Java application.
  <strong>Problem</strong>: Once passing the the created datasource in the Camel route, it apparently creates a new connections.</p>
  
  <p>I am using a DataSource Object that creates a connection to an Oracle database. On this connection i run several statements. </p>
  
  <pre><code>Connection myConn = myDBDatasource.getConnection()
  </code></pre>
  
  <p>As a second part, i use the created datasource for my Camel route</p>
  
  <pre><code>SimpleRegistry reg = new SimpleRegistry();
  reg.put("myDBDatasource", myDBDatasource);
  </code></pre>
  
  <p>Inside my route, i use a bean that creates a query which finally ends to my database.</p>
  
  <pre><code>from("direct:start").bean(MyClass.class,
  "processData").to("jdbc:oracleDataSource?resetAutoCommit=false");
  </code></pre>
  
  <p>So the problem in this case that i create a new connection at the start which i want to use throughout the entire application. Once Camel is doing the routing to the DB, it creates a new one.</p>
  
  <p><strong>Question 1</strong>: Is there any way to maintain somehow the same Connection (myConn) also inside Camel RouteBuilder ? 
  <strong>Question 2</strong>: My datasource is already set to DefaultAutoCommit(<strong>false</strong>) . Could it be that inside the RouteBuilder Camel ignores this and still commits the queries ?</p>