AnsweredAssumed Answered

Connecting Explorer to an Oracle Schema

Question asked by powerspace on Oct 9, 2014
Latest reply on Oct 17, 2014 by jbarrez
Hello All,

I am having trouble connecting my Activiti explorer to a oracle child user/schema.

In oracle, you can create a parent schema and then create child schemas as follows:

PSchema
    |
    |
    —- PSchema_schema1
    —- PSchema_schema2
    —- PSchema_schema3

Where ParentSchema has all (read,write) privileges over PSchema_schema1, PSchema_schema2, PSchema_schema3

An example would be,

GlobalSchema
   |
   |
    —- GlobalSchema_Env1Schema
    —- GlobalSchema_Env2Schema


GlobalSchema_Env1Schema has its own set of Activiti tables & data. GlobalSchema_Env2Schema has its own set of Activiti tables and schema.


For my Activiti Engine configuration, in my current application, I simply connect with global schema username then execute "ALTER SESSION SET CURRENT_SCHEMA=GlobalSchema_Env1Schema" etc.

However, with Activiti-Explorer, the only option for me to connect to another db is by changing db.properties file. I changed my db.properties file as follows:

db=oracle
jdbc.driver=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@127.0.0.1:1523:qadb03
jdbc.username=GlobalSchema
jdbc.password=pwd


How do I connect to the child schema GlobalSchema_Env1Schema or GlobalSchema_Env2Schema ?


Is there anyway I can change schema or run something like "ALTER SESSION SET CURRENT_SCHEMA=GlobalSchema_Env1Schema".

Remember that each environment or child schema is suppose to have its own set of activiti tables.


Thanks in advance !

Outcomes