[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Mysql 5.1, unique index and (tiny)blob

[batter]

We created our own hibernate type which is defined as a Type.Varbinary.
In the pojo we define the column lenght (size = 16 ).

In that same pojo the attribute is also used to create a unique index.

Works fine with sqlserver, hsql and oracle 10G.  In mysql 5.1 however, I get a nasty error 

  |   Reason: java.lang.RuntimeException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: BLOB/TEXT column 'PREFIX' used in key specification without a key length
  | 

The create statement: 


  | create table MY_TEST_TABLE (id bigint not null, attr-3 tinyblob not null, attr-2 integer not null, attr-1 bigint not null, primary key (id), unique (attr-1, attr-2, attr-3(16)))
  | 

It seems like mysql wants you to set the size of the index fields for tiny (and probably any) blob fields, so it would look something like


  | create table MY_TEST_TABLE (id bigint not null, attr-3 tinyblob not null, attr-2 integer not null, attr-1 bigint not null, primary key (id), unique (attr-1, attr-2, attr-3))

We are using annotations, is there a way in hibernate to specify this?  How have others handled this problem.

TIA.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4018031#4018031

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4018031