title: Apache Ignite JDBC driver - JDBC Connection Pool options
body: <p>I'm currently trying to set-up Apache Ignite with C3P0 as my JDBC Connection pool, but I noticed that since the Ignite driver doesn't support transactions, C3P0's not usable.</p>
  
  <p>Has anyone had any luck getting a JDBC connection pool going with the Ignite driver? Suggestions?</p>
  
  <hr>
  
  <p>EDIT:</p>
  
  <p>Updating with exactly why C3P0 doesn't work with Ignite's JDBC Driver</p>
  
  <p>So take a look at <a href="https://github.com/swaldman/c3p0/blob/master/src/java/com/mchange/v2/c3p0/impl/NewPooledConnection.java#L120" rel="nofollow noreferrer">this line of code</a> 
  To create a new pooled connection, C3P0 attempts to set transaction isolation through the connection/driver.</p>
  
  <p>That eventually leads us to <a href="https://github.com/apache/ignite/blob/master/modules/core/src/main/java/org/apache/ignite/internal/jdbc2/JdbcConnection.java#L360" rel="nofollow noreferrer">this line of code</a> in the Ignite driver,  which basically tells us that the Ignite driver doesn't support SQL transactions.<br>
  Ignite itself DOES support transactions as specified <a href="http://apacheignite.gridgain.org/v1.2/docs/transactions" rel="nofollow noreferrer">here</a> but it appears the JDBC implementation does not.</p>
  
  <p>So I need an alternative to C3P0 if I want to set up a JDBC connection pool; any suggestions?</p>