topic Access to dbconnection to execute arbritrary query in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/access-to-dbconnection-to-execute-arbritrary-query/m-p/123665#M87064 <HTML><HEAD></HEAD><BODY><SPAN>Is there a way to either access the internal db connection object in a script task or Java task, so that I can run an arbitrary query?&nbsp; I am embedding Activiti using plain java</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ProcessEngineConfiguration processEngineConfiguration = ProcessEngineConfiguration</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.createStandaloneProcessEngineConfiguration()</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.setJdbcUrl((String) params.get("url"))</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.setJdbcDriver((String) params.get("driver"))</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.setJdbcUsername((String) params.get("user"))</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.setJdbcPassword((String) params.get("pword"))</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.setMailServerHost((String) params.get("emailhost"))</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.setMailServerPort(Integer.parseInt((String) params.get("emailport")))</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.setMailServerUsername((String) params.get("emailuser"))</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.setMailServerPassword((String) params.get("emailpass"))</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.setMailServerDefaultFrom((String) params.get("emaildefaultfrom"))</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.setJobExecutorActivate(true)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.setProcessEngineName((String) params.get("dbname"));</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// add our customform types to the engine</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;List&lt;AbstractFormType&gt; customFormTypes = new ArrayList&lt;AbstractFormType&gt;();</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;customFormTypes.add(new FileFormType());</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;customFormTypes.add(new TextAreaFormType());</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;customFormTypes.add(new RadioFormType(null));</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;((ProcessEngineConfigurationImpl) processEngineConfiguration).setCustomFormTypes(customFormTypes);</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ProcessEngine processEngine = processEngineConfiguration.buildProcessEngine();</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//now we can add our custom handlers for user/groups</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Map&lt;Class&lt; ? &gt;, SessionFactory&gt; sessionFactories =</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;((ProcessEngineConfigurationImpl) processEngineConfiguration).getSessionFactories();</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sessionFactories.put(UserEntityManager.class, new CustomUserEntityManagerFactory());&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sessionFactories.put(GroupEntityManager.class, new CustomGroupEntityManagerFactory());</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ProcessEngines.registerProcessEngine(processEngine);</SPAN><BR /><BR /><BR /><SPAN>everything is working fine so far, but I need to run some queries in a script or java task and I would prefer to do this with out making new database connections.&nbsp; Script task would be preferred as I would not need to have java class files during deployment.</SPAN><BR /><BR /><SPAN>Thanks</SPAN></BODY></HTML> Wed, 08 May 2013 15:46:40 GMT tcheekva 2013-05-08T15:46:40Z Access to dbconnection to execute arbritrary query https://connect.hyland.com/t5/alfresco-archive/access-to-dbconnection-to-execute-arbritrary-query/m-p/123665#M87064 Is there a way to either access the internal db connection object in a script task or Java task, so that I can run an arbitrary query?&nbsp; I am embedding Activiti using plain java&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ProcessEngineConfiguration processEngineConfiguration = ProcessEngineConfiguration&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.createStandaloneP Wed, 08 May 2013 15:46:40 GMT https://connect.hyland.com/t5/alfresco-archive/access-to-dbconnection-to-execute-arbritrary-query/m-p/123665#M87064 tcheekva 2013-05-08T15:46:40Z Re: Access to dbconnection to execute arbritrary query https://connect.hyland.com/t5/alfresco-archive/access-to-dbconnection-to-execute-arbritrary-query/m-p/123666#M87065 <HTML><HEAD></HEAD><BODY><SPAN>You can try using the Context.getCommandContext() to obtain a org.activiti.engine.impl.interceptor.CommandContext. This allows you to get hold of the DBSqlSession and getSQLSession() on this. The SQLSession exposes a getConnection() method which returns the current session used in the process that is executing the script/service task.</SPAN></BODY></HTML> Mon, 13 May 2013 07:51:37 GMT https://connect.hyland.com/t5/alfresco-archive/access-to-dbconnection-to-execute-arbritrary-query/m-p/123666#M87065 frederikherema1 2013-05-13T07:51:37Z Re: Access to dbconnection to execute arbritrary query https://connect.hyland.com/t5/alfresco-archive/access-to-dbconnection-to-execute-arbritrary-query/m-p/123667#M87066 <HTML><HEAD></HEAD><BODY><SPAN>This is working fine in a task, thanks.&nbsp; I also need access from within a new form type (AbstractFormType).&nbsp; creating a dynamic selection from a database table.&nbsp; The Context above is returning null.&nbsp; Is there a way to do this from a FormType? I was also trying thru a processEngine but how do I know which engine I am running in?</SPAN></BODY></HTML> Mon, 20 May 2013 18:15:32 GMT https://connect.hyland.com/t5/alfresco-archive/access-to-dbconnection-to-execute-arbritrary-query/m-p/123667#M87066 tcheekva 2013-05-20T18:15:32Z Re: Access to dbconnection to execute arbritrary query https://connect.hyland.com/t5/alfresco-archive/access-to-dbconnection-to-execute-arbritrary-query/m-p/123668#M87067 <HTML><HEAD></HEAD><BODY><SPAN>When getting form-properties, there is no process context active YET. You'll have to make you're type smart enough (e.g.. wire reference to processEngine in Spring) to know what engine to use to get hold of a SQLConnection.</SPAN></BODY></HTML> Wed, 22 May 2013 05:25:47 GMT https://connect.hyland.com/t5/alfresco-archive/access-to-dbconnection-to-execute-arbritrary-query/m-p/123668#M87067 frederikherema1 2013-05-22T05:25:47Z Re: Access to dbconnection to execute arbritrary query https://connect.hyland.com/t5/alfresco-archive/access-to-dbconnection-to-execute-arbritrary-query/m-p/123669#M87068 <HTML><HEAD></HEAD><BODY><SPAN>When getting form-properties, there is no process context active YET. You'll have to make you're type smart enough (e.g.. wire reference to processEngine in Spring) to know what engine to use to get hold of a SQLConnection.</SPAN></BODY></HTML> Wed, 22 May 2013 05:25:47 GMT https://connect.hyland.com/t5/alfresco-archive/access-to-dbconnection-to-execute-arbritrary-query/m-p/123669#M87068 frederikherema1 2013-05-22T05:25:47Z