error while connecting to oracle

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

Hi,
I am using Camunda BPM version camunda-bpm-tomcat-7.1.0-alpha1 and this BPM connecting to Oracle instead of H2. I am getting below exception while performing login functionality for Camunda cockpit, tasklist.
I have given below code in server.xml for connecting to oracle
<Resource name="jdbc/ProcessEngine"
auth="Container"
type="javax.sql.DataSource"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
uniqueResourceName="process-engine"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@localhost:1521:xe"
username="suresh"
password="suresh"
maxPoolSize="20"
minPoolSize="5" />

### 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

regards,
suresh

[Christian Lipphardt]

Hi,

please provide following details:

Operation system
Java version
Oracle jdbc driver version
Oracle DB version

Cheers
Christian

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

Hi,

Operation system:Windows 7 Professional
Java version:jdk 1.6
Oracle jdbc driver version:oracle.jdbc.driver.OracleDriver ,jar file:ojdbc6.jar
Oracle DB version :Oracle Database 11g Express Edition Release 11.2.0.2.0 -Production

regards,
suresh

[Christian Lipphardt]

Hi,

please check if the engine created the required tables at startup?

Cheers

Christian

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

Hi,
I executed create scripts in oracle database that are provided camunda software.
before connecting to oracle database from camunda enigne. Please let me know what are the tables created automatically when server started.

regards,
suresh
On Friday, 17 January 2014 06:44:10 UTC+1, suresh.t...@gmail.com wrote:

[Christian Lipphardt]

Hi Suresh,

following tables should exist and be accessible by your database user:

ACT_GE_PROPERTY

ACT_GE_BYTEARRAY

ACT_RE_DEPLOYMENT

ACT_RU_EXECUTION

ACT_RU_JOB

ACT_RU_JOBDEF

ACT_RE_PROCDEF

ACT_RU_TASK

ACT_RU_IDENTITYLINK

ACT_RU_VARIABLE

ACT_RU_EVENT_SUBSCR

ACT_RU_INCIDENT

ACT_RU_AUTHORIZATION

ACT_HI_PROCINST

ACT_HI_ACTINST

ACT_HI_TASKINST

ACT_HI_VARINST

ACT_HI_DETAIL

ACT_HI_COMMENT

ACT_HI_ATTACHMENT

ACT_ID_GROUP

ACT_ID_MEMBERSHIP

ACT_ID_USER

ACT_ID_INFO

Cheers

Christian

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

Hi,
I verfied below table list in my oracle database and all tables are exits and accessable with database user.
Still problem is exists.

regards,
suresh
On Friday, 17 January 2014 06:44:10 UTC+1, suresh.t...@gmail.com wrote:

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

Hi,
Still my problem is not solved. Please let me know any body Camunda BPM connecting to oracle database.
If yes,Please let me know how you solved below Issue.

regards,
suresh
On Friday, 17 January 2014 06:44:10 UTC+1, suresh.t...@gmail.com wrote: