[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5244) Flesh out H2Dialect temp table support

[Steve Ebersole (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5244?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=37229#action_37229 ] 

Steve Ebersole commented on HHH-5244:
-------------------------------------

It seems that the workable set of options are:
# create temp tables as "create [memory] global temporary table if not exists".  MEMORY is defined as the default for temp tables, and I have encountered issues trying to use CACHED which is unfortunately recommended option if the table can get "too large" [re http://www.h2database.com/html/grammar.html#create_table] (unfortunately it never qualifies "too large").
# dropTemporaryTableAfterUse() == false  Since the temp table is created as a GLOBAL temp table, this needs to be the case.  And it does need to be defined as such because any DDL statements in H2 cause an implicit transaction commit.

Verifying these options: http://groups.google.com/group/h2-database/browse_thread/thread/b60b496b3cf29905

> Flesh out H2Dialect temp table support
> --------------------------------------
>
>                 Key: HHH-5244
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5244
>             Project: Hibernate Core
>          Issue Type: Improvement
>          Components: core
>            Reporter: Steve Ebersole
>            Assignee: Steve Ebersole
>             Fix For: 3.6
>
>
> The main symptom right now is that the test suite runs extremely slow against H2 because the H2Dialect is not properly defining how to work with temp tables.

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