What are the best workarounds for known problems with Hibernate's schema validation of floating poin

Posted by Jason Novak on Stack Overflow See other posts from Stack Overflow or by Jason Novak
Published on 2010-04-12T21:28:54Z Indexed on 2010/04/12 21:33 UTC
Read the original article Hit count: 320

Filed under:
|

I have several Java classes with double fields that I am persisting via Hibernate. For example, I have

@Entity
public class Node ...

  private double value;

When Hibernate's org.hibernate.dialect.Oracle10gDialect creates the DDL for the Node table, it maps the value field to a "double precision" type.

create table MDB.Node (... value double precision not null, ...

It would appear that in Oracle, "double precision" is an alias for "float". So, when I try to verify the database schema using the org.hibernate.cfg.AnnotationConfiguration.validateSchema() method, Oracle appears to describe the value column as a "float". This causes Hibernate to throw the following Exception

org.hibernate.HibernateException: Wrong column type in DBO.ACL_RULE for column value. Found: float, expected: double precision

A very similar problem is listed in Hibernate's JIRA database as HHH-1961 (http://opensource.atlassian.com/projects/hibernate/browse/HHH-1961). I'd like to avoid doing anything that will break MySql, Postgres, and Sql Server support so extending the Oracle10gDialect appears to be the most promising of the workarounds mentioned in HHH-1961. But extending a Dialect is something I've never done before and I'm afraid there may be some nasty gotchas. What is the best workaround for this problem that won't break our compatibility with MySql, Postgres, and Sql Server?

Thanks for taking the time to look at this!

© Stack Overflow or respective owner

Related posts about hibernate

Related posts about Oracle