[hibernate-issues] [Hibernate-JIRA] Resolved: (HHH-2221) MySQL temp table DDL and isolation

MySQL temp table DDL and isolation ---------------------------------- Key: HHH-2221 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2221 Project: Hibernate3 Type: Bug

Components: core Versions: 3.2.0.ga Environment: INFO: Hibernate 3.2.0 INFO: RDBMS: MySQL, version: 5.0.22 INFO: JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.0.4 ( $Date: 2006-10-19 17:47:48 +0200 (Thu, 19 Oct 2006) $, $Revision: 5908 $ ) Reporter: Donnchadh O Donnabhain Assignee: Steve Ebersole Fix For: 3.2.2 Attachments: HHH-2221.patch, JoinedSubclassTest.java On MySQL, temporary table DDL operations do not cause implicit transaction commits, even though the driver metadata reports that DDL does cause implicit transaction commits. The reason being that MySQL handles temp table DDL operations differently than non-temp DDL, which the JDBC metadata does not account for. Thus, need a way for the dialect to unequivocally force the temp table DDL to be performed in the current transaction regardless of what the driver reports...