Errors with JPAStorageService

David E. Newswanger David_Newswanger at berea.edu
Fri Mar 11 16:04:27 EST 2016


>You only need one connection pool library but you have two:
>1. HikariCP-1.1.7.jar
>2. commons-dbcp2-2.1.1.jar, commons-pool2-2.4.2.jar

>Choose one and delete the other's JARs from edit-webapp/WEB-INF/lib/ and
>from webapp/WEB-INF/lib/ (build.sh copies them here too).
>
>> Should I add HikariCP-2.4.2-RC2+SquidSolutions.jar as well? The log
>> file keeps mentioning that.
>
>Your stack trace shows you already have this JAR


This turned out to be my problem. I installed HikariCP-2.4.2-RC2+SquidSolutions.jar when I first tried to install Hikari, and tried to remove it by simply deleting the jar from edit-webapp. I didn't realized I needed to remove it from the webapp directory as well.

Thanks for all of your help! I owe you guys a coffee or something.
________________________________________
From: users <users-bounces at shibboleth.net> on behalf of Etienne Dysli-Metref <etienne.dysli-metref at switch.ch>
Sent: Friday, March 11, 2016 4:30 AM
To: users at shibboleth.net
Subject: Re: Errors with JPAStorageService

On 10/03/16 20:51, David E. Newswanger wrote:
> I replaced my Hikari jar that I built with one that I downloaded from
> http://mvnrepository.com/artifact/com.zaxxer/HikariCP/1.1.7 . I'm
> still getting that squid exception. I currently have
> commons-dbcp2-2.1.1.jar, commons-pool2-2.4.2.jar, HikariCP-1.1.7.jar,
> jstl-1.2.jar and mysql-connector-java.jar in my edit-webapp/.../lib
> directory.

You only need one connection pool library but you have two:
1. HikariCP-1.1.7.jar
2. commons-dbcp2-2.1.1.jar, commons-pool2-2.4.2.jar

Choose one and delete the other's JARs from edit-webapp/WEB-INF/lib/ and
from webapp/WEB-INF/lib/ (build.sh copies them here too).

> Should I add HikariCP-2.4.2-RC2+SquidSolutions.jar as well? The log
> file keeps mentioning that.

Your stack trace shows you already have this JAR:

Caused by: java.lang.NoClassDefFoundError:
com/squid/core/database/impl/DriverShim
  at
com.zaxxer.hikari.util.DriverDataSource.<init>(DriverDataSource.java:63)
~[HikariCP-2.4.2-RC2+SquidSolutions.jar:na]

This is likely not the official HikariCP library. Delete it and download
the real one from the official source at
https://github.com/brettwooldridge/HikariCP. Their "download from here"
link points to
http://search.maven.org/#search%7Cga%7C1%7Ccom.zaxxer.hikaricp i.e.
Maven Central. While you are here, grab the latest release (2.4.4),
version 1.1.7 dates back to November 2013...

  Etienne



More information about the users mailing list