Hi My app is Spring with JPA/Hibernate supports multiple databases.

for columns with @Lob type, hbm2dll generates a default 255 byte clob/blob size for DB2. Other dialect does not have the size generated

Because of this behavior, I have to annotated explicitly the size

@Lob @Column ( length = somefix number )

other dialects do ingnore the specified length during hbm2dll export.

Is this an intended for DB2? I found very odd to specify the length
since I dont know how big it could be at runtime

Thanks

-D

Here is the answer in case any one needs it.

Among supported databases, DB2 and Derby ( DB2Dialect) support
settings of blob/clob size. The default for DB2 is 1M, max is 1G.

Without setting the size, hibernate will set it to 256 bytes. Should Hibernate use DB2 default size instead rather create its own default?

In my case, I set all @Lob's length to 1M to make DB2/Derby happy.
The length is ignored by other dialects