[hibernate-issues] [Hibernate-JIRA] Reopened: (HHH-5558) Change made so that temp tables need not to be deleted, they get deleted automatically in Sybase.

[Strong Liu (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5558?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Strong Liu reopened HHH-5558:
-----------------------------


One of the suggestion I gave for not dropping the "temp table". Please
disregard that, I find some erroneous behavior because of that. Other
implication is if user is connected to the DB for a long time, it requires
a bigger temp table space.

> 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
>             Fix For: 3.6.0.CR1
>
>
> >
> >    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