IdP 3.0 500 Error - com.mysql.jdbc.PreparedStatement.setCharacterStream

[Matt Brennan]

Hello,

  I have recently installed IdP 3.0 and am attempting to set it up to
replace our AD FS cluster. I have it working with various SP's when using
Memcached for session storage. However, I'm trying to set it up to use
MySQL instead (to help with clustering, in the event of a node failure).
I've followed the instructions on confluence (details below), but am
getting this error. I am unable to determine the cause. There's nothing
useful in the logs, so all I seem to have is the exception and stack trace
below. Relevant configuration is also below. Any assistance is appreciated.


HTTP Status 500 - Handler processing failed; nested exception is
java.lang.AbstractMethodError:
com.mysql.jdbc.PreparedStatement.setCharacterStream(ILjava/io/Reader;J)V

org.springframework.web.util.NestedServletException: Handler processing
failed; nested exception is java.lang.AbstractMethodError:
com.mysql.jdbc.PreparedStatement.setCharacterStream(ILjava/io/Reader;J)V
org.springframework.web.servlet.DispatcherServlet.triggerAfterCompletionWithError(DispatcherServlet.java:1303)
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:977)
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
javax.servlet.http.HttpServlet.service(HttpServlet.java:644)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
net.shibboleth.idp.log.SLF4JMDCServletFilter.doFilter(SLF4JMDCServletFilter.java:72)
net.shibboleth.utilities.java.support.net.RequestResponseContextFilter.doFilter(RequestResponseContextFilter.java:60)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
net.shibboleth.utilities.java.support.net.CookieBufferingFilter.doFilter(CookieBufferingFilter.java:67)


global.xml:

<bean id="shibboleth.JPAStorageService"
    class="org.opensaml.storage.impl.JPAStorageService"
    p:cleanupInterval="%{idp.storage.cleanupInterval:PT10M}"
    c:factory-ref="shibboleth.JPAStorageService.EntityManagerFactory" />

<bean id="shibboleth.JPAStorageService.EntityManagerFactory"

class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
    <property name="persistenceUnitName" value="storageservice" />
    <property name="packagesToScan" value="org.opensaml.storage.impl" />
    <property name="dataSource"
ref="shibboleth.JPAStorageService.DataSource" />
    <property name="jpaVendorAdapter"
ref="shibboleth.JPAStorageService.JPAVendorAdapter" />
    <property name="jpaDialect">
        <bean
class="org.springframework.orm.jpa.vendor.HibernateJpaDialect" />
    </property>
</bean>

   <bean id="shibboleth.JPAStorageService.JPAVendorAdapter"
    class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
    <property name="database" value="MYSQL" />
   </bean>


<bean id="shibboleth.JPAStorageService.DataSource"
    class="org.apache.tomcat.jdbc.pool.DataSource" destroy-method="close"
lazy-init="true"
    p:driverClassName="com.mysql.jdbc.Driver"

p:url="jdbc:mysql://localhost:3306/idp_db?autoReconnect=true&sessionVariables=wait_timeout=31536000"
    p:validationQuery="SELECT 1;"
    p:username="idp_admin"
    p:password="<censored>" />


idp.properties:
idp.session.StorageService = shibboleth.JPAStorageService

Running on Debian 8, Tomcat 8, MySQL 5.5.46. MySQL connector version
5.1.38.

Thanks
-Matt
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shibboleth.net/pipermail/users/attachments/20160102/55fb5243/attachment.html>