[Hibernate-JIRA] Commented: (HHH-1008) SchemaValidator mapping of double to SQL-Type DECIMAL with Precision and Scale

Monday, 9 November 2009

    [
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1008?page=c...
] 

Julien HENRY commented on HHH-1008:
-----------------------------------

Same problem for me with Oracle 9i and Hibernate 3.5.0-Beta-2:

Mapping is:
    @Column(name="DATE_STRUC", precision=6, scale=3)
    private Double dateStructure;

SQL Type in DB is NUMBER(6,3)

Hibernate validation fails with:

 org.hibernate.HibernateException: Wrong column type in S3.DECOM for column DATE_STRUC.
Found: number, expected: double precision
	at org.hibernate.mapping.Table.validateColumns(Table.java:284)
[hibernate-core-3.5.0-Beta-2.jar:3.5.0-Beta-2]
	at org.hibernate.cfg.Configuration.validateSchema(Configuration.java:1156)
[hibernate-core-3.5.0-Beta-2.jar:3.5.0-Beta-2]
	at org.hibernate.tool.hbm2ddl.SchemaValidator.validate(SchemaValidator.java:139)
[hibernate-core-3.5.0-Beta-2.jar:3.5.0-Beta-2]
	at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:364)
[hibernate-core-3.5.0-Beta-2.jar:3.5.0-Beta-2]
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1367)
[hibernate-core-3.5.0-Beta-2.jar:3.5.0-Beta-2]
	at
org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:858)
[hibernate-annotations-3.5.0-Beta-2.jar:3.5.0-Beta-2]
	at
org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:733)
[hibernate-entitymanager-3.5.0-Beta-2.jar:3.5.0-Beta-2]

...
 SchemaValidator mapping of double to SQL-Type DECIMAL with Precision
and Scale
 ------------------------------------------------------------------------------

                 Key: HHH-1008
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1008
             Project: Hibernate Core
          Issue Type: Improvement
          Components: core
    Affects Versions: 3.1 beta 2
         Environment: DB2, Win2k
            Reporter: Phritz Grau
            Assignee: Diego Plentz
            Priority: Minor
   Original Estimate: 1 hour
  Remaining Estimate: 1 hour

 I am using the new SchemaValidator, it really is very useful. 1000x thanks.
 However we have one problem.
 Our tables contain a lot columns of SQL-Type DECIMAL with precision and scale.
 These are mapped to double or java.lang.Double and
 we specify the mapping like e.g.:
         <property
             name="doubleVal"
             type="double">
             <column name="dVal" precision="12"
scale="6"/>
         </property>
 Using the SchemaValidator results in an error:
 org.hibernate.HibernateException: Wrong column type: dVal, expected: double
 	at org.hibernate.mapping.Table.validateColumns(Table.java:205)
 	at org.hibernate.cfg.Configuration.validateSchema(Configuration.java:938)
 Since there is not appropriate java type for sql type decimal,
 it would be very nice if the above error is omittet,
 when the mapping contains the correct precision and scale
 values. 
-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006