On 10-2-2012 17:48, bigmarcman2000 wrote:

> In my current project, I'm developing a middelware, using an SQL database as persistence. I try to support many different databases and like to keep the code as common as possible. (That's why I try not to add procedures and triggers)

If you look at ORM libraries like Hibernate, they use the strategy
pattern to create IDs. Where depending on the features of a database or
performance characteristics, you select a different strategy. See
section 5.1.2.2 in
http://docs.jboss.org/hibernate/core/4.0/manual/en-US/html/mapping.html#mapping-declaration-id

Mark
--
Mark Rotteveel