[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Mapping relationship where database ID's are different forma

I'm trying to map a OneToOne relationship in a legacy database. The problem I have is that I keep getting the following error: javax.persistence.PersistenceException: org.hibernate.HibernateException: Wrong column type: LocationID, expected: tinyint | at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:737) | at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:127) | at org.jboss.ejb3.entity.PersistenceUnitDeployment.start(PersistenceUnitDeployment.java:246) | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)... My entity beans are setup as follows: @Entity | @Table(name="tblAccountManager") | public class AccountManager implements Serializable { | | ... | | @OneToOne | @JoinColumn(name="LocationID") | private Branch branch; @Entity | @Table(name="web_location") | @Name("Branch") | public class Branch implements Serializable { | | private static final long serialVersionUID = -7280892867401735383L; | | @Id @GeneratedValue | @Column(name = "Loc_ID") | @org.hibernate.annotations.Type(type = "custom.hibernate.IntegerToByteUserType") | private Integer id; I guess the problem is that in the database tblAccountManager.LocationID is an int(11) where as web_location.Loc_ID is a tinyint(3). Is there any way to map this setup with annotations and without changing the database? View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4096895#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...