I am experimenting object/relational persistence using Hibernate
(http://hibernate.sourceforge.net/) and Firebird.


When I run the Hibernate demo (Network.java) it connects OK to the
database,
but when it try's to create Tables by the following SQL an exception
occurs.

create table vertex (creationDate DATE, name VARCHAR(255) not null
unique,
strength FLOAT, version_number INTEGER not null, vertex_id NUMERIC
(18,0) not
null, vertex_type VARCHAR(255) not null, primary key (vertex_id))

I have also try IB Expert and it gives the following message

This operation is not defined for system tables.
unsuccessful metadata update.
key size too big for index RDB$8.

What do I have to do to get it to work?


Philip Bennett