Bug 779645 (SOA-2014) - Wrong Hibernate dialect for MySQL in schema tool
Summary: Wrong Hibernate dialect for MySQL in schema tool
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-2014
Product: JBoss Enterprise SOA Platform 4
Classification: JBoss
Component: Tooling
Version: 4.3 CP04 ER1
Hardware: Unspecified
OS: Unspecified
urgent
urgent
Target Milestone: ---
: 4.3 CP04 CR1
Assignee: Kevin Conner
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2010-03-25 12:02 UTC by Jiri Pechanec
Modified: 2010-05-11 07:41 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2010-05-11 07:41:09 UTC
Type: Bug


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker SOA-2014 0 None None None Never

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


Note You need to log in before you can comment on or make changes to this bug.