[Hibernate-issues] [Hibernate-JIRA] Updated: (HB-1215) Teradata Dialect

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

The following issue has been updated:

    Updater: Gavin King (mailto:ga...@hi...)
       Date: Sun, 26 Sep 2004 9:40 PM
    Changes:
             type changed from Improvement to Patch
    ---------------------------------------------------------------------
For a full history of the issue, see:

  http://opensource.atlassian.com/projects/hibernate/browse/HB-1215?page=history

---------------------------------------------------------------------
View the issue:
  http://opensource.atlassian.com/projects/hibernate/browse/HB-1215

Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-1215
    Summary: Teradata Dialect
       Type: Patch

     Status: Unassigned
   Priority: Major

 Original Estimate: 1 hour
 Time Spent: Unknown
  Remaining: 1 hour

    Project: Hibernate2

   Assignee: 
   Reporter: John Pianezze

    Created: Tue, 7 Sep 2004 5:56 PM
    Updated: Sun, 26 Sep 2004 9:40 PM
Environment: hibernate 2.1.4 on JBoss 3.2.5

Description:
The Teradata DBMS is not supported. 
I have implemented a dialect that supports the basic features of the database.

Notes: Newer versions of teradata support "identity columns" but there's no way to know the value of the column that was generated, so you can't use it generate the ID column with Hibernate.

It also does not support Sequence numbers, however you can implement a "teradata macro" to support it, and inthe dialect, you use the following syntax:
  execute hibernate_sequence(seq_name)
with the sequence name as a parameter.

One additional fix is required, as detailed in HB-1214
the JDBC code that runs the sequence query needs to be able to get the sequence number from a compound result set.


---------------------------------------------------------------------
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