Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:


Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html



I have struggled for days getting a java.lang.Double filed mapped to oracle NUMBER type with precision 4 and scale 1.
I tried this:
<property name="validityAgreePercent" type="java.lang.Double">
<column name="ValidityAgreePercent" sql-type="NUMBER(4,1)" />
</property>
and

<property name="validityAgreePercent" type="double">
<column name="ValidityAgreePercent" sql-type="NUMBER(4,1)" />
</property>
and
<property name="validityAgreePercent" type="double">
<column name="ValidityAgreePercent" sql-type="NUMBER precision="4" and scale="1 " />

And over two dozen combinations.
None worked.

Does this validation have anything to do with jdbc driver?
My dialect is Oracle9Dialect.


I even tried big_decimal. It does not work either.
The same mapping works for sql-server where we have decimal in the database as a type.

Please help. I don't see any example.

I am bamming the wall right now.
</property>

NUMBER is not a SQL type. NUMERIC is tho.

I'm pretty sure that the sql-type refers to java.sql.Types constants. I would have thought that just <property ... type="big_decimal"> would work. What error messages are you getting?

I tried what you said as follows. No luck.
<property name="validityAgreePercent" type="big_decimal">
<column name="ValidityAgreePercent" />
</property>

org.hibernate.HibernateException: Wrong column type: ValidityAgreePercent, expected: decimal
at org.hibernate.mapping.Table.validateColumns(Table.java:205)
at org.hibernate.cfg.Configuration.validateSchema(Configuration.java:956)
at org.hibernate.tool.hbm2ddl.SchemaValidator.validate(SchemaValidator.java:116)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:299)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1145)
at com.pearson.resource.adapter.jmx.jboss.hibernate.HibernateSessionFactory.createSessionFactory(HibernateSessionFactory.java:220)
at com.pearson.resource.adapter.jmx.jboss.hibernate.HibernateSessionFactory.startService(HibernateSessionFactory.java:100)
at com.pearson.epen.service.SessionFactoryDeployer.addSessionFactoryForDatasource(SessionFactoryDeployer.java:91)
at com.pearson.epen.service.DataSourceListener$DeployerThread.deploySessionFactory(DataSourceListener.java:416)
at com.pearson.epen.service.DataSourceListener$DeployerThread.run(DataSourceListener.java:393)

Hi ryang5,

try

<property name="validityAgreePercent" type="double" column ="ValidityAgreePercent" />

Not sure .If dosen't work use java 5

Tried that before. Not working.
I guess this has something to do with Oracle
see this link
http://opensource.atlassian.com/project ... bOQfxnxq-f

I am surprised this has not been fixed.