kandi background
kandi background
Explore Kits
kandi background
Explore Kits
This is related to BPM

Popular New Releases in BPM

airflow

Apache Airflow 2.2.5

argo-workflows

v3.3.2

prefect

Release 1.2.0

Activiti

incubator-dolphinscheduler

1.3.5 Release Notes

airflow

Apache Airflow 2.2.5

argo-workflows

v3.3.2

prefect

Release 1.2.0

Activiti

incubator-dolphinscheduler

1.3.5 Release Notes

Popular Libraries in BPM

airflow

by apache python

star image 25547 Apache-2.0

Apache Airflow - A platform to programmatically author, schedule, and monitor workflows

n8n

by n8n-io typescript

star image 22046 NOASSERTION

Free and open fair-code licensed node based Workflow Automation Tool. Easily automate tasks across different services.

kuboard-press

by eip-work javascript

star image 11211

Kuboard 是基于 Kubernetes 的微服务管理界面。同时提供 Kubernetes 免费中文教程,入门教程,最新版本的 Kubernetes v1.20 安装手册,(k8s install) 在线答疑,持续更新。

argo-workflows

by argoproj go

star image 10889 Apache-2.0

Workflow engine for Kubernetes

platform_frameworks_base

by aosp-mirror java

star image 9696 NOASSERTION

prefect

by PrefectHQ python

star image 8737 Apache-2.0

The easiest way to automate your data

Activiti

by Activiti java

star image 8513 Apache-2.0

Activiti is a light-weight workflow and Business Process Management (BPM) Platform targeted at business people, developers and system admins. Its core is a super-fast and rock-solid BPMN 2 process engine for Java. It's open-source and distributed under the Apache license. Activiti runs in any Java application, on a server, on a cluster or in the cloud. It integrates perfectly with Spring, it is extremely lightweight and based on simple concepts.

bpmn-js

by bpmn-io javascript

star image 6017 NOASSERTION

A BPMN 2.0 rendering toolkit and web modeler.

starter-workflows

by actions typescript

star image 5900 NOASSERTION

Accelerating new GitHub Actions workflows

airflow

by apache python

star image 25547 Apache-2.0

Apache Airflow - A platform to programmatically author, schedule, and monitor workflows

n8n

by n8n-io typescript

star image 22046 NOASSERTION

Free and open fair-code licensed node based Workflow Automation Tool. Easily automate tasks across different services.

kuboard-press

by eip-work javascript

star image 11211

Kuboard 是基于 Kubernetes 的微服务管理界面。同时提供 Kubernetes 免费中文教程,入门教程,最新版本的 Kubernetes v1.20 安装手册,(k8s install) 在线答疑,持续更新。

argo-workflows

by argoproj go

star image 10889 Apache-2.0

Workflow engine for Kubernetes

platform_frameworks_base

by aosp-mirror java

star image 9696 NOASSERTION

prefect

by PrefectHQ python

star image 8737 Apache-2.0

The easiest way to automate your data

Activiti

by Activiti java

star image 8513 Apache-2.0

Activiti is a light-weight workflow and Business Process Management (BPM) Platform targeted at business people, developers and system admins. Its core is a super-fast and rock-solid BPMN 2 process engine for Java. It's open-source and distributed under the Apache license. Activiti runs in any Java application, on a server, on a cluster or in the cloud. It integrates perfectly with Spring, it is extremely lightweight and based on simple concepts.

bpmn-js

by bpmn-io javascript

star image 6017 NOASSERTION

A BPMN 2.0 rendering toolkit and web modeler.

starter-workflows

by actions typescript

star image 5900 NOASSERTION

Accelerating new GitHub Actions workflows

Trending New libraries in BPM

orchest

by orchest python

star image 2877 AGPL-3.0

Build data pipelines, the easy way 🛠️

pipedream

by PipedreamHQ javascript

star image 2869 MIT

Connect APIs, remarkably fast. Free for developers.

