[hibernate-dev] Hbm2ddl issue with TeraData database

[ramya jayaseelan]

> Hi All,
>
>
> Ref: https://hibernate.onjira.com/browse/HHH-4732#comment-48576
>
> I am facing bellows issues in HBM2DDL with Teradata database.
>
> 1. HBM2DDL=UPDATE => Only new tables are getting created; ALTER statements
> are not getting generated for TERADATA.
>
> 2. Composite Primary Key => Column Name is not having the
> attributeoverrides column name in In Teradata.
>
> 3. Fk Reference and Self Reference => Duplicate Table is getting generated
> for the references. <TableName>_0 in Teradata.
>
> 4. Composite Unique/Unique constraint => new table is getting created
> which is not required from client side. how to avoid this.
>
> create table hibernate_unique_key (
> next_hi INTEGER
> );
> insert into hibernate_unique_key values ( 0 );
>
> 5. Composite Index Statement is wrong in Teradata.
> Actual Statement:
> create index NameIndex on tablename(col1, col2) ;
> Expected Statement:
> create index NameIndex (col1, col2) on tablename;
>
>
> Please help me to solve this issue in teradata. Thanks in advance!
>
>
>
>
>
> Hibernate-version: 3.6.7.Final
>
> Hibernate-tools: 3.2.0.beta9a
>
> Teradata driver: terajdbc4 – Teradata 13.10
>
>
>
>
>
> *Thanks & Regards*
>
> Ramya J
>