If you meant ticket registry use cas.ticket.registry.jpa.healthQuery
If service registry as.serviceRegistry.jpa.healthQuery El lunes, 11 de diciembre de 2017, Juan Quintanilla <[email protected]> escribió: > Hi, > > > I'm running CAS 5.1.2 using tomcat 8.5 and java 8 and trying to configure > the Oracle JPA ticket registry but running into issues. I have been able to > configure this with CAS 4 and CAS 3 in the past but for some reason I'm > encountering the error below: > > > 2017-12-11 13:07:04,885 WARN [com.zaxxer.hikari.util.DriverDataSource] - > <Registered driver with driverClassName=oracle.jdbc.driver.OracleDriver > was not found, trying direct instantiation.> > 2017-12-11 13:07:05,463 ERROR [com.zaxxer.hikari.pool.PoolBase] - > <HikariPool-1 - Failed to execute connection test query (ORA-00923: FROM > keyword not found where expected > ).> > 2017-12-11 13:07:05,465 ERROR [com.zaxxer.hikari.pool.HikariPool] - > <HikariPool-1 - Exception during pool initialization.> > java.sql.SQLSyntaxErrorException: ORA-00923: FROM keyword not found where > expected > > at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) > ~[ojdbc8-12.2.0.1.0.jar:12.2.0.1.0] > > > > I verified that the ojdbc8 is in both the tomcat lib folder and in the cas > lib folder. > > > I have configured my pom.xml as follows and setup the cas.properties file > with the configuration below: > > > pom.xml > > <dependency> > <groupId>org.apereo.cas</groupId> > <artifactId>cas-server-support-jpa-ticket-registry</artifactId> > <version>${cas.version}</version> > </dependency> > > <dependency> > <groupId>com.oracle</groupId> > <artifactId>ojdbc8</artifactId> > <version>12.2.0.1.0</version> > <scope>runtime</scope> > </dependency> > <dependency> > <groupId>org.apereo.cas</groupId> > <artifactId>cas-server-support-jdbc-drivers</artifactId> > <version>${cas.version}</version> > </dependency> > > > > cas.properties > > cas.serviceRegistry.jpa.isolateInternalQueries=false > cas.serviceRegistry.jpa.url=jdbc:oracle:thin:XXXX > cas.serviceRegistry.jpa.failFast=true > cas.serviceRegistry.jpa.dialect=org.hibernate.dialect.Oracle12cDialect > cas.serviceRegistry.jpa.leakThreshold=10 > cas.serviceRegistry.jpa.batchSize=1 > cas.serviceRegistry.jpa.user=XXXX > cas.serviceRegistry.jpa.ddlAuto=create-drop > cas.serviceRegistry.jpa.password=XXXX > cas.serviceRegistry.jpa.autocommit=false > cas.serviceRegistry.jpa.driverClass=oracle.jdbc.driver.OracleDriver > cas.serviceRegistry.jpa.idleTimeout=5000 > cas.serviceRegistry.jpa.dataSourceName= > cas.serviceRegistry.jpa.dataSourceProxy=false > > cas.serviceRegistry.jpa.pool.suspension=false > cas.serviceRegistry.jpa.pool.minSize=6 > cas.serviceRegistry.jpa.pool.maxSize=18 > cas.serviceRegistry.jpa.pool.maxWait=2000 > > > Just wanted to see if anyone else has run into a similar issue. > > > Thanks! > > > ___________________ > Juan Quintanilla > [email protected] > > > -- > - Website: https://apereo.github.io/cas > - Gitter Chatroom: https://gitter.im/apereo/cas > - List Guidelines: https://goo.gl/1VRrw7 > - Contributions: https://goo.gl/mh7qDG > --- > 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/BN6PR05MB3634493DE6A1C5C479F94 > 41286370%40BN6PR05MB3634.namprd05.prod.outlook.com > <https://groups.google.com/a/apereo.org/d/msgid/cas-user/BN6PR05MB3634493DE6A1C5C479F9441286370%40BN6PR05MB3634.namprd05.prod.outlook.com?utm_medium=email&utm_source=footer> > . > -- - Website: https://apereo.github.io/cas - Gitter Chatroom: https://gitter.im/apereo/cas - List Guidelines: https://goo.gl/1VRrw7 - Contributions: https://goo.gl/mh7qDG --- 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/CAMY5mifHtFkkNNV%2Bt_WMX-BZpHOjWNQLGZdZmKDE0%2B-FVdrVeg%40mail.gmail.com.
