auto-increment portability issues ???

Discussions

General J2EE: auto-increment portability issues ???

  1. auto-increment portability issues ??? (1 messages)

    I am looking for a solution for generating primary keys and I am working with CMP. auto-increment looks very nice as it leaves it to the database, and particularly I would like the keys to be in order by transaction.

    Could anyone tell me which databases support this. I am working with postgres for our "out of the box" deployment but don't want to limit ourselfs to this.

    Also - which other App Servers besides JBoss are supporting this feature ??

    Any portability issues would be appreciated.

    Thanks in advance,
    Scott
  2. See Scott Ambler[ Go to top ]

    Check this out: http://www.agiledata.org/essays/dataModeling101.html

    Look at section 3.6 for some strategies.