Try and Catch Duplicate Key

(0) Share

Report

Posted on by Community Member

Hi all,

When inserting a record using Try and Catch, can I write like this :

Try
{
    table........ // assign fields
    table.insert();
}
catch (Exception::DuplicateKeyExecption)
{
}

So it is just empty bracket for the "Catch", so its like I don't want the error message of Duplicate key to show up, it's just continue with no insert... and move on.

Bte what is Exception::DuplicateKeyExceptionNoReceovered means ? and the different with the one I used above.

Thanks,

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

vinitgoyal2005 6,332 on at

Like (0)

Report
Hi,

Look at docs.microsoft.com/.../xpp-exceptions for the difference.

As a best practice I would use

if(table.ValidateWrite()) { table.insert(); }

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Vinit,

Yes, I read that, but still not understand. What does it meant (the NotRecovered) cannot caught inside transaction ? means if we're using ttsbegin/ttscommit, it is useless to use that ?

and more important is actually can I do what I just written ? by just make it empty.

Thanks,

Was this reply helpful? Yes No
udaY-ch 5,133 on at

Like (0)

Report

Hi,

Check this out,

catch(Exception::DuplicateKeyException)
{
// retry in case of an duplicate key conflict
if (appl.ttsLevel() == 0)
{
if (xSession::currentRetryCount() >= #RetryNum)
{
throw Exception::DuplicateKeyExceptionNotRecovered;
}
else
{
retry;
}
}
else
{
throw Exception::DuplicateKeyException;
}
}

I can use rich formatting- sorry

Uday.

Was this reply helpful? Yes No
udaY-ch 5,133 on at

Like (0)

Report
Hi,

Check this out,

catch(Exception::DuplicateKeyException) { // retry in case of an duplicate key conflict if (appl.ttsLevel() == 0) { if (xSession::currentRetryCount() >= #RetryNum) { throw Exception::DuplicateKeyExceptionNotRecovered; } else { retry; } } else { throw Exception::DuplicateKeyException; } }

Uday.

Was this reply helpful? Yes No
Verified answer

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

If your insert operation is violating primary key of the table the duplicate exception is going to be thrown anyways , you can not avoid that and keep continue your insert operation. Why cant you check if the record with the same key exist or not and avoid error instead of trying to suppress the error message and let exception handling everything for you.

Was this reply helpful? Yes No
Suggested answer

vinitgoyal2005 6,332 on at

Like (0)

Report

Hi,

Inside catch(DuplicateKeyException) you can write Retry then system will try to insert the record again with the retry count set which is usually 5(I think). but if it fails for all 5 times then exception is caught by DuplicateKeyExceptionNotRecovered and then you need to take appropriate action on it if any.

For your scenario correct way would be like below:

if(!testTable::exists(key))

{

testTable.insert();

}

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

If you are running it in a loop and want to insert other records after the current record fails write continue in the catch else write retry.

Was this reply helpful? Yes No