[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-4486) Account for MySQL's <DROP TEMPORARY TABLE> statement

Account for MySQL's <DROP TEMPORARY TABLE> statement ---------------------------------------------------- Key: HHH-4486 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4486 Project: Hibernate Core Issue Type: Bug Components: core, query-hql Reporter: Steve Ebersole Assignee: Steve Ebersole Fix For: 3.2.x, 3.3.x, 3.5 Time Spent: 2 hours, 30 minutes Remaining Estimate: 0 minutes MySQL has a statement <DROP TEMPORARY TABLE> that is meant to be the corollary to <CREATE TEMPORARY TABLE>. The important aspect is that the inclusion of the TEMPORARY keyword in each bypasses the implicit transaction commit from DDL execution. Currently we use <CREATE TEMPORARY TABLE>, which is ok for use within a transaction, but then <DROP TABLE> which causes an implicit commit (and actually causes an immediate failure within an XA transaction). For MySQL we should use <CREATE TEMPORARY TABLE> and <DROP TEMPORARY TABLE>. <DROP TEMPORARY TABLE> documentation -> http://dev.mysql.com/doc/refman/5.0/en/drop-table.html Implicit commit documentation -> http://dev.mysql.com/doc/refman/5.0/en/implicit-commit.html