3.3.0 GA with MySQL 5.0 throws table validation exception

carlolf · **Posted:** Tue Aug 19, 2008 2:59 am

I just downloaded Hibernate 3.3.0 GA, installed it as library within my JBoss application and tried.

Sadly, it immediately throws an exception at application startup, when it does the schema validation.

Code:

org.hibernate.HibernateException: Wrong column type in dpjw.assessment for column NOTES. Found: text, expected: longtext

Comparing the sources I can see that someone set two java statements into comment. The 3.2 version of MySQLDialect.java looks like this:

Code:

   protected void registerVarcharTypes() {
      registerColumnType( Types.VARCHAR, "longtext" );
      registerColumnType( Types.VARCHAR, 16777215, "mediumtext" );
      registerColumnType( Types.VARCHAR, 65535, "text" );
      registerColumnType( Types.VARCHAR, 255, "varchar($l)" );
   }

while the new 3.3.0 version is this:

Code:

   protected void registerVarcharTypes() {
      registerColumnType( Types.VARCHAR, "longtext" );
//      registerColumnType( Types.VARCHAR, 16777215, "mediumtext" );
//      registerColumnType( Types.VARCHAR, 65535, "text" );
      registerColumnType( Types.VARCHAR, 255, "varchar($l)" );
   }

Can anyone of the committers explain why this was done? I effectively have some attributes in my tables where I want to save some text strings. I annotated the attributes with a maximum string length of 512 bytes and the former schema exporter correctly declared this attribute as

Code:

NOTES text,

So, what of this?

carlolf · **Posted:** Wed Aug 20, 2008 7:50 am

I made an entry into JIRA:

http://opensource.atlassian.com/project ... e/HHH-3440

mihaela · **Joined:** Tue Mar 23, 2010 10:00 am **Posts:** 6

3.3.1 GA also does this, as stated already somewhere...

This matter was not addressed yet? I downloaded hibernate from jboss maven 2 repository today and have this problem.

Somebody was complaining somewhere that those lines were not supposed to be commented out. Is it a bug then?

Does anybody know a solution to this?

memran · **Joined:** Fri Oct 07, 2011 10:06 am **Posts:** 3

This issue still exists in 3.6.6.

Please can someone explain the reasons as to why those lines were commented out?

roblight · **Joined:** Fri May 01, 2009 3:15 pm **Posts:** 3

I came across this topic from:

http://stackoverflow.com/questions/6587 ... text-field

Because I'm seeing this problem with Grails 2.0.1 which I think uses Hibernate 3.6.7.Final.

I'd also like to know why this is still an issue.