[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - msyql and postgresql - identity columns

[hanasakijiji]

how can the same ejb3 entity code be used with both MySQL and PostgreSQL on the primary keys (integers). 

The databases already exist - and cannot be modified
mysql is AUTO_INCREMENT
postgresql is SERIAL

It looks like Identity can be used with mysql but not postgresql?  Is the only way to fall back to table based sequences?

The below link was not much help...
http://www.hibernate.org/hib_docs/annotations/reference/en/html/entity.html#entity-mapping-identifier

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4023432#4023432

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4023432