Message Title

Arnaud Thimel created an issue

HHH-9693

Issue Type:	Bug
Affects Versions:	4.2.18, 4.3.8
Assignee:	Unassigned
Components:	core
Created:	30/Mar/2015 06:09 AM
Environment:	Same issue using H2 1.3.x and 1.4.x
Priority:	Major
Reporter:	Arnaud Thimel

When type "text" is used for an entity, Hibernate uses the "longvarchar" SQL type.

Using H2 database, Hibernate cannot validate (even if Hibernate created the schema itself).

The error is such :

 
                                                    org.hibernate.HibernateException: Wrong column type in DB-1427720664171.PUBLIC.SOME_ENTITY for column name. Found: varchar, expected: longvarchar
	at org.hibernate.mapping.Table.validateColumns(Table.java:372)
	at org.hibernate.cfg.Configuration.validateSchema(Configuration.java:1338)
	at org.hibernate.tool.hbm2ddl.SchemaValidator.validate(SchemaValidator.java:175)

According to the H2Dialect, "longvarchar" should be used :

 
                                                    registerColumnType( Types.LONGVARCHAR, "longvarchar" );

Anyway, the type in H2 is :

 
                                                    varchar(2147483647)

I will attach a test case and patch proposal.

Add Comment

This message was sent by Atlassian JIRA