Hi,

I have the EJB 4th edition. I bought this book to learn a bit more about EJB's. I've setted up a JBoss 4 environment with CMP beans that interacts with MySQL.

I want to create an application CMP EJB's and Servlets but I want to be independent of my database version (MySql, Oracle, Ms SQL server, ?). So I only want to change my datasource xml file, when a client choose to work with an other database, than the one we standard deliver.

I'm now struggling with the auto increment option. As readed on P.618 "JBoss CMP does have automatic primary-key generation". But unfortunately I can't find a more detailed way how to set up the automatic primary-key generation functions.

If somebody know how to create database independent auto increment function. Please spread it to the world.

Pieter