Re: Wait event SQL*Net break/reset to client caused by duplicate insert?
Date: Thu, 10 Apr 2008 07:39:18 -0400
The exception should not be propagated to the client to avoid this event. That would mean the exception needs to be handled on the database which can only happen in a PLSQL block.
Handling exception in java means the exception is propagated to the client and hence the wait event
Peter Hitchman wrote:
> Just to follow up, having read your Blog entry ...
> The java code is handling the exception, so is there a difference in
> the way this event gets fired between a java JDBC programme and server
> side PL/SQL code, because of the client/server nature of the java?