Re: [Hibernate] hibernate type mapping and JPA

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

Nevermind,

We found out we need to subclass the MySQLDialect class we're using and 
manipulate the type mapping over there...

Thx,

Lieven

Lieven Doclo schreef:
> 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
> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/