topic Re: Access to dbconnection to execute arbritrary query in Alfresco Archive

Access to dbconnection to execute arbritrary query

tcheekva — Wed, 08 May 2013 15:46:40 GMT

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? I am embedding Activiti using plain java ProcessEngineConfiguration processEngineConfiguration = ProcessEngineConfiguration .createStandaloneP

Re: Access to dbconnection to execute arbritrary query

frederikherema1 — Mon, 13 May 2013 07:51:37 GMT

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.

Re: Access to dbconnection to execute arbritrary query

tcheekva — Mon, 20 May 2013 18:15:32 GMT

This is working fine in a task, thanks. I also need access from within a new form type (AbstractFormType). creating a dynamic selection from a database table. The Context above is returning null. 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?

Re: Access to dbconnection to execute arbritrary query

frederikherema1 — Wed, 22 May 2013 05:25:47 GMT

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.

Re: Access to dbconnection to execute arbritrary query

frederikherema1 — Wed, 22 May 2013 05:25:47 GMT