[jboss-user] [jBPM] - How to limit size of jBPM tables : jbpm4_variable and jbpm4_lob ?
Moi Meme
do-not-reply at jboss.com
Fri Mar 26 11:30:29 EDT 2010
Moi Meme [http://community.jboss.org/people/kiwifrog] created the discussion
"How to limit size of jBPM tables : jbpm4_variable and jbpm4_lob ?"
To view the discussion, visit: http://community.jboss.org/message/534200#534200
--------------------------------------------------------------
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>
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/534200#534200]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20100326/0541496f/attachment.html
More information about the jboss-user
mailing list