[jboss-user] [jBPM] - How to limit size of jBPM tables : jbpm4_variable and jbpm4_lob ?

[Moi Meme]

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