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

[Steve Ebersole (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2221?page=comments#action_25574 ] 

Steve Ebersole commented on HHH-2221:
-------------------------------------

My local MySQL5 install shows these changes as fixing the problem.  Please try from SVN and verify

> 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...

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira