oracle.jdbc.driver.OracleDriver was not found

[Lionel Samuel]

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

[Man H]

Where are service registry properties?

--
- 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+unsubscribe@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.

[Lionel Samuel]

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]

To unsubscribe from this group and stop receiving emails from it, send an email to cas-user+u...@apereo.org.

[Man H]

Where are your  cas properties. See where they are fetched from when cas starts un Catalina.out

To unsubscribe from this group and stop receiving emails from it, send an email to cas-user+unsubscribe@apereo.org.
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.

[Lionel Samuel]

Hi Manfredo:

'cas.properties' is at '/etc/cas' --- from the startup logs in 'catalina.out':

2018-05-13 14:08:59,090 INFO [org.apereo.cas.configuration.config.CasCoreBootstrapStandaloneConfiguration] - <Configuration files found at [/etc/cas/config] are [[/etc/cas/config/application.yml, /etc/cas/config/cas.properties]]>

2018-05-13 14:08:59,129 INFO [org.apereo.cas.configuration.config.CasCoreBootstrapStandaloneConfiguration] - <Found and loaded [80] setting(s) from [/etc/cas/config]>
2018-05-13 14:08:59,130 INFO [org.springframework.cloud.bootstrap.config.PropertySourceBootstrapConfiguration] - <Located property source: PropertiesPropertySource {name='standaloneCasConfigService'}>

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.

[Man H]

Your highlighted messages are warnings. Focus on error eg ddl error etc

El domingo, 13 de mayo de 2018, Lionel Samuel <lionel....@gmail.com> escribió:

--
- 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+unsubscribe@apereo.org.

[Lionel Samuel]

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

To unsubscribe from this group and stop receiving emails from it, send an email to cas-user+u...@apereo.org.