Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 820293

Summary: TimerCalendarTest failing on H2 database.
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: Marek Baluch <mbaluch>
Component: JBPM - within SOAAssignee: Marco Rietveld <mrietvel>
Status: CLOSED WONTFIX QA Contact: Marek Baluch <mbaluch>
Severity: medium Docs Contact:
Priority: medium    
Version: 5.3.0 GACC: atangrin, jcoleman, smcgowan, soa-p-jira
Target Milestone: ER3   
Target Release: 5.3.0 GA   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: 5.3.0 GA Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2012-05-29 15:55:00 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
Test Case Results. none

Description Marek Baluch 2012-05-09 14:28:50 UTC 
Description of problem:

H2 is the default database used by SOA-P.

The test does an updateTable call which is supposed to add the CALENDARRESOURCE_ column to the JBPM_JOB table. That call fails with:
  org.h2.jdbc.JdbcSQLException: Table "SYSTEM_SEQUENCES" not found; SQL statement
See attached log file for more detail.


Additional info:

Looks like file jbpm.3/core/src/main/resources/hibernate.properties.hsqldb.xml specifies a different hibernate.dialect than is required. I tried to change from org.hibernate.dialect.HSQLDialect to org.hibernate.dialect.H2Dialect and all tests passed.
Comment 1 Marek Baluch 2012-05-09 14:31:06 UTC 
Created attachment 583312 [details]
Test Case Results.

Attached TimerCalendarTest results. The test output contains one bonus and that is the stack-trace of the exception throw.
Comment 2 Marek Baluch 2012-05-09 14:34:10 UTC 
If the file is intended really for HSQLDB then it might be required to add another file for H2.
Comment 3 Marco Rietveld 2012-05-17 21:48:40 UTC 
The file is intended for HSQLDB. 
H2 is not a requirement for jBPM 3, as far as I know.
Comment 4 Marek Baluch 2012-05-18 07:09:44 UTC 
You're correct. H2 is not a production database.
Comment 5 Julian Coleman 2012-05-29 15:55:00 UTC 
We won't fix this for non-production databases.