Connecting Explorer to an Oracle Schema

[powerspace]

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=jdbcracle: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 !

[jbarrez]

No, we don't have support for child/parent schema's (this is the first time in my career I've heard of them too … so not sure how many people use them)