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]<mailto:[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/BN6PR05MB3634493DE6A1C5C479F9441286370%40BN6PR05MB3634.namprd05.prod.outlook.com.
