Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp
Hibernate version:
3.2.6.ga
Mapping documents:
Code:
@Entity(name = "edd_inkaartonderzoek")
@PrimaryKeyJoinColumn(name = "formulier_id")
@Proxy(lazy = true)
@VraagElement(displayName = "Inkaartonderzoek")
@Cache(usage = CacheConcurrencyStrategy.NONSTRICT_READ_WRITE, region = "zorgportaal.cache")
public class InkaartOnderzoekVulling extends OnderzoekVulling
{
(...)
public Double alat;
(...)
}
Full stack trace of any exception that occurs:Code:
org.hibernate.HibernateException: Wrong column type in ZORGPORTAAL.EDD_INKAARTONDERZOEK for column alat. Found: float, expected: double precision
at org.hibernate.mapping.Table.validateColumns(Table.java:261)
at org.hibernate.cfg.Configuration.validateSchema(Configuration.java:1089)
at nl.topicuszorg.hibernate.spring.dao.impl.HibernateServiceImpl.validateSchema(HibernateServiceImpl.java:342)
Name and version of the database you are using:Oracle 10g
The generated SQL (show_sql=true):creation:
Code:
create table edd_inkaartonderzoek (
formulier_id number(19,0) not null,
alat double precision,
(...)
It seems columns created as 'double precision' in Oracle are actually added as floats. Should the validator be modified to accept 'float' metadata for 'double precision' columns when the Dialect is Oracle? Or is there some other solution?