Hi,

a) in general, this is a question to IB-Support group;
b) in InterBase/Firebird size of an index entry is limited to 127
bytes. when you declare field unique, server creates an index
automatically. so, you either remove 'unique' constraint on
the 'name' column, or reduce size of the column to 127.

best regards,
roman rokytskyy

--- In Firebird-Java@y..., "paboz" <pbennett@g...> wrote:
> 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