[cas-user] Problem deploying CAS 4.2.2 with MySQL Service Registry

[Aaron Eidt]

I wondered if someone can help us with a CAS 4.2.2 deployment problem.

For the past 2 weeks, we tried to deploy CAS 4.2.2 with mysql for
serviceRegistry without success. It failed with "Unable to acquire JDBC
Connection" error.

We searched the Unicon github. Only found a simple samle using json.
There was not much info out there in the CAS-user or CAS-community either.

Here's our config

deployercontext.xml

  <bean        id="dataSource"
        class="com.mchange.v2.c3p0.ComboPooledDataSource"
p:driverClassName="org.hibernate.dialect.MySQL5InnoDBDialect"
p:url="jdbc:mysql://localhost:3306/serviceregistry?autoReconnect=true"
p:password="...."
        p:username="webxxxx" />

The pom.xml

   <dependency>
    <groupId>com.mchange</groupId>
    <artifactId>c3p0</artifactId>
    <version>0.9.2.1</version>
  </dependency>


<dependency>
            <groupId>org.hibernate</groupId>
            <artifactId>hibernate-core</artifactId>
            <version>5.1.0.Final</version>
        </dependency>


  <dependency>
    <groupId>org.hibernate</groupId>
   <artifactId>hibernate-entitymanager</artifactId>
    <version>5.1.0.Final</version>
</dependency>


<!--
    MySQL Connector
-->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.26</version>
</dependency>

Error in the tomcat log

Caused by:
org.springframework.transaction.CannotCreateTransactionException: Could
not open JPA EntityManager for transaction; nested exception is
javax.persistence.PersistenceException:
org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC
Connection


Are we missing anything in pom.xml?

Any help is appreciated!

Thanks in advance!


-- 
- CAS gitter chatroom: https://gitter.im/apereo/cas
- CAS mailing list guidelines: https://apereo.github.io/cas/Mailing-Lists.html
- CAS documentation website: https://apereo.github.io/cas
- CAS project website: https://github.com/apereo/cas
--- 
You received this message because you are subscribed to the Google Groups "CAS 
Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cas-user+unsubscr...@apereo.org.
To view this discussion on the web visit 
https://groups.google.com/a/apereo.org/d/msgid/cas-user/DM5PR11MB1289AEADCB84AC7AFC8D5B01F2B90%40DM5PR11MB1289.namprd11.prod.outlook.com.