I have google this to kingdom come --- but still stumped.
I have started to experiment with JPA for both the service and ticket
registries (starting with the ticket registry).
I am receiving the 'oracle.jdbc.driver.OracleDriver was not found' message
on tomcat startup --- I have added the OJDBC7.jar to the build.sh's pom,
and for added measure also added to the /opt/tomcat/lib (after the build,
the jar alo appears in
/opt/tomcat/webapps/cas/WEB-INF/lib/ojdbc7.jar-12.1.0.1.jar).
Any ideas on what I could have left our or an error that I missed?
*Error Message:*
2018-05-13 12:03:08,172 INFO
[org.apereo.cas.web.CasWebApplicationServletInitializer] - <The following
profiles are active: standalone>
2018-05-13 12:03:17,232 WARN [com.zaxxer.hikari.HikariConfig] -
<HikariPool-1 - idleTimeout is close to or more than maxLifetime, disabling
it.>
2018-05-13 12:03:17,232 WARN [com.zaxxer.hikari.HikariConfig] -
<HikariPool-1 - leakDetectionThreshold is less than 2000ms or more than
maxLifetime, disabling it.>
2018-05-13 11:58:15,291 WARN [com.zaxxer.hikari.HikariConfig] -
<HikariPool-1 - leakDetectionThreshold is less than 2000ms or more than
maxLifetime, disabling it.>
2018-05-13 11:58:15,298 WARN [com.zaxxer.hikari.util.DriverDataSource] -
<Registered
driver with driverClassName=oracle.jdbc.driver.OracleDriver was not found,
trying direct instantiation.>
2018-05-13 11:58:18,811 WARN
[org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl] -
<GenerationTarget encountered exception accepting command : Error executing
DDL via JDBC Statement>
org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing
DDL via JDBC Statement
...
*pom.xml*
<dependency>
<groupId>org.apereo.cas</groupId>
<artifactId>cas-server-support-ldap</artifactId>
<version>${cas.version}</version>
</dependency>
<dependency>
<groupId>org.apereo.cas</groupId>
<artifactId>cas-server-support-json-service-registry</artifactId>
<version>${cas.version}</version>
</dependency>
<dependency>
<groupId>org.apereo.cas</groupId>
<artifactId>cas-server-support-jpa-service-registry</artifactId>
<version>${cas.version}</version>
</dependency>
<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>ojdbc7.jar</artifactId>
<version>12.1.0.1</version>
</dependency>
*ojdbc locations*
/opt/tomcat/lib/ojdbc7.jar
/opt/tomcat/webapps/cas/WEB-INF/lib/ojdbc7.jar-12.1.0.1.jar
*cas.properties*
cas.ticket.registry.jpa.jpaLockingTimeout=3600
cas.ticket.registry.jpa.healthQuery=SELECT 1 FROM DUAL
cas.ticket.registry.jpa.isolateInternalQueries=false
cas.ticket.registry.jpa.url=jdbc:oracle:thin:@foo:bar
cas.ticket.registry.jpa.failFast=true
cas.ticket.registry.jpa.dialect=org.hibernate.dialect.Oracle12cDialect
cas.ticket.registry.jpa.leakThreshold=10
cas.ticket.registry.jpa.jpaLockingTgtEnabled=true
cas.ticket.registry.jpa.batchSize=1
cas.ticket.registry.jpa.defaultCatalog=
cas.ticket.registry.jpa.defaultSchema=
cas.ticket.registry.jpa.user=USER
cas.ticket.registry.jpa.ddlAuto=create-drop
cas.ticket.registry.jpa.password=SNIP
cas.ticket.registry.jpa.autocommit=false
cas.ticket.registry.jpa.driverClass=oracle.jdbc.driver.OracleDriver
cas.ticket.registry.jpa.idleTimeout=5000
cas.ticket.registry.jpa.pool.suspension=false
cas.ticket.registry.jpa.pool.minSize=6
cas.ticket.registry.jpa.pool.maxSize=18
cas.ticket.registry.jpa.pool.maxWait=2000
--
- 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/8403eca9-b1aa-4fe0-8891-b874589990a0%40apereo.org.
