On 12/4/14 2:26 AM, John English wrote:
> On 02/12/2014 00:30, Rick Hillegas wrote:
>> On 12/1/14 4:08 AM, John English wrote:
>>> However, why not in any case consider deriving a separate subclass of
>>> SQLException for the duplicate key case? It wouldn't break any
>>> existing code,
>>> it's presumably easy to identify the code sites which should throw
>>> it, and it
>>> would clarify exception handling in some cases.
>> Hi John,
>>
>> Note that the SQLException which is thrown is already a refined
>> subclass of
>> SQLException. The failed insert will throw a
>> java.sql.SQLIntegrityConstraintViolationException. That may help you
>> code this
>> approach to the problem.
>
> But wouldn't this also be thrown by other causes such as a check
> constraint or foreign key violation? In such cases, an "if" statement
> would still be needed to check the actual cause.
Hi John,
Yes, that's true. You're welcome to log an enhancement request for this
behavior.
Regards,
-Rick
|