topic Activiti Database configuration in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/activiti-database-configuration/m-p/98867#M68219 <HTML><HEAD></HEAD><BODY><SPAN>How does one dynamically specify schema name while using spring activiti configuration with jndi datasource?</SPAN><BR /><BR /><SPAN>I have the following configuration</SPAN><BR /><SPAN>&lt;bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="dataSource" ref="dataSource" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="transactionManager" ref="transactionManager" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="deploymentResources" value="classpath*:auto.*.bpmn20.xml" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="databaseSchemaUpdate" value="false" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="jobExecutorActivate" value="false" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="dbIdentityUsed" value="false" /&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="history" value="full" /&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; &lt;/bean&gt;</SPAN><BR /><BR /><SPAN>&lt;jee:jndi-lookup id="dataSource" jndi-name="jdbc/activitiDS" resource-ref="true"/&gt;</SPAN><BR /><BR /><SPAN>By default the sql statement generated is using the user id of the connection as schema name?</SPAN><BR /><SPAN>I would like to configure the schema name from a properties file.</SPAN><BR /><SPAN>How to do that?</SPAN></BODY></HTML> Wed, 18 Jul 2012 00:55:27 GMT pp84 2012-07-18T00:55:27Z Activiti Database configuration https://connect.hyland.com/t5/alfresco-archive/activiti-database-configuration/m-p/98867#M68219 How does one dynamically specify schema name while using spring activiti configuration with jndi datasource?I have the following configuration&lt;bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;property name="dataSource" ref="dataSource Wed, 18 Jul 2012 00:55:27 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-database-configuration/m-p/98867#M68219 pp84 2012-07-18T00:55:27Z Re: Activiti Database configuration https://connect.hyland.com/t5/alfresco-archive/activiti-database-configuration/m-p/98868#M68220 <HTML><HEAD></HEAD><BODY><SPAN>Isn't there a way of specifying the schema-name in the JDBC-url (not sure which DB you're using). The only place where the schema is explicitly set, is when checking if tables are present. Other queries just run unqualified against the connection…</SPAN><BR /><BR /><SPAN>The only place a schema is "assumed" is when checking if tables exist in oracle (upgrade/creating engine) due to </SPAN><A href="https://jira.codehaus.org/browse/ACT-1062" rel="nofollow noopener noreferrer">https://jira.codehaus.org/browse/ACT-1062</A><SPAN>, when NO schema is explicitly set. The schema can be set when manually performing the "create" or upgrades, see ManagementService:</SPAN><BR /><BR /><CODE><BR />&nbsp; public String databaseSchemaUpgrade(final Connection connection, final String catalog, final String schema) {<BR /></CODE></BODY></HTML> Wed, 18 Jul 2012 06:02:52 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-database-configuration/m-p/98868#M68220 frederikherema1 2012-07-18T06:02:52Z