Unimplemented DDL

[Mick Francis]

Hi,

Are there any plans to implement more DDL statements? In particular:

    DROP INDEX indexName on tableName
    ALTER TABLE tableName DROP CONSTRAINT constraintName
    ALTER TABLE tableName ALTER COLUMN ...

Cheers,

Mick.

[Gord Thompson]

ALTER TABLE tableName DROP CONSTRAINT constraintName

does work in UCanAccess 4.0.4. Perhaps it just didn't get added to the documentation.

[Mick Francis]

I get the following in 4.0.4:

create table ttt (c char not null);
alter table ttt add constraint PK_TTT primary key (c);
alter table ttt drop constraint PK_TTT;

UCanAccess>UCAExc:::4.0.4 java.lang.UnsupportedOperationException: DROP CONSTRAINT is only supported for Hibernate hbm2ddl.auto "create"

Cheers,

Mick.

[Gord Thompson]

Oh that's right, sorry. I implemented DROP CONSTRAINT for Hibernate support but it was a bit of a hack (didn't clean up after itself) so I put in the extra check to restrict its usage.

[Ingrid]

Hi, will this get fixed?
I still receive this error - also with 5.0.1.
Or is there any workaround?
Regards - Ingrid