Hi Manfredo:
>Where are service registry properties?
Thank you -- I did not have them initially --- I had mistakenly thought
that I could test the Ticket Registry Oracle DB connections independently
to the Service Registry.
After receiving your posted, I've added the Service Registry properties
(listed below). Since then the error messages have changed (also listed
below) --- however ' driverClassName=oracle.jdbc.driver.OracleDriver was
not found, trying direct instantiation' remains.
Is there anything else I am missing?
#### 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.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
# 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.driver.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
2018-05-13 12:58:43,075 WARN [com.zaxxer.hikari.HikariConfig] -
<HikariPool-1 - idleTimeout is close to or more than maxLifetime, disabling
it.>
2018-05-13 12:58:43,075 WARN [com.zaxxer.hikari.HikariConfig] -
<HikariPool-1 - leakDetectionThreshold is less than 2000ms or more than
maxLifetime, disabling it.>
2018-05-13 12:58:43,096 WARN [com.zaxxer.hikari.util.DriverDataSource] -
<Registered driver with driverClassName=oracle.jdbc.driver.OracleDriver was
not found, trying direct instantiation.>
2018-05-13 12:58:53,866 WARN [com.zaxxer.hikari.HikariConfig] -
<HikariPool-2 - idleTimeout is close to or more than maxLifetime, disabling
it.>
2018-05-13 12:58:53,866 WARN [com.zaxxer.hikari.HikariConfig] -
<HikariPool-2 - leakDetectionThreshold is less than 2000ms or more than
maxLifetime, disabling it.>
2018-05-13 12:58:53,867 WARN [com.zaxxer.hikari.util.DriverDataSource] -
<Registered driver with driverClassName=oracle.jdbc.driver.OracleDriver was
not found, trying direct instantiation.>
2018-05-13 12:58:54,556 WARN
[org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator] -
<HHH000342: Could not obtain connection to query metadata : Unable to
construct requested dialect [oracle.jdbc.driver.OracleDriver]>
2018-05-13 12:58:54,556 WARN
[org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext]
- <Exception encountered during context initialization - cancelling refresh
attempt: org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'serviceEntityManagerFactory' defined in class path
resource [org/apereo/cas/config/JpaServiceRegistryConfiguration.class]:
Invocation of init method failed; nested exception is
org.hibernate.service.spi.ServiceException: Unable to create requested
service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]>
2018-05-13 12:58:54,561 WARN
[com.ryantenney.metrics.spring.config.annotation.MetricsConfigurerAdapter]
- <Problem stopping reporter>
org.springframework.beans.factory.BeanCreationNotAllowedException: Error
creating bean with name 'casMetricsConfiguration': Singleton bean creation
not allowed while singletons of this factory are in destruction (Do not
request a bean from a BeanFactory in a destroy method implementation!)
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:216)
~[spring-beans-4.3.16.RELEASE.jar:4.3.16.RELEASE]
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308)
~[spring-beans-4.3.16.RELEASE.jar:4.3.16.RELEASE]
On Sunday, May 13, 2018 at 12:40:48 PM UTC-7, Manfredo Hopp wrote:
>
> Where are service registry properties?
>
> 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/06a2d3a2-458b-4103-9aeb-ad7099b890d3%40apereo.org.
