hikari datasource definition

[Liam Hoekenga]

I started getting these...

2017-12-01 18:01:19,005 - WARN [com.zaxxer.hikari.pool.PoolBase:183] -  -
HikariPool-1 - Failed to validate connection
com.mysql.jdbc.JDBC4Connection at 7d947981 (No operations allowed after
connection closed.)

The suggestion I've found is to set HikariCP's maxLifetime to be less that
MySQL's wait_timeout.

I define my Hikari source in global.xml:

    <bean id="shibboleth.JPAStorageService.DataSource"
        class="com.zaxxer.hikari.HikariDataSource" destroy-method="close"
lazy-init="true"
        p:driverClassName="com.mysql.jdbc.Driver"
        p:jdbcUrl="jdbc:mysql://mysqldb.example.edu:3306/shibboleth"
        p:username="shibboleth"
        p:password="PASSWORD"/>

Do the "p" (properties) get passed unmodified to hikari?  Will
p:maxLifetime actually make it to Hikari?

Liam
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shibboleth.net/pipermail/users/attachments/20171201/f9b09366/attachment.html>