Hibernate version: 3.3.0.CR2

Annotations version: 3.4.0.CR2

Name and version of the database you are using: DB2 v8.1.16.429


Hi,

I am trying to store a file in the database. I am using Hibernate Annotations and read the file into a byte array which I annotated with @Lob :



This all works pretty well if I create the database table by myself. If I use the schema export feature, the Blob column in the database is only 255 byte long which is not enough for me.

So I wonder if there is a way to tell Hibernate through Annotations how large the maximum size of the byte array (and so the db column) should be, or maybe any other workaround other than changing the column afterwards by hand.
Would spare me some time/nerves during development.

Thanks in advance.



EDIT:
I just found the solution by myself.



does the trick for me. It creates a blob column which can store up to 20 MB of data.

Sorry for this senseless topic. :)

Me again.

I just got another problem now:

I want to set the Blob size to the maximum possible in DB2, which is 2 GB.
Unfortunatly, the @Column(length) - field only takes int as argument, and 2 GB in bytes is too large to be stored in an integer.

What i would need is something like this:



The above code doesnt work and btw leads to a pretty creepy bug in eclipse, which prevents you from opening the file again after saving.


Is there any other way to do that?

Thanks in advance.