# Error when change the db from h2 to oracle

**URL:** <https://forum.flowable.org/t/error-when-change-the-db-from-h2-to-oracle/5620>\
**Category:** Flowable Application\
**Created:** [March 12, 2020, 3:35pm UTC](https://forum.flowable.org/t/error-when-change-the-db-from-h2-to-oracle/5620 "2020-03-12T15:35:29Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Acronis](https://avatars.discourse-cdn.com/v4/letter/a/b9bd4f/32.png) [@Acronis](https://forum.flowable.org/u/Acronis)\
**Post date:** [March 12, 2020, 3:35pm UTC](https://forum.flowable.org/t/error-when-change-the-db-from-h2-to-oracle/5620/1 "2020-03-12T15:35:29Z")

</div>

Hi, all.

**I have a similar problem as [Error when change the database to oracle](https://forum.flowable.org/t/error-when-change-the-database-to-oracle/2537)**, but error is “Cannot load driver class: oracle.jdbc.OracleDriver”

Use:  
Docker image: [https://hub.docker.com/r/flowable/all-in-one](https://hub.docker.com/r/flowable/all-in-one)  
SPRING\_DATASOURCE\_DRIVER-CLASS-NAME = oracle.jdbc.OracleDriver

Log:  
2020-03-12 15:14:31.321 WARN 1 — [main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.context.ApplicationContextException: Unable to start web server; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘servletEndpointRegistrar’ defined in class path resource [org/springframework/boot/actuate/autoconfigure/endpoint/web/ServletEndpointManagementContextConfiguration$WebMvcServletEndpointManagementContextConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.boot.actuate.endpoint.web.ServletEndpointRegistrar]: Factory method ‘servletEndpointRegistrar’ threw exception; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘processEngineEndpoint’ defined in class path resource [org/flowable/spring/boot/EndpointAutoConfiguration.class]: Unsatisfied dependency expressed through method ‘processEngineEndpoint’ parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘processEngine’ defined in class path resource [org/flowable/spring/boot/ProcessEngineServicesAutoConfiguration$AlreadyInitializedAppEngineConfiguration.class]: Unsatisfied dependency expressed through method ‘processEngine’ parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘org.flowable.spring.boot.app.AppEngineServicesAutoConfiguration’: Unsatisfied dependency expressed through method ‘setEngineConfigurers’ parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘processAppEngineConfigurationConfigurer’ defined in class path resource [org/flowable/spring/boot/ProcessEngineAutoConfiguration$ProcessEngineAppConfiguration.class]: Unsatisfied dependency expressed through method ‘processAppEngineConfigurationConfigurer’ parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘processEngineConfigurator’ defined in class path resource [org/flowable/spring/boot/ProcessEngineAutoConfiguration$ProcessEngineAppConfiguration.class]: Unsatisfied dependency expressed through method ‘processEngineConfigurator’ parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘springProcessEngineConfiguration’ defined in class path resource [org/flowable/spring/boot/ProcessEngineAutoConfiguration.class]: Unsatisfied dependency expressed through method ‘springProcessEngineConfiguration’ parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘dataSource’ defined in class path resource [org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Hikari.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.zaxxer.hikari.HikariDataSource]: Factory method ‘dataSource’ threw exception; nested exception is java.lang.IllegalStateException: Cannot load driver class: oracle.jdbc.OracleDriver

```
12.03.2020 18:14:31 2020-03-12 15:14:31.347 INFO 1 --- [main] ConditionEvaluationReportLoggingListener :

12.03.2020 18:14:31

12.03.2020 18:14:31 Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.

12.03.2020 18:14:31 2020-03-12 15:14:31.351 ERROR 1 --- [main] o.s.b.SpringApplication : Application run failed

12.03.2020 18:14:31 org.springframework.context.ApplicationContextException: Unable to start web server; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'servletEndpointRegistrar' defined in class path resource [org/springframework/boot/actuate/autoconfigure/endpoint/web/ServletEndpointManagementContextConfiguration$WebMvcServletEndpointManagementContextConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.springframework.boot.actuate.endpoint.web.ServletEndpointRegistrar]: Factory method 'servletEndpointRegistrar' threw exception; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'processEngineEndpoint' defined in class path resource [org/flowable/spring/boot/EndpointAutoConfiguration.class]: Unsatisfied dependency expressed through method 'processEngineEndpoint' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'processEngine' defined in class path resource [org/flowable/spring/boot/ProcessEngineServicesAutoConfiguration$AlreadyInitializedAppEngineConfiguration.class]: Unsatisfied dependency expressed through method 'processEngine' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'org.flowable.spring.boot.app.AppEngineServicesAutoConfiguration': Unsatisfied dependency expressed through method 'setEngineConfigurers' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'processAppEngineConfigurationConfigurer' defined in class path resource [org/flowable/spring/boot/ProcessEngineAutoConfiguration$ProcessEngineAppConfiguration.class]: Unsatisfied dependency expressed through method 'processAppEngineConfigurationConfigurer' parameter 0; n ested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'processEngineConfigurator' defined in class path resource [org/flowable/spring/boot/ProcessEngineAutoConfiguration$ProcessEngineAppConfiguration.class]: Unsatisfied dependency expressed through method 'processEngineConfigurator' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'springProcessEngineConfiguration' defined in class path resource [org/flowable/spring/boot/ProcessEngineAutoConfiguration.class]: Unsatisfied dependency expressed through method 'springProcessEngineConfiguration' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Hikari.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.zaxxer.hikari.HikariDataSource]: Factory method 'dataSource' threw exception; nested exception is java.lang.IllegalStateException: Cannot load driver class: oracle.jdbc.OracleDriver
.........................................

```

1. if add two libs, application connect to db and create tables:  
FROM flowable/all-in-one  
ADD orai18n-19.3.0.0.jar /opt/tomcat/lib/  
ADD ojdbc10-19.3.0.0.jar /opt/tomcat/lib/

2. add to context.xml , didn’t help. I have no ideas.