Configure HikariCP as a DataSource Factory for Tomcat?

[Martin Cordova]

Hello, is it possible to configure HikariCP as a Resource in Tomcat's context.xml file?

I just did it with DBCP V2 (not included in Tomcat 7):

<Context>

<Resource name="jdbc/dinamica" auth="Container" type="javax.sql.DataSource" 

factory="org.apache.commons.dbcp2.BasicDataSourceFactory"

initialSize="3" maxActive="100" maxIdle="10" maxWait="3000" maxTotal="100"

username="xxxxxx" password="xxxxx" 

driverClassName="org.postgresql.Driver"

url="jdbc:postgresql://localhost/demodb"/>

</Context>

I had to change maxActive attribute to maxTotal, and add the factory attribute. It works OK, assuming the required JARs are added to the lib folder.

I wonder if something similar can be done with HikariCP?

Regards,

Martin

--

Dinamica Framework

http://www.martincordova.com

[Brett Wooldridge]

Maybe a Tomcat user can jump in here and answer.  I know we have several Tomcat users, as in the past they've opened issues (that have been fixed).

[Brett Wooldridge]

I have checked in a JNDI factory (com.zaxxer.hikari.HikariJNDIFactory) similar to the one provided by Tomcat.  It is in the 'dev' branch and is untested, but if you'd try it out an tell me if it work (or what errors you get), it would be appreciated.

git clone https://github.com/brettwooldridge/HikariCP.git

cd HikariCP

git checkout dev

mvn install

Then use 1.3.7-SNAPSHOT as your version dependency, or use the HikariCP-1.3.7-SNAPSHOT.jar from the target directory.

[Brett Wooldridge]

This feature can be found in the 1.3.8 release of HikariCP available in maven central repository.