[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - sequences and Long / long vs int / Integer

A DBA has created a sequence (Long type) and set a cap on its max value so it falls within the range of Integer. The PK column types are int; so, this all works fine for values; however.... EJB3 CMP tries to stuff the Long sequence into the setId(Integer id) and; of course, fails. Is there any way to get EJBs to work with this schema? Please don't suggest getting the dba's to change things. There is a business need to work with what they have. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3972306#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...