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 cas-user+unsubscr...@apereo.org.
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.
