I have a problem with tinyblob, blob and longblob.

@Column(name="XXXX", unique=false, nullable=false, insertable=true, updatable=true)
@Lob(type = LobType.BLOB)
public byte[] getXXXX() {
return this.XXXX;
}

The validator says it has to be a blob, but a longblob it is still the same in mysql, is any workaround for this?

I am using <property name="hibernate.hbm2ddl.auto" value="validate"/> in the persistence.xml, maybe the workaroung could be there...

It is not the only problem I have with the mapping, tinyint vs bit for booleans are a lower issue too.

Thanks!

Hibernate version:EJB3 included in JBoss [Zion] 4.0.3 (build: CVSTag=JBoss_4_0_3 date=200510042341)

Full stack trace of any exception that occurs:
10:46:27,062 WARN [ServiceController] Problem creating service jboss.j2ee:service=EJB3,module=PAR.par
org.hibernate.HibernateException: Wrong column type:XXXXX, expected: blob
at org.hibernate.mapping.Table.validateColumns(Table.java:205)
at org.hibernate.cfg.Configuration.validateSchema(Configuration.java:938)


Name and version of the database you are using:MySql 5.0.18

open a JIRA issue with a test case please

Running this with LongBlob returns:
System.out.println(metadata.getColumnClassName(result.findColumn("ACCEPT_COOKIE")));
System.out.println(metadata.getColumnDisplaySize(result.findColumn("ACCEPT_COOKIE")));
System.out.println(metadata.getColumnLabel(result.findColumn("ACCEPT_COOKIE")));
System.out.println(metadata.getColumnName(result.findColumn("ACCEPT_COOKIE")));
System.out.println(metadata.getColumnType(result.findColumn("ACCEPT_COOKIE")));
System.out.println(metadata.getColumnTypeName(result.findColumn("ACCEPT_COOKIE")));
System.out.println(metadata.getColumnCharacterEncoding(result.findColumn("ACCEPT_COOKIE")));
System.out.println(metadata.getColumnCharacterSet(result.findColumn("ACCEPT_COOKIE")));
-------
[B
2147483647
ACCEPT_COOKIE
ACCEPT_COOKIE
-4
LONGBLOB
null
US-ASCII
------
With Blob returns:
-----
[B
65535
ACCEPT_COOKIE
ACCEPT_COOKIE
-4
BLOB
null
US-ASCII


Is that ok?