DB.verifyClean() in JbpmTestCase.tearDown() fails for DB2 database ------------------------------------------------------------------ Key: JBPM-2847 URL: https://jira.jboss.org/jira/browse/JBPM-2847 Project: jBPM Issue Type: Bug Security Level: Public(Everyone can see) Affects Versions: jBPM 4.3 Environment: JBPM 4.3 on DB2 v9 database. All tables in JBPMDB schema. Reporter: Joost den Boer At the end of a JbpmTestCase the database is cleaned. This fails for a DB2 database because the default schema is not added to the table name. The created query is "select count(*) as RECORD_COUNT_ from JBPM4_DEPLOYMENT", but this should be "select count(*) as RECORD_COUNT_ from JBPMDB.JBPM4_DEPLOYMENT". The schema name is available in the SessionFactory Settings so should not be to difficult to fix this.

DB.verifyClean() in JbpmTestCase.tearDown() fails for DB2 database ------------------------------------------------------------------ Key: JBPM-2847 URL: https://jira.jboss.org/browse/JBPM-2847 Project: jBPM Issue Type: Bug Security Level: Public(Everyone can see) Affects Versions: jBPM 4.3 Environment: JBPM 4.3 on DB2 v9 database. All tables in JBPMDB schema. jdbpm.hibernate.cfg.xml for DB2: <?xml version="1.0" encoding="utf-8"?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory> <!-- DB2 CONFIG --> <property name="hibernate.default_schema">JBPMDB</property> <property name="hibernate.dialect">org.hibernate.dialect.DB2Dialect</property> <property name="hibernate.connection.driver_class">com.ibm.db2.jcc.DB2Driver</property> <property name="hibernate.connection.url">jdbc:db2://#SERVER:#PORT/#DB</property> <property name="hibernate.connection.username">#USERNAME</property> <property name="hibernate.connection.password">#PASSWORD</property> <property name="hibernate.format_sql">true</property> <property name="hibernate.hbm2ddl.auto">update</property> <!-- <property name="hibernate.show_sql">true</property> <property name="hibernate.connection.autocommit">true</property> --> <mapping resource="jbpm.repository.hbm.xml" /> <mapping resource="jbpm.execution.hbm.xml" /> <mapping resource="jbpm.history.hbm.xml" /> <mapping resource="jbpm.task.hbm.xml" /> <mapping resource="jbpm.identity.hbm.xml" /> </session-factory> </hibernate-configuration> Reporter: Joost den Boer Fix For: jBPM 4.x At the end of a JbpmTestCase the database is cleaned. This fails for a DB2 database because the default schema is not added to the table name. The created query is "select count(*) as RECORD_COUNT_ from JBPM4_DEPLOYMENT", but this should be "select count(*) as RECORD_COUNT_ from JBPMDB.JBPM4_DEPLOYMENT". The schema name is available in the SessionFactory Settings so should not be to difficult to fix this.