[Hibernate] hibernate type mapping and JPA

[Lieven D. <ld...@sc...>]

Hi guys,

Does anyone of you know how to manipulate the type mapping system in 
Hibernate when it comes to auto-ddl'ing persistent classes?

My problem exists in the mapping of boolean types with Hibernate to 
MySQL. It maps the boolean type to BIT(1). Due to some factors (one of 
which is the annoying MySQL console problem with the BIT datatype) we 
need to use TINYINT(1) (or BOOLEAN, which is an alias for that type).

You can probably annotate each property with 
@Column(columnDefinition="TINYINT(1)"), but that's an option we'd rather 
not use... Is there a way to manipulate how Hibernate maps boolean type, 
e.g. java.lang.Boolean = TINYINT(1) instead of java.lang.Boolean = BIT?

Kind regards,

Lieven DOCLO