Re: RE: [JBoss-dev] Autogenerated primary keys etc

2002-01-14 Thread Lennart Petersson
Ok, what i was looking for to hear about was the ability to support different databases auto-generated columns. I see the problem with it, just wanted to check if anyone had give it a try for some of the most popular databases... Guess i will wait for JDBC 3.0 :) /Lennart Den 2002-01-11

RE: RE: [JBoss-dev] Autogenerated primary keys etc

2002-01-14 Thread Dain Sundstrom
] Autogenerated primary keys etc Ok, what i was looking for to hear about was the ability to support different databases auto-generated columns. I see the problem with it, just wanted to check if anyone had give it a try for some of the most popular databases... Guess i will wait for JDBC 3.0

Re: RE: [JBoss-dev] Autogenerated primary keys etc

2002-01-14 Thread Lennart Petersson
Sound like a fucking stupid dummy question, but what the hell... What is having the best performance? 1) To let the DB generate next key using some kind of IDENTITY/SEQUENCE function? 2) To do like we do today and many others i guess, something like the HIGH/LOW key generator in Castor. We have