Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.0.5

Name and version of the database you are using: Microsoft SQLServer 2000

One of the properties in my class is expected to contain big String data. My mapping is @hibernate.property column="PDT_DESCRIPTION" length="32767" not-null="false"

The schema export generates "PDT_DESCRIPTION varchar(32767)".

But the max value I can give in SQL Server is 8000 and thus throws an error when I use this script.

However, when I generate schema for MySql, it works perfectly as it generates the type as text.

Is this a defect? I saw something similar at http://forum.hibernate.org/viewtopic.php?t=933683%3C/a. The problem here seems to be with varbinary and it looks as if it was fixed pre 3.0.

Can someone tell me if I'm doing something wrong or is it a defect with hibernate.


Thanks in advance for help.