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

[Todd N. (JIRA) <no...@at...>]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HB-1215?page=comments#action_23155 ] 

Todd Nine commented on HB-1215:
-------------------------------

I need to implement a dialect for Tera Data, but I will be using Hibernate 3.  As far as I can tell, TeraData's type 4 driver does not support any sort of metadata, should I just throw an UnsupportedOperationException for the DDL generation.

> Teradata Dialect
> ----------------
>
>          Key: HB-1215
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HB-1215
>      Project: Hibernate2
>         Type: Patch

>  Environment: hibernate 2.1.4 on JBoss 3.2.5
>     Reporter: John Pianezze
>  Attachments: TeradataDialect.java
>
> Original Estimate: 1 hour
>         Remaining: 1 hour
>
> 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.

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