hikari connection pool

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

hikari connection pool

Sergio Contrino
dear intermines,
we have introduced the Hikari database connection pool in release 1.4 of
interMine.
to take advantage of the new connection pool, please follow the
instructions here

http://intermine.readthedocs.org/en/latest/support/upgrade/#upgrade-to-intermine-1-4

They require you to update the default intermine properties that can be
found in your own mine directory and/or in your properties file in the
.intermine directory.

In particular, for each database that you are using, you need to replace
the line setting the old connection pool, usually

db.production.datasource.class=org.postgresql.ds.PGPoolingDataSource

with these 2 lines

db.production.datasource.class=com.zaxxer.hikari.HikariDataSource
db.production.datasource.dataSourceClassName=org.postgresql.ds.PGSimpleDataSource

This fact was not previously explicitly stated in
http://intermine.readthedocs.org/en/latest/support/upgrade/#upgrade-to-intermine-1-4

thank you
sergio


--
sergio contrino                  InterMine, University of Cambridge
https://sergiocontrino.github.io           http://www.intermine.org

_______________________________________________
dev mailing list
[hidden email]
http://mail.intermine.org/cgi-bin/mailman/listinfo/dev