Hibernate @Index error on long string columns

Question

I have a data model where I need a String column to be indexed by the backing database:

@Entity
public class A {
    // ... 

    @Column(length=2048)
    @Index(name="strFieldIndex")
    private String strField;
}

When adding the length attribute of @Column(length=2048) (for which hibernate doesn't generate varchar anymore) the following error message appears on MySQL:

ERROR org.hibernate.tool.hbm2ddl.SchemaExport - 
    BLOB/TEXT column 'strField' used in key specification without a key length

I've scanned the API docs for hibernate and I can't find an approach to setting the key length.

AFAIK, this annotation is used when Hibernate generates the database schema for you, in order to create an index in the database. Do you let hibernate generate your schema? Is the index created? — JB Nizet
– JB Nizet, Commented Mar 8, 2011 at 8:20
@JB Nizet, yes you're right, although I see I posted an incomplete question so I've updated it! — Johan Sjöberg
– Johan Sjöberg, Commented Mar 8, 2011 at 8:53

axtavt · Accepted Answer · 2011-03-08 11:10:48Z

2

I think you have to declare this index manually as required for MySQL, since Hibernate can't handle all DBMS-specific requirements. For example, using <database-object> syntax.

answered Mar 8, 2011 at 11:10

axtavt

243k42 gold badges518 silver badges486 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

rustyx Over a year ago

Is there any way to do this on a PRIMARY KEY? I guess I have to suppress Hibernate generating the primary key somehow, but that doesn't seem feasible. Is there any way to supply custom SQL for PRIMARY KEY generation?

Collectives™ on Stack Overflow

Hibernate @Index error on long string columns

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related