What database are you using? I know a lot of the major databases have "REPLACE" functionality, which would insert or update based on a key.
-J On 7/22/06, Brandon Goodin <[EMAIL PROTECTED]> wrote:
Yes you would have to check the nested exceptions to see if a SQL exception exists. Brandon On 7/22/06, Edwin Lukaweski < [EMAIL PROTECTED]> wrote: > > > > Thank you for the answer. > > 1) I am already commited to iBatis DAO. So, I cannot switch to Spring > > 2) I realize that I could do a SELECT first, but I am trying to optimize resources so it is best to handle the pre-existance on an exception basis. > > 3) Do I have to crawl down the exception chain, from daoexception, to find the SQLException? > > Thanks, > > Edwin > > > > ----- Original Message ----- > From: Brandon Goodin > To: [email protected] > Sent: Saturday, July 22, 2006 4:11 PM > Subject: Re: insert sql exception how to > > If you are just starting into this project I would recommend that you use Spring for your DAO factory. As far as SQL Exceptions you can use the getErrorCode to interpret what error it is. This will not be cross-database compatible. You could simply avoid the SQLException by performing a simple select on the database before you insert. If you have the ID then you make your change. If you don't have the ID you go ahead and update. > > Brandon > > > On 7/22/06, Edwin Lukaweski <[EMAIL PROTECTED]> wrote: > > > > > > > > Hi: > > > > I need some hints as to how to handle a situation with iBatis. > > > > I would like to perform an INSERT, then catch the sqlexception and determine if it is caused by a duplicate key. If so, I will want to perform an UPDATE to the record. > > > > I realize that DAO throws a daoexception, but I am not quite sure how to handle it. > > > > Does anybody have any ideas? > > > > Thanks in advance, > > Edwin > > > > >
