How can Hibernate map the SQL data-type nvarchar(max)?

sql-server-2005 hibernate varchar nvarchar
ampersandre picture ampersandre · Jul 8, 2009 · Viewed 32.5k times · Source

I have a column in my SQL-2005 database that used to be a varchar(max), but it has been changed to an nvarchar(max).

Now I need to update my hibernate mapping file to reflect the change, and this is what it used to be:

<element type="text" column="Value"/>

When I try to run the application, the following error appears:

org.hibernate.HibernateException: Wrong column type in [Table] for column Value. Found: ntext, expected: text

What should I put in the 'type' attribute to correctly map the column as an nvarchar(max)?

I've tried setting the type to ntext, but hibernate didn't know what that was. I tried setting the type to string, but it treated string as a text type.

Answer

Vaal picture Vaal · Jun 27, 2012

What worked for me is to put the actual column definition in a @Column annotation:

    @Column(name="requestXml", columnDefinition = "ntext")
private String request;

Related questions

Cannot load JDBC driver class 'net.sourceforge.jtds.jdbc.Driver'

I have some problems with jtds. I'm using Hibernate, Tomcat 5.5 on Linux Red Hat Server, SQL Server 2005 with WIndows Server I save the library into Web-iNF/lib and i'm using the version jtds-1.2.2 I got the Error Message 16:56:17,561 ERROR JDBCExceptionReporter:78 …

Read More
Add a column with a default value to an existing table in SQL Server

How can I add a column with a default value to an existing table in SQL Server 2000 / SQL Server 2005?

Read More
Insert results of a stored procedure into a temporary table

How do I do a SELECT * INTO [temp table] FROM [stored procedure]? Not FROM [Table] and without defining [temp table]? Select all data from BusinessLine into tmpBusLine works fine. select * into tmpBusLine from BusinessLine I am trying the same, but …

Read More