Hi,

I am using Hibernate Annotations together with PostgreSql 8.1. The DB-Entities are created or updated with hibernate.hbm2ddl.auto=update.

My problem is that I want to create a varchar-field with no length limitation (just type varchar), but if I do not use the length attribute of @column in my persistent class, Hibernate creates a varchar with default length of 255.

I do not want to use the length attribute as I do not know how much text there will be to store - and if I set length to a rather high value (e.g. 10000000), PostgreSql allocates exactly that amount of diskspace - and I would like to avoid that but rather have it in a more dynamic way (=> varchar)

Any help is welcome!


Regards,
Karsten

Hi,

have you tried the @Lob annotation? For postgres this will map to the 'text' column type which might be what you want.

--hardy

That seems to do it as well,
thank you!