Bug 778061 (SOA-586)

Summary: JBM hsqldb code incorrect in EAP 4.3.0 GA CP01
Product: [JBoss] JBoss Enterprise SOA Platform 4 Reporter: Julian Coleman <jcoleman>
Component: JBoss MessagingAssignee: Julian Coleman <jcoleman>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 4.2 CP02   
Target Milestone: ---   
Target Release: 4.3 GA   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-586
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2008-09-29 11:41:47 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:

Description Julian Coleman 2008-06-17 13:16:09 UTC 
Date of First Response: 2008-06-25 07:20:46
project_key: SOA

The default SQL configuration in the JBM source code shipped with EAP 4.3.0 GA CP 01 has errors.  This causes a problem with hsqldb, which uses the default SQL configuration.

This is an addenda to SOA-575.
Comment 1 Julian Coleman 2008-06-17 13:19:47 UTC 
Link: Added: This issue related SOA-575
Comment 2 Julian Coleman 2008-06-19 09:54:09 UTC 
The SQL errors are fixed in JBM 1.4.1 CR1.  See:
   http://anonsvn.jboss.org/repos/messaging/tags/JBossMessaging_1_4_1_CR1/src/main/org/jboss/messaging/core/impl/JDBCPersistenceManager.java
Comment 3 Julian Coleman 2008-06-19 11:14:36 UTC 
This needs to be fixed upstream in EAP.  See linked issue.
Comment 4 Julian Coleman 2008-06-19 11:14:36 UTC 
Link: Added: This issue depends JBPAPP-900
Comment 5 Julian Coleman 2008-06-19 11:19:20 UTC 
Worked round by overwriting the hsqldb configuration for 4.2.0 CP02 (CR3).
Needs to be fixed properly in EAP.

Commits for workround:
  Revision 1345
    build-tools/resource/schema/jms/clustered-hsqldb-persistence-service.xml
    build-tools/resource/schema/jms/hsqldb-persistence-service.xml
  Revision 1346
    build-tools/builders/eap/build.xml
Comment 6 Jiri Pechanec 2008-06-25 11:20:46 UTC 
The workoaround was verified in CR4
Comment 7 nwallace 2008-09-25 19:08:28 UTC 
Link: Added: This issue related SOA-849