actionsflow

by actionsflow typescript

star image 2338 MIT

The free Zapier/IFTTT alternative for developers to automate your workflows based on Github actions

ploomber

by ploomber python

star image 2301 Apache-2.0

The fastest ⚡️ way to build data pipelines. Develop iteratively, deploy anywhere. ☁️

fastmac

by fastai shell

star image 2006 Apache-2.0

Get a MacOS or Linux shell, for free, in around 2 minutes

git-branchless

by arxanas rust

star image 1661 GPL-2.0

High-velocity, monorepo-scale workflow for Git

tasuku

by privatenumber typescript

star image 1481 MIT

✅ タスク — The minimal task runner for Node.js

compileflow

by alibaba java

star image 869 Apache-2.0

🎨 core business process engine of Alibaba Halo platform, best process engine for trade scenes. | 一个高性能流程编排引擎

actionlint

by rhysd go

star image 721 MIT

:octocat: Static checker for GitHub Actions workflow files

orchest

by orchest python

star image 2877 AGPL-3.0

Build data pipelines, the easy way 🛠️

pipedream

by PipedreamHQ javascript

star image 2869 MIT

Connect APIs, remarkably fast. Free for developers.

actionsflow

by actionsflow typescript

star image 2338 MIT

The free Zapier/IFTTT alternative for developers to automate your workflows based on Github actions

ploomber

by ploomber python

star image 2301 Apache-2.0

The fastest ⚡️ way to build data pipelines. Develop iteratively, deploy anywhere. ☁️

fastmac

by fastai shell

star image 2006 Apache-2.0

Get a MacOS or Linux shell, for free, in around 2 minutes

git-branchless

by arxanas rust

star image 1661 GPL-2.0

High-velocity, monorepo-scale workflow for Git

tasuku

by privatenumber typescript

star image 1481 MIT

✅ タスク — The minimal task runner for Node.js

compileflow

by alibaba java

star image 869 Apache-2.0

🎨 core business process engine of Alibaba Halo platform, best process engine for trade scenes. | 一个高性能流程编排引擎

actionlint

by rhysd go

star image 721 MIT

:octocat: Static checker for GitHub Actions workflow files

Top Authors in BPM

1

camunda

45 Libraries

6269

2

deanishe

38 Libraries

7042

3

bpmn-io

33 Libraries

8661

4

camunda-community-hub

24 Libraries

571

5

PacktPublishing

21 Libraries

242

6

jenkinsci

14 Libraries

1074

7

holunda-io

13 Libraries

154

8

common-workflow-language

12 Libraries

1681

9

StephenOTT

12 Libraries

125

10

temporalio

11 Libraries

4816

1

45 Libraries

6269

2

38 Libraries

7042

3

33 Libraries

8661

4

24 Libraries

571

5

21 Libraries

242

6

14 Libraries

1074

7

13 Libraries

154

8

12 Libraries

1681

9

12 Libraries

125

10

11 Libraries

4816

Trending Kits in BPM

No Trending Kits are available at this moment for BPM

Trending Discussions on BPM

    Camunda embedded with H2: Cockpit Login fails
    Plot line from dataframe
    Camunda Application not starting up on docker container
    Renaming some part of columns of dataframe with values from another dataframe
    How to separate Camunda tables to a different schema?
    How to convert json MySQL data into rows and column
    Using pyaudio to build a Metronome; wrong timing
    Why am I getting "Error processing transaction request: intrinsic gas too low" error when trying to add tUSDT to a particular account?
    getting a KeyNotFoundException on a key that appears to exist in a dictionary
    Webaudio timing performance

QUESTION

Camunda embedded with H2: Cockpit Login fails

Asked 2022-Mar-09 at 08:50

I'm currently wokring on a product with the following conditions:

  • Spring-Boot (2.6) with Camunda embedded (7.16)
  • Connection to Camunda configured to use H2 (2.1.210) embedded with the following is configured in application.yml:
