topic IllegalArgumentException: Mapped Statements collection does not contain value for selectExclusiveJobsToExecute_oracle in Alfresco Archive

IllegalArgumentException: Mapped Statements collection does not contain value for selectExclusiveJobsToExecute_oracle

miloszpp — Mon, 17 Jun 2013 07:33:36 GMT

Hi!I've just noticed these messages in the logfile for my application. It mentions Oracle (selectExclusiveJobsToExecute_oracle) although I'm using DB2 for the datasource. I'm using Activiti 5.10.I found this: http://forums.activiti.org/content/mapped-statements-collection-does-not-contain-value-0 bu

Re: IllegalArgumentException: Mapped Statements collection does not contain value for selectExclusiveJobsToExecute_oracle

trademak — Mon, 17 Jun 2013 08:31:39 GMT

Did you set the databaseType to db2 in your process engine configuration?

Best regards,

Re: IllegalArgumentException: Mapped Statements collection does not contain value for selectExclusiveJobsToExecute_oracle

miloszpp — Mon, 17 Jun 2013 08:50:17 GMT

Yes I did.

I only noticed this bug when I left the app working over the weekend so I guess it might be related to job execution (I've got some timers in my process).

<code>
<bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration">
<property name="dataSource" ref="dataSource" />
<property name="databaseType" value="db2" />
</code>

Re: IllegalArgumentException: Mapped Statements collection does not contain value for selectExclusiveJobsToExecute_oracle

trademak — Mon, 17 Jun 2013 09:46:06 GMT

Would it be possible to test this against the 5.12.1 or the 5.13 that will be release in a few days? Really strange.

Best regards,

Re: IllegalArgumentException: Mapped Statements collection does not contain value for selectExclusiveJobsToExecute_oracle

miloszpp — Mon, 17 Jun 2013 11:01:35 GMT

Got it, my fault. I recently upgraded to 5.10 and forgot to remove a workaround to http://jira.codehaus.org/browse/ACT-1170.

Sorry and thanks for your reply.

<code>
addDatabaseSpecificStatement("db2", "selectExclusiveJobsToExecute", "selectExclusiveJobsToExecute_oracle");
</code>