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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5244?page=c... ] 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/b60b496b3... -- 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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira