The two tables jbpm4_variable and jbpm4_lob are getting huge (data and index) very quickly when I run my application.
How can I limit the their size?
Is this a configuration issue or do I need to programmatically delete the data asssociated with a process when it is finished?
Any help would be greatly appreciated!
My jbpm.cfg looks like this:
<?xml version="1.0" encoding="UTF-8"?>
<jbpm-configuration>
<import resource="jbpm.jpdl.cfg.xml" />
<import resource="jbpm.identity.cfg.xml" />
<import resource="jbpm.businesscalendar.cfg.xml" />
<process-engine-context>
<repository-service />
<repository-cache />
<execution-service />
<history-service />
<management-service />
<identity-service />
<task-service />
<job-executor threads="2" idle="3600000" idle-max="60000" lock-millis="3600000" />
<command-service name="txRequiredCommandService">
<skip-interceptor />
<retry-interceptor />
<environment-interceptor />
<spring-transaction-interceptor transactionManager="transactionManager" />
</command-service>
<command-service name="newTxRequiredCommandService">
<retry-interceptor />
<environment-interceptor policy="requiresNew" />
<spring-transaction-interceptor transactionManager="transactionManager" />
</command-service>
<!-- Added spring as read-context -->
<script-manager default-expression-language="juel" default-script-language="juel" read-contexts="execution, environment, process-engine, spring"
write-context="">
<script-language name="juel" factory="org.jbpm.pvm.internal.script.JuelScriptEngineFactory" />
</script-manager>
<types resource="jbpm.variable.types.xml" />
<address-resolver />
<id-generator />
<types resource="jbpm.variable.types.xml" />
<!-- ID COMPOSER -->
<object init="eager">
<field name="commandService"><ref object="newTxRequiredCommandService" /></field>
<invoke method="initialize" />
</object>
<object init="eager" />
</process-engine-context>
<transaction-context>
<repository-session />
<db-session />
<message-session />
<timer-session />
<history-sessions>
<object />
</history-sessions>
<mail-session>
<mail-server>
<session-properties resource="jbpm.mail.properties" />
</mail-server>
</mail-session>
<!-- SPRING -->
<transaction type="spring" />
<hibernate-session current="true" />
</transaction-context>
</jbpm-configuration>