BPM Process Deployment error

Camunda 7 Topics Discussion & Questions
1

catalina.2019-01-06.log (319.7 KB)

Hi All,

I created a BPM process and created a build successfully.I copied my .war file in the tomcat server webapps folder but it does not get deployed but instead throws some errors.

like : Caused by: javax.naming.NamingException: Unexpected exception resolving reference [Root exception is org.h2.jdbc.JdbcSQLException: Database may be already in use: null. Possible solutions: close all other connection(s); use the server mode [90020-190]]

I have attached the catalina log file.Could you please review it and let me know how to fix it.

Thanks

2

Hi,

Do you try to get db connection in this application?
Maybe this will help:

3

I restarted my laptop and it fixed the issue.

4

When you use H2 database only one application can connect.

5

sorry,I am very new to Camunda environment.
How do i make sure that only 1 application is connected at a given time.Where and how do i verify that?

6

This is not camunda issue. Its your application got terminated and java process is still holds the lock on H2.

And other scenarios like, your camunda application is connected to H2, and you’re trying to access H2 database via SQL client tools, this error will come. If you want to access H2, you can access via H2 web console, by enabling these properties

spring.h2.console.enabled=true
spring.h2.console.settings.web-allow-others=true

Additionally using this, you can set a custom path to access the H2 web console:
spring.h2.console.path=/h2

now you can access it as http://localhost:8080/h2

And add this to your JDBC url:

DB_CLOSE_ON_EXIT=FALSE;

which should similar like below:

jdbc:h2:file:~/usr/target/db/camundadb;DB_CLOSE_ON_EXIT=FALSE;DB_CLOSE_DELAY=-1;

1 Like
7

Hi Aravindh,

Since you are an experienced person in this field.Could you please let me know the technology stack I need to learn to get a grasp of Camunda BPM?

Thanks

8

I hope you have read the camunda docs which was well documented. If not go through these docs,

https://docs.camunda.org/manual/7.10/reference/bpmn20/

https://docs.camunda.org/manual/7.10/user-guide/

https://docs.camunda.org/manual/7.10/installation/

https://docs.camunda.org/manual/7.10/introduction/supported-environments/

https://docs.camunda.org/manual/7.10/introduction/architecture/

https://docs.camunda.org/get-started/quick-start/

https://docs.camunda.org/get-started/spring/

https://docs.camunda.org/get-started/spring-boot/

https://docs.camunda.org/manual/7.10/reference/rest/

9

Camunda is not technology agnostic. You have flexibility to use with Javascript, Java or whatever language or platform it is, just make a Rest api call and get the job done. You need to focus on various bpmn notations, task types, gateways and best practices.

10

Dear @aravindhrs,

As per your suggestion, I have updated the Application.yml config file with below details, but still I am getting the H2 Console - Sorry, remote connections (‘webAllowOthers’) are disabled on this server error. kindly let me know if I missed any steps.

spring.datasource:
url: jdbc:h2:./camunda-h2-dbs/process-engine;TRACE_LEVEL_FILE=0;DB_CLOSE_ON_EXIT=FALSE
driver-class-name: org.h2.Driver
username: sa
password: sa

spring.h2.console.enabled=true
spring.h2.console.settings.web-allow-others=true
spring.h2.console.path=/h2

Thanks & Regards,
Prakash R.