<div dir="ltr"><div class="gmail_quote"><div dir="ltr">On Thu, Jun 28, 2018 at 8:33 AM Tobias Galéus <<a href="mailto:tobias.galeus@gu.se">tobias.galeus@gu.se</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">    <bean id="shibboleth.JPAStorageService.JPAVendorAdapter"<br>
class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter"><br>
    <property name="database" value="MYSQL" /><br>
    </bean><br>
<br>
    <bean id="shibboleth.JPAStorageService.DataSource"<br>
    class="com.zaxxer.hikari.HikariDataSource" destroy-method="close"<br>
lazy-init="true"<br>
    p:driverClassName="com.mysql.jdbc.Driver"<br>
<br>
p:jdbcUrl="jdbc:mysql://<a href="http://127.0.0.1:3306/shibboleth?cachePrepStmts=true&amp;prepStmtCacheSize=250&amp;prepStmtCacheSqlLimit=2048&amp;cachePrepStmts=true&amp;useServerPrepStmts=true" rel="noreferrer" target="_blank">127.0.0.1:3306/shibboleth?cachePrepStmts=true&amp;prepStmtCacheSize=250&amp;prepStmtCacheSqlLimit=2048&amp;cachePrepStmts=true&amp;useServerPrepStmts=true</a>"<br>
    p:username="USERNAME"<br>
    p:password="P@SSWORD"<br>
    p:autoCommit="false"<br>
    p:transactionIsolation="8"<br>
    p:leakDetectionThreshold="300000"<br>
    p:maximumPoolSize="4"<br>
    p:maxLifetime="28000000"<br>
    /><br></blockquote><div><br></div><div>I believe transactionIsolation is a string, see <a href="https://docs.oracle.com/javase/tutorial/jdbc/basics/transactions.html#transactions_data_integrity">https://docs.oracle.com/javase/tutorial/jdbc/basics/transactions.html#transactions_data_integrity</a>.</div><div>Recommend you leave that as the default value.</div><div><br></div><div>--Daniel Fisher</div><div> </div></div></div>