Hi there,

I request your help for what seems to be a quite simple problem:

I need to store a 128 bits hash value (16 Bytes) as a primary key into my database via Hibernate. How could I do that ?

I first thought I use the hibernate "binary" type, but since it's mapped to a "tinyblob", I get (under MySQL 4.1) the following error :



Is it a way to make hibernate create for me a "binary(16)" instead of an "tinyblob", so I could use it as my primary key ?

I tried without success to specified the length of the BLOB:



(by the way, I use an Hibernate v3.0)

Thanks in advance for your help,

So far I could only see 2 solutions:

- use a 16 length string: but since the underlying DB is in UTF-8 (for some other reason), it means my key will be 32 bytes long, which is twice larger than what I need.

- use a composite-id of 2 long to map my 16 bytes key.

Both solutions seems suboptimal too me, and performance is quite an issue in my case.

Any other ideas to map a 16 bytes values as an id ?