I am using cas 5.3.0 and i am trying to persist tickets using jpa, running
into issues can you give you share your pom.xml and properties file that
actually worked for you.
On Monday, December 11, 2017 at 11:54:56 PM UTC+5:30, jquin014 wrote:
>
> 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
> jqui...@fiu.edu <javascript:>
>
>
>
--
- 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 cas-user+unsubscr...@apereo.org.
To view this discussion on the web visit
https://groups.google.com/a/apereo.org/d/msgid/cas-user/fa1a7042-fc90-4b97-8735-c5b317f1f93b%40apereo.org.
