develop custom BP Engine with Camunda and Oracle database,accessing with Rest API

[suresh.t...@gmail.com]

Hi,
By default Camunda BPM connecting H2 database. Instead of H2 i want to configure Camunda BPM should connects to oracle database instead of H2. For this requirement i decided to use spring integration as we can give database credentials in application-context.xml in Camunda BPM project.

If i develop my BP Engine with spring integration and oracle database. Can we use Rest API of engine-rest application for performing bpm operations or this engine-rest Application rest API supports only for servlet based web application with H2 database.

regards,
suresh

[Daniel Meyer]

 Hi Suresh,

maybe this quickstart helps you: https://github.com/camunda/camunda-quickstarts/tree/master/deployment/embedded-spring-rest

It demonstrates how to configure an application where the process engine is configured through Spring and the REST Api is embedded.

Cheers,

Daniel Meyer

[suresh.t...@gmail.com]

Hi Daniel,
Thank you for providing information and now i am able to connect oracle but i am below exception when login with any user.

Please provide me solution for this.

### Error querying database. Cause: java.sql.SQLSyntaxErrorException: ORA-01775: looping chain of synonyms

### The error may exist in org/camunda/bpm/engine/impl/mapping/entity/Authorization.xml
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT CASE WHEN EXISTS (SELECT ID_ from ACT_RU_AUTHORIZATION A WHERE A.TYPE_ = 1 AND A.USER_ID_ = ? AND BITAND(A.PERMS_,?)=? AND A.RESOURCE_TYPE_ = ? AND A.RESOURCE_ID_ = ? ) THEN 1 WHEN EXISTS (SELECT ID_ from ACT_RU_AUTHORIZATION A WHERE A.TYPE_ = 1 AND A.USER_ID_ = ? AND BITAND(A.PERMS_,?)=? AND A.RESOURCE_TYPE_ = ? AND A.RESOURCE_ID_ = '*') THEN 1 WHEN EXISTS (SELECT ID_ from ACT_RU_AUTHORIZATION A WHERE A.TYPE_ = 2 AND A.USER_ID_ = ? AND BITAND(A.PERMS_,?)!=? AND A.RESOURCE_TYPE_ = ? AND A.RESOURCE_ID_ = ? ) THEN 0 WHEN EXISTS (SELECT ID_ from ACT_RU_AUTHORIZATION A WHERE A.TYPE_ = 2 AND A.USER_ID_ = ? AND BITAND(A.PERMS_,?)!=? AND A.RESOURCE_TYPE_ = ? AND A.RESOURCE_ID_ = '*') THEN 0 ELSE ( SELECT CASE WHEN EXISTS (SELECT ID_ from ACT_RU_AUTHORIZATION A WHERE A.TYPE_ = 2 AND A.GROUP_ID_ = ? AND BITAND(A.PERMS_,?)!=? AND A.RESOURCE_TYPE_ = ? AND A.RESOURCE_ID_ = ? ) THEN 0 WHEN EXISTS (SELECT ID_ from ACT_RU_AUTHORIZATION A WHERE A.TYPE_ = 2 AND A.GROUP_ID_ = ? AND BITAND(A.PERMS_,?)!=? AND A.RESOURCE_TYPE_ = ? AND A.RESOURCE_ID_ = '*') THEN 0 WHEN EXISTS (SELECT ID_ from ACT_RU_AUTHORIZATION A WHERE A.TYPE_ = 1 AND A.GROUP_ID_ = ? AND BITAND(A.PERMS_,?)=? AND A.RESOURCE_TYPE_ = ? AND A.RESOURCE_ID_ = ? ) THEN 1 WHEN EXISTS (SELECT ID_ from ACT_RU_AUTHORIZATION A WHERE A.TYPE_ = 1 AND A.GROUP_ID_ = ? AND BITAND(A.PERMS_,?)=? AND A.RESOURCE_TYPE_ = ? AND A.RESOURCE_ID_ = '*') THEN 1 ELSE ( SELECT CASE WHEN EXISTS (SELECT ID_ from ACT_RU_AUTHORIZATION A WHERE A.TYPE_ = 0 AND A.USER_ID_ = '*' AND BITAND(A.PERMS_,?)=? AND A.RESOURCE_TYPE_ = ? AND A.RESOURCE_ID_ = ? ) THEN 1 WHEN EXISTS (SELECT ID_ from ACT_RU_AUTHORIZATION A WHERE A.TYPE_ = 0 AND A.USER_ID_ = '*' AND BITAND(A.PERMS_,?)=? AND A.RESOURCE_TYPE_ = ? AND A.RESOURCE_ID_ = '*') THEN 1 WHEN EXISTS (SELECT ID_ from ACT_RU_AUTHORIZATION A WHERE A.TYPE_ = 0 AND A.USER_ID_ = '*' AND BITAND(A.PERMS_,?)!=? AND A.RESOURCE_TYPE_ = ? AND A.RESOURCE_ID_ = ? ) THEN 0 WHEN EXISTS (SELECT ID_ from ACT_RU_AUTHORIZATION A WHERE A.TYPE_ = 0 AND A.USER_ID_ = '*' AND BITAND(A.PERMS_,?)!=? AND A.RESOURCE_TYPE_ = ? AND A.RESOURCE_ID_ = '*') THEN 0 ELSE 0 END FROM DUAL ) END FROM DUAL ) END FROM DUAL
### Cause: java.sql.SQLSyntaxErrorException: ORA-01775: looping chain of synonyms

at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95)
at org.camunda.bpm.engine.impl.db.DbSqlSession.selectBoolean(DbSqlSession.java:345)
at org.camunda.bpm.engine.impl.persistence.entity.AuthorizationManager.isAuthorized(AuthorizationManager.java:117)
at org.camunda.bpm.engine.impl.cmd.AuthorizationCheckCmd.execute(AuthorizationCheckCmd.java:47)
at org.camunda.bpm.engine.impl.cmd.AuthorizationCheckCmd.execute(AuthorizationCheckCmd.java:29)
at org.camunda.bpm.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)
at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)
... 48 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-01775: looping chain of synonyms

[Daniel Meyer]

Hi Suresh,

which version of oracle database are you using?

Daniel

[suresh.t...@gmail.com]

Hi Daniel,
I am using below version of oracle:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
PL/SQL Release 11.2.0.2.0 - Production
"CORE 11.2.0.2.0 Production"
TNS for 32-bit Windows: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production

regards,
suresh

On Tuesday, 31 December 2013 06:23:21 UTC+1, suresh.t...@gmail.com wrote:

[Daniel Meyer]

Hi Suresh,

we fixed a bug in the authorization check on oracle in camunda BPM
7.1.0-alpha1. Could you please try with that version?

Regards,
Daniel Meyer

[suresh.t...@gmail.com]

Hi Daniel,
Present i am using 7.1.0-alpha1 version and this issue came in that version only.

regards,
suresh
On Tuesday, 31 December 2013 06:23:21 UTC+1, suresh.t...@gmail.com wrote:

[suresh.t...@gmail.com]

Hi Daniel,
Below Issue still existing in camunda BPM
7.1.0-alpha1. Could you please provide solution for this.

regards,
suresh
On Tuesday, 31 December 2013 06:23:21 UTC+1, suresh.t...@gmail.com wrote: