[jBPM] - How to limit size of jBPM tables : jbpm4_variable and jbpm4_lob ?
by 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&cont...]
16 years, 1 month
Re: [jboss-user] [Datasource Configuration] - Connection problem to mySQL database
by sebastien ferrand
sebastien ferrand [http://community.jboss.org/people/microbe] replied to the discussion
"Connection problem to mySQL database"
To view the discussion, visit: http://community.jboss.org/message/534187#534187
--------------------------------------------------------------
Here is the principal error :
15:15:22,548 WARN [loggerI18N] [com.arjuna.ats.internal.jta.transaction.arjunacore.lastResource.disallow] [com.arjuna.ats.internal.jta.transaction.arjunacore.lastResource.disallow] Adding multiple last resources is disallowed. Current resource is org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@339dd9
15:15:22,552 ERROR [STDERR] org.jboss.util.NestedSQLException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: 7f000101:e017:4bacc11e:1ec status: ActionStatus.ABORT_ONLY >); - nested throwable: (org.jboss.resource.JBossResourceException: Could not enlist in transaction on entering meta-aware object!; - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: 7f000101:e017:4bacc11e:1ec status: ActionStatus.ABORT_ONLY >))
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/534187#534187]
Start a new discussion in Datasource Configuration at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]
16 years, 1 month