[
https://jira.jboss.org/jira/browse/JBPM-2294?page=com.atlassian.jira.plug...
]
Tom Baeyens commented on JBPM-2294:
-----------------------------------
seems to be a problem with DB cleaning:
drop.jbpm.schema:
[sql] Executing file:
/mnt/hudson_workspace/workspace/jbpm4-jboss/DATABASE/postgresql/JBOSS_VERSION/5.0.0.GA/jdk/java16_default/label/dev45/jbpm-4.0-SNAPSHOT/db/schema.scripts/jbpm.postgresql.drop.sql
[sql] Failed to execute: alter table JBPM4_COMMENT drop constraint
FKFD23139F86A745AD
[sql] org.postgresql.util.PSQLException: ERROR: constraint
"fkfd23139f86a745ad" does not exist
[sql] Failed to execute: alter table JBPM4_DEPLOYPROP drop constraint
FK_DEPLPROP_DEPL
[sql] org.postgresql.util.PSQLException: ERROR: current transaction is aborted,
commands ignored until end of transaction block
[sql] Failed to execute: alter table JBPM4_EXECUTION drop constraint
FK_EXEC_SUBPI
i have tried to more the sql execution from a transaction:
<sql driver="${jdbc.driver}"
url="${jdbc.url}"
userid="${jdbc.username}"
password="${jdbc.password}"
onerror="continue">
<transaction
src="${jbpm.home}/db/schema.scripts/jbpm.${database}.create.sql"/>
<classpath>
<fileset dir="${jbpm.home}/lib">
<include name="*.jar"/>
</fileset>
</classpath>
</sql>
to just a src attribute
<sql driver="${jdbc.driver}"
url="${jdbc.url}"
userid="${jdbc.username}"
password="${jdbc.password}"
onerror="continue"
src="${jbpm.home}/db/schema.scripts/jbpm.${database}.create.sql">
<classpath>
<fileset dir="${jbpm.home}/lib">
<include name="*.jar"/>
</fileset>
</classpath>
</sql>
let's see if that helps...
examples fail against postgresql
--------------------------------
Key: JBPM-2294
URL:
https://jira.jboss.org/jira/browse/JBPM-2294
Project: JBoss jBPM
Issue Type: Feature Request
Components: Runtime Engine
Affects Versions: jBPM 4.0.0.Beta2
Reporter: Alejandro Guizar
Assignee: Alejandro Guizar
Priority: Blocker
Fix For: jBPM 4.0.CR1
Original Estimate: 0 minutes
Remaining Estimate: 0 minutes
The failure occurs under any JDK and JBoss AS version.
For details see the Hudson run.
http://hudson.qa.jboss.com/hudson/view/JBPM4/job/jbpm4-jboss/26/
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira