[JBoss jBPM] - Problems with indexes in jbpm.history.hbm.xml
by bogdanj
I think there is a problem with the way indexes are defined in hibernate for history tables (jbpm.history.hbm.xml).
Example:
| <class name="HistoryProcessInstanceImpl" table="JBPM4_HIST_PROCINST">
| <id name="dbid" column="DBID_">
| <generator class="assigned" />
| </id>
|
| ...
|
| <set name="details"
| cascade="all">
| <key foreign-key="FK_HDETAIL_HPROCI">
| <column name="HPROCI_" index="IDX_HDETAIL_HPROCI" />
| </key>
| <one-to-many class="HistoryDetailImpl" />
| </set>
|
| </class>
|
If you go down in the file you will find the table for HistoryDetailImpl with the many-to-one definition:
| <class name="HistoryDetailImpl" table="JBPM4_HIST_DETAIL">
| ...
|
| <many-to-one name="historyProcessInstance"
| class="HistoryProcessInstanceImpl"
| column="HPROCI_"
| foreign-key="FK_HDET_HPROCI"
| index="IDX_HDET_HPROCI" />
| <property name="historyProcessInstanceIndex" column="HPROCIIDX_" />
|
| ...
|
So there are two name for the same index (on the same column HPROCI_): IDX_HDETAIL_HPROCI (from the inverse one-to-many relation) and IDX_HDET_HPROCI (from the direct many-to-one relation).
That causes hbm2ddl tool to create a faulty sql (in the jbpm-4.0 ditribution see db/jbpm.oracle.create.sql):
| create index IDX_HDET_HACTI on JBPM4_HIST_DETAIL (HACTI_);
|
| create index IDX_HDET_HPROCI on JBPM4_HIST_DETAIL (HPROCI_);
|
| create index IDX_HDETAIL_HACTI on JBPM4_HIST_DETAIL (HACTI_);
|
| create index IDX_HDETAIL_HVAR on JBPM4_HIST_DETAIL (HVAR_);
|
| create index IDX_HDETAIL_HTASK on JBPM4_HIST_DETAIL (HTASK_);
|
| create index IDX_HDETAIL_HPROCI on JBPM4_HIST_DETAIL (HPROCI_);
|
| create index IDX_HDET_HVAR on JBPM4_HIST_DETAIL (HVAR_);
|
| create index IDX_HDET_HTASK on JBPM4_HIST_DETAIL (HTASK_);
Oracle will throw an error about duplicate index on the same column for columns HACTI_, HVAR_, HTASK_. For whatever reason MySql and HSQLDB work fine with this indexes but oracle has a problem.
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4247034#4247034
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4247034
17 years
[JBoss jBPM] - Problem configuring jBPM4 with Spring
by bogdanj
Hi
I have a problem related to configuring jBPM 4 and Spring.
Here is jbpm.cfg.xml:
| <?xml version="1.0" encoding="UTF-8"?>
|
| <jbpm-configuration>
|
| <import resource="jbpm.jpdl.cfg.xml" />
| <import resource="jbpm.identity.cfg.xml" />
| <import resource="jbpm.jobexecutor.cfg.xml" />
|
| <process-engine-context>
| <repository-service />
| <repository-cache />
| <execution-service />
| <history-service />
| <management-service />
| <identity-service />
| <task-service />
|
| <!-- Here we needed to change the transaction interceptor to spring-transaction-interceptor -->
| <command-service>
| <spring-transaction-interceptor />
| <retry-interceptor type="jta" />
| <environment-interceptor />
| </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>
|
| <authentication />
|
| <id-generator />
| <types resource="jbpm.variable.types.xml" />
|
| <address-resolver />
|
| <business-calendar>
| <monday hours="9:00-12:00 and 12:30-17:00" />
| <tuesday hours="9:00-12:00 and 12:30-17:00" />
| <wednesday hours="9:00-12:00 and 12:30-17:00" />
| <thursday hours="9:00-12:00 and 12:30-17:00" />
| <friday hours="9:00-12:00 and 12:30-17:00" />
| <holiday period="01/07/2008 - 31/08/2008" />
| </business-calendar>
|
| <mail-template name='task-notification'>
| <to users="${task.assignee}" />
| <subject>${task.name}</subject>
| <text><![CDATA[Hi ${task.assignee},
| Task "${task.name}" has been assigned to you.
| ${task.description}
|
| Sent by JBoss jBPM
| ]]></text>
| </mail-template>
|
| <mail-template name='task-reminder'>
| <to users="${task.assignee}" />
| <subject>${task.name}</subject>
| <text><![CDATA[Hey ${task.assignee},
| Do not forget about task "${task.name}".
| ${task.description}
|
| Sent by JBoss jBPM
| ]]></text>
| </mail-template>
|
|
|
| </process-engine-context>
|
| <transaction-context>
| <transaction type="jta" />
|
| <repository-session />
| <db-session />
|
| <message-session />
| <timer-session />
| <history-session />
| <mail-session>
| <mail-server>
| <session-properties resource="jbpm.mail.properties" />
| </mail-server>
| </mail-session>
|
| <!-- Need to set explicitly that we don't want jbpm to create sessions -->
| <hibernate-session current="true" />
| </transaction-context>
| </jbpm-configuration>
|
In Spring applicationContext I have defined the following
| <!--
| jBPM related beans
| -->
|
| <bean id="jbpmConfiguration" class="org.jbpm.pvm.internal.cfg.SpringConfiguration">
| <constructor-arg value="jbpm.cfg.xml" />
| </bean>
|
| <bean id="processEngine" factory-bean="jbpmConfiguration" factory-method="buildProcessEngine" />
| <bean id="repositoryService" factory-bean="processEngine" factory-method="getRepositoryService" />
| <bean id="executionService" factory-bean="processEngine" factory-method="getExecutionService" />
When trying to execute something like:
| NewDeployment deployment = repositoryService.createDeployment();
| deployment.addResourceFromClasspath("com/webmedia/bes/jbpm/hello-world.jpdl.xml");
| deployment.deploy();
|
I end up with:
| by: org.jbpm.api.JbpmException: no environment for managing hibernate transaction
| at org.jbpm.pvm.internal.tx.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:53)
| at org.jbpm.pvm.internal.repository.DeploymentImpl.deploy(DeploymentImpl.java:89)
| at com.webmedia.bes.web.action.BudgetsBrowser.browse(BudgetsBrowser.java:87)
| at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
| at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
| at java.lang.reflect.Method.invoke(Method.java:597)
I guess I am missing something obvious in the configuration. It wouldn't be the first time, if somebody can help, I would be very thankful.
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4247024#4247024
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4247024
17 years