[jboss-user] [EJB 3.0] - Type mapping problem with Decimal on DB2/400

I'm trying to manage a table on an DB2/400 with a EJB3 entity bean but Hibernate failes to correctly map the database data type to a data type in the entity bean. The column type is defined as follows: | PREIS DECIMAL(12,5) | When I define the getter like | @Column(name = "PREIS", precision = 13, scale = 5) | public BigDecimal getPreis() {... | I get the following error: | javax.persistence.PersistenceException: org.hibernate.HibernateException: Wrong column type: PREIS, expected: numeric(13,5) | at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:720) | at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:127) | ... | I've tried to fix the problem by changing the annotation like: | @Column(name = "PREIS", columnDefinition = "DECIMAL(13,5)") | The result of this attempt was: | javax.persistence.PersistenceException: org.hibernate.HibernateException: Wrong column type: PREIS, expected: DECIMAL(13,5) | at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:720) | at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:127) | ... | I've also tried to combie the annotation attributes like this: | @Column(name = "PREIS", columnDefinition = "DECIMAL(13,5)", precision = 13, scale = 5, nullable = true) | but the result stays the same. Any suggestions deeply appreciated! View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4060830#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...