handling duplicate key in a database independent manner?

sudhirsrinivasan · **Joined:** Sat Mar 06, 2004 3:55 pm **Posts:** 3

With hibernate is there any way to handle duplicate keys without getting database specific. Right now, the only way is to get the SqlException database specific error code . or check for duplicates before inserting which will result in multiple round trips.
thanks -sudhir

christian · **Posted:** Sat Mar 20, 2004 11:51 am

Use surrogate keys.

sudhirsrinivasan · **Joined:** Sat Mar 06, 2004 3:55 pm **Posts:** 3

im sorry i didnt make myself clear.
i mean duplicate key exception..
if i have a unique key, and during insertion if it generates a duplicate key exception, is there a database independent way of doing it.
-sudhir

emmanuel · **Posted:** Wed Mar 24, 2004 6:57 pm

Unfortunatly no. Search the forum for some discussion on that.