0 Replies Latest reply on Jul 16, 2008 8:31 PM by tbessie

    Help! Want to auto-generate primary keys with EJB 2, CMP/MyS

    tbessie

      Hello all...

      I'm in a project porting from Weblogic/Oracle to JBoss/MySQL. We're sticking with EJB 2's for now.

      I did the Oracle -> MySQL part, and now am working on the Weblogic -> JBoss part.

      In migrating to MySQL, I changed use of Oracle SEQUENCE's to separate sequence tables. Weblogic supports generation of keys from these tables.

      However, it would seem that there is no built-in technique for auto-generating primary keys from specified tables in JBoss. Each primary key needs to have it's own counter (i.e. I can't generate them all from one place); I was thinking of using the 'entity-command' element, but that would require writing a class for each entity (or perhaps just one rather smart entity).

      Does anyone know if JBoss 4.2.2 can do what I want?

      - Tim