Bug 779645 (SOA-2014)

Summary: Wrong Hibernate dialect for MySQL in schema tool
Product: [JBoss] JBoss Enterprise SOA Platform 4 Reporter: Jiri Pechanec <jpechane>
Component: ToolingAssignee: Kevin Conner <kevin.conner>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: urgent Docs Contact:
Priority: urgent    
Version: 4.3 CP04 ER1   
Target Milestone: ---   
Target Release: 4.3 CP04 CR1   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-2014
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2010-05-11 07:41:09 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 Jiri Pechanec 2010-03-25 12:02:36 UTC
Date of First Response: 2010-03-31 09:40:13
project_key: SOA

File schema/mysql/config.properties contains
hibernate.dialect=org.hibernate.dialect.MySQLDialect
but it should be
hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect

Comment 1 Anne-Louise Tangring 2010-03-31 13:40:13 UTC
Approved for SOA 4.3 CP03

Comment 2 trev 2010-03-31 14:07:34 UTC
this  might require an ESB change too - the console uses "MySQLDialect"

Comment 3 Julian Coleman 2010-03-31 14:37:31 UTC
Schema tool fixed with revision 5372 (4.3 branch) of:
  build-tools/resource/schema/tool/esb/build.xml
  build-tools/resource/schema/tool/esb/mysql/config.properties

Commit message:
  SOA-2014
  Change MySQL hibernate dialect to "MySQL5InnoDBDialect".


Comment 4 Julian Coleman 2010-03-31 14:48:01 UTC
The ESB (4.4 branch) management console requires a change in:
  product/tools/console/management/mysql.properties
to change the dialect from:
  org.hibernate.dialect.MySQLDialect
to
  org.hibernate.dialect.MySQL5InnoDBDialect

Comment 5 trev 2010-04-01 11:49:14 UTC
soa part done

Comment 6 Kevin Conner 2010-04-07 10:40:12 UTC
Link: Added: This issue depends JBESB-3268


Comment 7 Kevin Conner 2010-04-07 15:45:31 UTC
Updated in ESB codebase, will be in next merge.

Comment 8 Jiri Pechanec 2010-05-11 07:41:09 UTC
Verified in CR1