Hi Aaaron, looking at your datasource definition in the spring configuration i found something that might be wrong.
The property "driverClassName" should point to JDBC driver class (like for example com.mysql.jdbc.Driver) instead of hibernate dialect class Regards Ralf Am Freitag, 11. November 2016 22:50:39 UTC+1 schrieb Aaron Eidt: > > Yes, I have tried removing the entire datasource bean definition and still > no luck. > > > > Thanks, > Aaron > > > > *From:* [email protected] <javascript:> [mailto:[email protected] > <javascript:>] > *Sent:* Friday, November 11, 2016 10:22 AM > *To:* jasig-cas-user <[email protected] <javascript:>> > *Cc:* [email protected] <javascript:>; [email protected] <javascript:>; > Aaron Eidt <[email protected] <javascript:>> > *Subject:* Re: [cas-user] Problem deploying CAS 4.2.2 with MySQL Service > Registry > > > > Hi Aaron, > > > > Looking at the documentation it does indeed say that. When I look at the > config I have there isn't a dataSource bean but it does appear to load. I'm > trying to avoid an assertion here about what the right thing to do is > because I don't feel I am in a place to be authoritative on that matter. > > > > Did you try commenting out the entire dataSource bean definition, I think > that would get what you have closer to what I have. > > > > All the best, > > > > Sam > > On Wednesday, 9 November 2016 21:03:20 UTC, Aaron Eidt wrote: > > Thanks Sam. > > > > I thought the dataSource bean was needed based on the statement in the > documentation “The configuration assumes a dataSource bean is defined in > the context.” > > > > I have tried what you suggested and I am still getting the same error. > > > > Thanks, > Aaron > > > > > > *From:* [email protected] [mailto:[email protected]] > *Sent:* Wednesday, November 09, 2016 12:33 PM > *To:* jasig-cas-user <[email protected]> > *Cc:* [email protected]; Aaron Eidt <[email protected]> > *Subject:* Re: [cas-user] Problem deploying CAS 4.2.2 with MySQL Service > Registry > > > > Hi Aaron, > > > > I struggled for a while with this as well. In the end I added the > mysql-connector dependency you already found (I don't have the hibernate or > mchange ones), and also: > > <dependency> > > <groupId>org.jasig.cas</groupId> > > <artifactId>cas-server-support-jpa-service-registry</artifactId> > > <version>${cas.version}</version> > > </dependency> > > > > In deployerConfigContext.xml I have a line like this > > > > <alias name="jpaServiceRegistryDao" alias="serviceRegistryDao" /> > > > > but not your datasource bean. > > > > The in the cas.properties file (which'll need to be somewhere on the > classpath) you can configure the database with lines like the following: > > > > # JPA Service Registry Database Configuration > > svcreg.database.ddl.auto=create-drop > > > svcreg.database.dialect=org.hibernate.dialect.OracleDialect|MySQLInnoDBDialect|HSQLDialect > > svcreg.database.hibernate.batchSize=10 > > svcreg.database.driverClass=org.hsqldb.jdbcDriver > > svcreg.database.url=jdbc:hsqldb:mem:cas-ticket-registry > > svcreg.database.user=sa > > svcreg.database.password= > > svcreg.database.pool.minSize=6 > > svcreg.database.pool.maxSize=18 > > svcreg.database.pool.maxWait=10000 > > svcreg.database.pool.maxIdleTime=120 > > svcreg.database.pool.acquireIncrement=6 > > svcreg.database.pool.idleConnectionTestPeriod=30 > > svcreg.database.pool.connectionHealthQuery=select 1 > > svcreg.database.pool.acquireRetryAttempts=5 > > svcreg.database.pool.acquireRetryDelay=2000 > > svcreg.database.pool.connectionHealthQuery=select 1 > > > > It's documented here: > https://apereo.github.io/cas/4.2.x/installation/JPA-Service-Management.html > > > > All the best, > > > > Sam Jones. > > > > On Wednesday, 9 November 2016 17:07:36 UTC, Aaron Eidt wrote: > > 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 [email protected]. > 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 > > <https://groups.google.com/a/apereo.org/d/msgid/cas-user/DM5PR11MB1289AEADCB84AC7AFC8D5B01F2B90%40DM5PR11MB1289.namprd11.prod.outlook.com?utm_medium=email&utm_source=footer> > . > > -- > - 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/a/apereo.org/d/msgid/cas-user/DM5PR11MB1289C535B99E28C7E6726414F2B90%40DM5PR11MB1289.namprd11.prod.outlook.com > > <https://groups.google.com/a/apereo.org/d/msgid/cas-user/DM5PR11MB1289C535B99E28C7E6726414F2B90%40DM5PR11MB1289.namprd11.prod.outlook.com?utm_medium=email&utm_source=footer> > . > > -- - 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 [email protected]. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/a06a6a37-6930-4d2d-ba5d-6d4fc83a3919%40apereo.org.
