Re: FW: [Hibernate-devel] Is there a way to setup referential integrty?

[Gavin_King/Cirrus%<CI...@ci...>]

> Nope, does not support the standard..
>
> instead it uses something like the following
>
> -- Referential integrity
> create table main(id int identity,name varchar)
> create table ref(id int identity,idMain int, foreign
key(idMain)references
> main(id))

Yeah I checked up on this last night. I can't see how we could use this
because hibernate allows tables to have circular foreign key references,
etc. whereas this would require that tables be created in a predefined
order. So I can't see how it would fit the model.

I think we'll have to leave it unsupported until HSQL implements an alter
table.