Re: Wait event SQL*Net break/reset to client caused by duplicate insert?
- From: amit poddar <amit.poddar@xxxxxxxx>
- To: pjhoraclel@xxxxxxxxx
- 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
amit
Peter Hitchman wrote:
Hi,
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?
--
http://www.freelists.org/webpage/oracle-l
- References:
- Wait event SQL*Net break/reset to client caused by duplicate insert?
- From: Peter Hitchman
- RE: Wait event SQL*Net break/reset to client caused by duplicate insert?
- From: Tanel Poder
- Re: Wait event SQL*Net break/reset to client caused by duplicate insert?
- From: Peter Hitchman
- Re: Wait event SQL*Net break/reset to client caused by duplicate insert?
- From: Peter Hitchman
Other related posts:
- » Wait event SQL*Net break/reset to client caused by duplicate insert?
- » RE: Wait event SQL*Net break/reset to client caused by duplicate insert?
- » RE: Wait event SQL*Net break/reset to client caused by duplicate insert?
- » Re: Wait event SQL*Net break/reset to client caused by duplicate insert?
- » Re: Wait event SQL*Net break/reset to client caused by duplicate insert?
- » Re: Wait event SQL*Net break/reset to client caused by duplicate insert?
- » Re: Wait event SQL*Net break/reset to client caused by duplicate insert?
- » RE: Wait event SQL*Net break/reset to client caused by duplicate insert?
Hi, 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?
- Wait event SQL*Net break/reset to client caused by duplicate insert?
- From: Peter Hitchman
- RE: Wait event SQL*Net break/reset to client caused by duplicate insert?
- From: Tanel Poder
- Re: Wait event SQL*Net break/reset to client caused by duplicate insert?
- From: Peter Hitchman
- Re: Wait event SQL*Net break/reset to client caused by duplicate insert?
- From: Peter Hitchman