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