1app:
2  datasource-camunda:
3    jdbcUrl: jdbc:h2:./h2/test;MODE=LEGACY
4camunda:
5  bpm:
6    database:
7      schema-update: true
8    auto-deployment-enabled: true
9

and as Java-Configuration:

1app:
2  datasource-camunda:
3    jdbcUrl: jdbc:h2:./h2/test;MODE=LEGACY
4camunda:
5  bpm:
6    database:
7      schema-update: true
8    auto-deployment-enabled: true
9@Bean("camundaBpmDataSource")
10@ConfigurationProperties
11public DataSource camundaDataSource() {
12  return DataSourceBuilder.create().build();
13}
14
15@Bean
16public PlatformTransactionManager camundaBpmTransactionManager(DataSource datasource) {
17  return new DataSourceTransactionManager(datasource)
18}
19

The camunda engine is not configured explicitly since I used the appropriate starter and let Spring auto configured it. As a result the resulting setup should look very similar to the embedded camunda h2 configuration showed here: https://docs.camunda.org/get-started/spring/embedded-process-engine/

The application runs good with this setup. No problems with the application at all, but I faced an issue while logging in to the camunda cockpit. Login succeeds but then I see an error in the login mask saying:

Login Failed

An exception occured in the persistence layer. Please check the server logs for a detailed message and the entire exception stack trace

