topic Connecting Explorer to an Oracle Schema in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/connecting-explorer-to-an-oracle-schema/m-p/188297#M141427 <HTML><HEAD></HEAD><BODY><SPAN>Hello All,</SPAN><BR /><BR /><SPAN>I am having trouble connecting my Activiti explorer to a oracle child user/schema.</SPAN><BR /><BR /><SPAN>In oracle, you can create a parent schema and then create child schemas as follows:</SPAN><BR /><BR /><SPAN>PSchema</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; |</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; | </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; —- PSchema_schema1</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; —- PSchema_schema2</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; —- PSchema_schema3</SPAN><BR /><BR /><SPAN>Where ParentSchema has all (read,write) privileges over PSchema_schema1, PSchema_schema2, PSchema_schema3</SPAN><BR /><BR /><SPAN>An example would be,</SPAN><BR /><BR /><SPAN>GlobalSchema</SPAN><BR /><SPAN>&nbsp;&nbsp; |</SPAN><BR /><SPAN>&nbsp;&nbsp; |</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; —- GlobalSchema_Env1Schema</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; —- GlobalSchema_Env2Schema</SPAN><BR /><BR /><BR /><SPAN>GlobalSchema_Env1Schema has its own set of Activiti tables &amp; data. GlobalSchema_Env2Schema has its own set of Activiti tables and schema. </SPAN><BR /><BR /><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>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:</SPAN><BR /><BR /><SPAN>db=oracle</SPAN><BR /><SPAN>jdbc.driver=oracle.jdbc.driver.OracleDriver</SPAN><BR /><SPAN>jdbc.url=jdbc<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />racle:thin:@127.0.0.1:1523:qadb03</SPAN><BR /><SPAN>jdbc.username=GlobalSchema</SPAN><BR /><SPAN>jdbc.password=pwd</SPAN><BR /><BR /><BR /><SPAN>How do I connect to the child schema GlobalSchema_Env1Schema or GlobalSchema_Env2Schema ?</SPAN><BR /><BR /><BR /><SPAN>Is there anyway I can change schema or run something like "ALTER SESSION SET CURRENT_SCHEMA=GlobalSchema_Env1Schema".</SPAN><BR /><BR /><SPAN>Remember that each environment or child schema is suppose to have its own set of activiti tables. </SPAN><BR /><BR /><BR /><SPAN>Thanks in advance !</SPAN></BODY></HTML> Wed, 08 Oct 2014 23:57:06 GMT powerspace 2014-10-08T23:57:06Z Connecting Explorer to an Oracle Schema https://connect.hyland.com/t5/alfresco-archive/connecting-explorer-to-an-oracle-schema/m-p/188297#M141427 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<IMG id="smileytongue" class="emoticon emoticon-smileytongue" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />Schema&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; | &nbsp;&nbsp;&nbsp; —- PSchema_schema1&nbsp;&nbsp;&nbsp; —- PSchema_schema2&nbsp;&nbsp;&nbsp; —- PSchema_schema3Where ParentSchema has all (read,write) p Wed, 08 Oct 2014 23:57:06 GMT https://connect.hyland.com/t5/alfresco-archive/connecting-explorer-to-an-oracle-schema/m-p/188297#M141427 powerspace 2014-10-08T23:57:06Z Re: Connecting Explorer to an Oracle Schema https://connect.hyland.com/t5/alfresco-archive/connecting-explorer-to-an-oracle-schema/m-p/188298#M141428 <HTML><HEAD></HEAD><BODY><SPAN>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)</SPAN></BODY></HTML> Fri, 17 Oct 2014 10:26:01 GMT https://connect.hyland.com/t5/alfresco-archive/connecting-explorer-to-an-oracle-schema/m-p/188298#M141428 jbarrez 2014-10-17T10:26:01Z