I've always used the AUTO_PK_SUPPORT approach to PK generation, all the way back from WebObject EOF days many many years ago.
However a recently discovered bug in this approach [1] and how it intersects with transactions may require use to think about going over to database generated primary keys with a auto-increment column. For developers not using an ORM this is pretty common I understand. What are the downsides to that approach? Is performance, reliability and everything else just the same? What problem was AUTO_PK_SUPPORT originally designed to solve? Cheers Ari [1] https://issues.apache.org/jira/browse/CAY-2040 -- --------------------------> Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A
