[jbpm-issues] [JBoss JIRA] Commented: (JBPM-2294) examples fail against postgresql

[ 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... -- 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