[nhibernate-issues] [NHJIRA] Commented: (NH-2526) Sybase ASE 15 support

[Julian M. (JIRA) <nh...@gm...>]

    [ http://216.121.112.228/browse/NH-2526?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=20911#action_20911 ] 

Julian Maughan commented on NH-2526:
------------------------------------

Not sure if you saw this, but in the code I commented that temp tables can be created outside a transaction by changing the 'ddl in tran' setting to true on the tempdb database. However, there are some fairly dire warnings about doing so, such as: "WARNING! Data definition language (DDL) commands hold locks on system tables such as sysobjects. Avoid using them inside transactions; if you must use them, keep the transactions short. Using any DDL commands on tempdb within transactions may cause your system to grind to a halt. Always leave ddl in tran set to false in tempdb."

Changing the setting did improve the number of test passes considerably. It doesn't make sense to me that temp tables would be handled like other DDL statements.

> Sybase ASE 15 support
> ---------------------
>
>                 Key: NH-2526
>                 URL: http://216.121.112.228/browse/NH-2526
>             Project:  NHibernate
>          Issue Type: Improvement
>          Components: DataProviders / Dialects
>    Affects Versions: 3.0.0.GA
>            Reporter: Jim Hale Jr.
>            Priority: Major
>             Fix For: 3.2.0Alpha1
>
>         Attachments: SybaseAdoNet2ClientDriver.cs, SybaseAse15Dialect.cs
>
>
> The 3.0.0 release banished Sybase ASE users for reasons unknown to me.  I understand the criticism of the 2.x and 3.0.0 release candidate implementations of the Sybase ASE dialect (yes they were bad), but at least they let ASE users use NHibernate.  Better to have basic but functional support than no support at all.  This is especially important for ASE users considering the lack of Entity support by Sybase for ASE.  Removing ASE support forced NHibernate users to stay with the 2.12 release or pay for an Entity aware provider.  The comments I read regarding the removal of ASE support - specifically regarding the merging of the ASE and ASA dialects - also make no sense to me.  ASA and ASE are two different products with different keywords, SQL syntax, functions, and drivers.  Their dialects cannot be merged!  Same with the supposed support from the MS SQL 2000 dialect - this dialect uses MS keywords like 'TOP' that ASE does not support.
> Attached is a port of the Sybase ASE Dialect from the Java Hibernate project along with support for the ADO.NET driver provided by Sybase.  I am using it in a project currently and it at least appears to work.  I am only using the most basic of NHibernate features though so additional testing would be nice.  But it provides a start.
> Tested against Sybase 15.0.3.0 using .NET 4.0 runtime and Sybase.AdoNet2.AseClient.dll driver (version 1.15.305.0).

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