Where are service registry properties?
El domingo, 13 de mayo de 2018, Lionel Samuel <[email protected]>
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].
> 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/CAMY5mif7HS5uuZ%2Bj6QTGUaWZ1HuZmQKRqmcV6tF7Y6Pg5P53kA%40mail.gmail.com.
