Shibboleth and database connection leak

[Daniel Fisher]

On Thu, Jun 28, 2018 at 8:33 AM Tobias Galéus <tobias.galeus at gu.se> wrote:

>     <bean id="shibboleth.JPAStorageService.JPAVendorAdapter"
> class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
>     <property name="database" value="MYSQL" />
>     </bean>
>
>     <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://
> 127.0.0.1:3306/shibboleth?cachePrepStmts=true&prepStmtCacheSize=250&prepStmtCacheSqlLimit=2048&cachePrepStmts=true&useServerPrepStmts=true
> "
>     p:username="USERNAME"
>     p:password="P at SSWORD"
>     p:autoCommit="false"
>     p:transactionIsolation="8"
>     p:leakDetectionThreshold="300000"
>     p:maximumPoolSize="4"
>     p:maxLifetime="28000000"
>     />
>

I believe transactionIsolation is a string, see
https://docs.oracle.com/javase/tutorial/jdbc/basics/transactions.html#transactions_data_integrity
.
Recommend you leave that as the default value.

--Daniel Fisher
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shibboleth.net/pipermail/users/attachments/20180628/67244b7f/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 6317 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://shibboleth.net/pipermail/users/attachments/20180628/67244b7f/attachment.p7s>