1app:
2  datasource-camunda:
3    jdbcUrl: jdbc:h2:./h2/test;MODE=LEGACY
4camunda:
5  bpm:
6    database:
7      schema-update: true
8    auto-deployment-enabled: true
9@Bean("camundaBpmDataSource")
10@ConfigurationProperties
11public DataSource camundaDataSource() {
12  return DataSourceBuilder.create().build();
13}
14
15@Bean
16public PlatformTransactionManager camundaBpmTransactionManager(DataSource datasource) {
17  return new DataSourceTransactionManager(datasource)
18}
19
20
21Caused by: org.h2.jdbc.JdbcSQLNonTransientException: Unbekannter Datentyp: "?2"
22
23Unknown data type: "?2"; SQL statement:
24
25SELECT
26
27    CASE
28
29 
30
31     
32
33       
34
35        WHEN
36
37          
38
39           
40
41          EXISTS
42
43          
44
45            (SELECT
46
47                    A.RESOURCE_ID_
48
49             FROM
50
51                    ACT_RU_AUTHORIZATION A
52
53             WHERE
54
55                    A.TYPE_ = 1
56
57             AND
58
59                    A.USER_ID_ = ?
60
61             AND
62
63                    BITAND(A.PERMS_,?) = ?
64
65             AND
66
67                    A.RESOURCE_TYPE_ = ?
68
69             AND
70
71                    A.RESOURCE_ID_ =  ? )
72
73        THEN 1
74
75      
76
77 
78
79     
80
81       
82
83 
84
85     
86
87      WHEN
88
89        EXISTS
90
91          (SELECT
92
93                  ID_
94
95           FROM
96
97                  ACT_RU_AUTHORIZATION A
98
99           WHERE
100
101                  A.TYPE_ = 1
102
103           AND
104
105                  A.USER_ID_ = ?
106
107           AND
108
109                  BITAND(A.PERMS_,?) = ?
110
111           AND
112
113                  A.RESOURCE_TYPE_ = ?
114
115           AND
116
117                  A.RESOURCE_ID_ = '*')
118
119        THEN 1
120
121 
122
123     
124
125       
126
127 
128
129      ELSE
130
131          (
132
133          SELECT
134
135            CASE
136
137              
138
139 
140
141               
142
143                 
144
145                  WHEN
146
147                    
148
149                     
150
151                    EXISTS
152
153                    
154
155                      (SELECT
156
157                              A.RESOURCE_ID_
158
159                       FROM
160
161                              ACT_RU_AUTHORIZATION A
162
163                       WHERE
164
165                              A.TYPE_ = 1
166
167                       AND
168
169                              A.GROUP_ID_ IN  (  ? )
170
171                       AND
172
173                              BITAND(A.PERMS_,?) = ?
174
175                       AND
176
177                              A.RESOURCE_TYPE_ = ?
178
179                       AND
180
181                              A.RESOURCE_ID_ =  ? )
182
183                  THEN 1
184
185                
186
187 
188
189               
190
191                 
192
193 
194
195               
196
197                WHEN
198
199                  EXISTS
200
201                    (SELECT
202
203                            ID_
204
205                     FROM
206
207                            ACT_RU_AUTHORIZATION A
208
209                     WHERE
210
211                            A.TYPE_ = 1
212
213                     AND
214
215                            A.GROUP_ID_ IN  (  ? )
216
217                     AND
218
219                            BITAND(A.PERMS_,?) = ?
220
221                     AND
222
223                            A.RESOURCE_TYPE_ = ?
224
225                     AND
226
227                            A.RESOURCE_ID_ = '*')
228
229                  THEN 1
230
231 
232
233               
234
235                 
236
237 
238
239                ELSE (
240
241                      SELECT
242
243                        CASE
244
245              
246
247                          
248
249                           
250
251                            WHEN
252
253                              
254
255                               
256
257                              EXISTS
258
259                              
260
261                                (SELECT
262
263                                        A.RESOURCE_ID_
264
265                                 FROM
266
267                                        ACT_RU_AUTHORIZATION A
268
269                                 WHERE
270
271                                        A.TYPE_ = 0
272
273                                 AND
274
275                                        A.USER_ID_ = '*'
276
277                                 AND
278
279                                        BITAND(A.PERMS_,?) = ?
280
281                                 AND
282
283                                        A.RESOURCE_TYPE_ = ?
284
285                                 AND
286
287                                        A.RESOURCE_ID_ =  ? )
288
289                            THEN 1
290
291                          
292
293 
294
295                         
296
297                           
298
299 
300
301                         
302
303                          WHEN
304
305                            EXISTS
306
307                              (SELECT
308
309                                      ID_
310
311                               FROM
312
313                                      ACT_RU_AUTHORIZATION A
314
315                               WHERE
316
317                                      A.TYPE_ = 0
318
319                               AND
320
321                                      A.USER_ID_ = '*'
322
323                               AND
324
325                                      BITAND(A.PERMS_,?) = ?
326
327                               AND
328
329                                      A.RESOURCE_TYPE_ = ?
330
331                               AND
332
333                                      A.RESOURCE_ID_ = '*')
334
335                            THEN 1
336
337 
338
339                          
340
341                           
342
343 
344
345                         
346
347                          ELSE
348
349                          
350
351                           
352
353                            null
354
355                          
356
357 
358
359              
360
361                        END
362
363                )
364
365              
366
367            END
368
369      )
370
371    END [50004-210]
372
373            at org.h2.message.DbException.getJdbcSQLException(DbException.java:573) ~[h2-2.1.210.jar:2.1.210]
374
375            at org.h2.message.DbException.getJdbcSQLException(DbException.java:496) ~[h2-2.1.210.jar:2.1.210]
376
377            at org.h2.message.DbException.get(DbException.java:227) ~[h2-2.1.210.jar:2.1.210]
378

I already took a look into the database and saw all tables where created sucesfully, so does anybody faced a similar issue?

ANSWER

Answered 2022-Mar-09 at 08:50

Remove the "MODE=LEGACY" from the url. Here is a working example:

https://github.com/rob2universe/vanilla-camunda-template/blob/4625376bf3a5eed9cd1f2853cdf07fe5eca46685/src/main/resources/application.yaml#L17

Also ensure you use a supported H2 version. That is 1.4.x fro 7.16.x: https://docs.camunda.org/manual/7.16/introduction/supported-environments/

The BOM will inclcude H2 1.4.200.

Source https://stackoverflow.com/questions/71391717