Hi Manfredo: Thank you again --- your questions guided me --- I changed the value of below from 'oracle.jdbc.driver.OracleDriver'.
cas.ticket.registry.jpa.driverClass=oracle.jdbc.OracleDriver For others that may have same issue --- here are the working JPA for the Ticket and Service Registry (I have other issues now --- but that is separate from the Oracle JDBC class not loading) #### CAS TICKET REGISTRY 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=false cas.ticket.registry.jpa.batchSize=1 #cas.ticket.registry.jpa.defaultCatalog= cas.ticket.registry.jpa.defaultSchema=USER cas.ticket.registry.jpa.user=USER cas.ticket.registry.jpa.ddlAuto=create cas.ticket.registry.jpa.password=SNIP cas.ticket.registry.jpa.autocommit=false cas.ticket.registry.jpa.driverClass=oracle.jdbc.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 # cas.ticket.registry.jpa.crypto.signing.key= # cas.ticket.registry.jpa.crypto.signing.keySize=512 # cas.ticket.registry.jpa.crypto.encryption.key= # cas.ticket.registry.jpa.crypto.encryption.keySize=16 # cas.ticket.registry.jpa.crypto.alg=AES #### CAS SERVICES REGISTRY cas.serviceRegistry.watcherEnabled=true cas.serviceRegistry.repeatInterval=120000 cas.serviceRegistry.startDelay=15000 cas.serviceRegistry.initFromJson=true cas.serviceRegistry.jpa.healthQuery=SELECT 1 FROM DUAL cas.serviceRegistry.jpa.isolateInternalQueries=false cas.serviceRegistry.jpa.url=jdbc:oracle:thin:@foo:bar cas.serviceRegistry.jpa.failFast=true cas.serviceRegistry.jpa.dialect=oracle.jdbc.driver.OracleDriver cas.serviceRegistry.jpa.leakThreshold=10 cas.serviceRegistry.jpa.batchSize=1 cas.serviceRegistry.jpa.defaultCatalog= cas.serviceRegistry.jpa.defaultSchema=USER cas.serviceRegistry.jpa.user=USER cas.serviceRegistry.jpa.ddlAuto=create cas.serviceRegistry.jpa.password=SNIP cas.serviceRegistry.jpa.autocommit=false cas.serviceRegistry.jpa.driverClass=oracle.jdbc.OracleDriver cas.serviceRegistry.jpa.idleTimeout=5000 cas.serviceRegistry.jpa.pool.suspension=false cas.serviceRegistry.jpa.pool.minSize=6 cas.serviceRegistry.jpa.pool.maxSize=18 cas.serviceRegistry.jpa.pool.maxIdleTime=1000 cas.serviceRegistry.jpa.pool.maxWait=2000 On Sunday, May 13, 2018 at 2:30:03 PM UTC-7, Manfredo Hopp wrote: > > Your highlighted messages are warnings. Focus on error eg ddl error etc > > El domingo, 13 de mayo de 2018, Lionel Samuel <[email protected] > <javascript:>> escribió: > >> 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] <javascript:>. >> 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 >> >> <https://groups.google.com/a/apereo.org/d/msgid/cas-user/8403eca9-b1aa-4fe0-8891-b874589990a0%40apereo.org?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/442206f8-e2d3-4e6f-ad24-2e225b066155%40apereo.org.
