[hibernate-issues] [Hibernate-JIRA] Resolved: (HHH-5558) Change made so that temp tables need not to be deleted, they get deleted automatically in Sybase.
Strong Liu (JIRA)
noreply at atlassian.com
Tue Sep 14 22:57:23 EDT 2010
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5558?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Strong Liu resolved HHH-5558.
-----------------------------
Resolution: Rejected
Fix Version/s: (was: 3.6.0.CR1)
> Change made so that temp tables need not to be deleted, they get deleted automatically in Sybase.
> --------------------------------------------------------------------------------------------------
>
> Key: HHH-5558
> URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5558
> Project: Hibernate Core
> Issue Type: Improvement
> Components: core
> Reporter: Strong Liu
> Assignee: Strong Liu
>
> >
> > Change made so that temp tables need not to be deleted, they get deleted
> > automatically in Sybase.
> >
> Hibernate does not isolate operations on temp tables in a separate
> transaction because:
> 1) "ddl in trans" is set (iirc, this is a requirement for hibernate to
> work properly)
> 2) (DatabaseMetaData.dataDefinitionCausesTransactionCommit() returns
> false).
> In other words, operations on temp tables are executed in the current
> transaction. Since other operations can be executed later in the same
> transaction, I though it was a good idea to manually drop the temp
> tables when they are no longer needed, instead of waiting for them to be
> cleaned up automatically on commit.
> If "ddl in trans" is no longer needed or if you think it is more correct
> to wait until the transaction is committed for temp table cleanup, then
> it should be OK to make this change to the dialect.
> <AJ> While I do this change I see some performance improvement and no regression in the tests (I ran around 2000 tests of testsuite). If you see the same in your testing it is worth doing.
> >
> > Sybase supports alias length upto 30 characters (more than 10 as it is
> > indicated)
> >
> As far as I know, there should be no problem making this update.
--
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
More information about the hibernate-issues
mailing list