[Hibernate-issues] [Hibernate-JIRA] Commented: (HB-293) Seperating InterBase and Firebird dialects

[<leg...@at...>]

The following comment has been added to this issue:

     Author: Reha CENANI
    Created: Wed, 27 Aug 2003 4:45 AM
       Body:
Regarding the Sequence value and string issues:

*** Common ***
supportsSequences() --> true

getCreateSequenceString(String sequenceName) -->
"CREATE GENERATOR " + sequenceName

getSequenceNextValString(String sequenceName) -->
"SELECT GEN_ID(" + sequenceName + ", 1) FROM RDB$DATABASE"

*** For Firebird: ***
getDropSequenceString(String sequenceName) -->
"DROP GENERATOR " + sequenceName

*** For InterBase: ***
getDropSequenceString(String sequenceName) -->
"DELETE FROM RDB$GENERATORS WHERE RDB$GENERATOR_NAME = '" + sequenceName.toUpperCase() + "'"


---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-293


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-293
    Summary: Seperating InterBase and Firebird dialects
       Type: Improvement

     Status: Unassigned
   Priority: Major

    Project: Hibernate2
 Components: 
             core

   Assignee: 
   Reporter: Reha CENANI

    Created: Tue, 26 Aug 2003 6:46 AM
    Updated: Tue, 26 Aug 2003 6:46 AM

Description:
At the begining, opensource Firebird (or FirebirdSQL) was based on the same source code of commercial InterBase. But during past three years, lots of improvements are done to the Firebird. Recent versions of these DBMSs have different features and statement syntaxes. 

For example, their select offset/limit statement syntaxes are not compatible. Hibernate's recent InterbaseDialect select limit/offset feature is based on the Firebird's select statement syntax.

So, in order to prevent incompabilities and confussion, in addition to the InterbaseDialect, adding a new FirebirdDialect and seperating Firebird and InterBase features will be very helpfull.





---------------------------------------------------------------------
JIRA INFORMATION:
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

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira