Re: ORA-01013

From: rocco <roccodalto_at_tiscalinet.it>
Date: Wed, 24 Jan 2001 17:48:35 +0100
Message-ID: <3A6F0763.B3B05B19_at_tiscalinet.it>


[Quoted] Hi AlexV

I' m working with jrun 2.3.3 Servlet engine. JRun 's working in Single Thread Mode and the InitPoolSize (connection to DB ) is 6.
[Quoted] I have 6-20 access per hour on my server , do you think I have to rise the InitPoolSize parameter ??
Bye
deja2alex_at_my-deja.com wrote:

> <ora-docs>
> ORA-01013 user requested cancel of current operation
>
> Cause: The user interrupted an Oracle operation by entering CTRL-C,
> Control-C, or another canceling operation. This forces the current
> operation to end. This is an informational message only.
>
> Action: Continue with the next operation.
> </ora-docs>
>
> just guessing...
>
> this may happend if you have rather long (may be >15-60 sec)
> sql request than web-server is timeout and send "cancel"
> signal to database. Also you can check your sql query
> if there is unusual characters there. Or may be some
> other threads are trying to use the same connection or
> statement object...
>
> AlexV
>
> In article <3A6EE545.A8694043_at_tiscalinet.it>,
> rocco <roccodalto_at_tiscalinet.it> wrote:
> >
> > --------------36F19AEC8D900F4D92987833
> > Content-Type: text/plain; charset=us-ascii
> > Content-Transfer-Encoding: 7bit
> >
> > Hi
> > I have this problem
> > during the esecution of some query (via jdbc) I have this error
> >
> > java.sql.SQLException: ORA-01013: user requested cancel of current
> > operation.
> >
> > I didn't request cancel of current operation.
> > My oracle server is ORACLE 8.0.5.0 and I use driver JDBC
 classes111.zip
> > (year 1999).
> > Can you help me ??
> > thanks rocco
> >
> > dalto_at_mail.eng.it
> >
> > --------------36F19AEC8D900F4D92987833
> > Content-Type: text/html; charset=us-ascii
> > Content-Transfer-Encoding: 7bit
> >
> > <!doctype html public "-//w3c//dtd html 4.0 transitional//en">
> > <html>
> > Hi
> > <br>I have this problem
> > <br>during the esecution of some query (via jdbc) I have this error
> > <p><b>java.sql.SQLException: ORA-01013: user requested cancel of
 current
> > operation.</b>
> > <p>I didn't request cancel of current operation.
> > <br>My oracle server is <b>ORACLE 8.0.5.0</b> and I use driver JDBC<b>
> > classes111.zip</b> (year 1999).
> > <br>Can you help me ??
> > <br>thanks rocco
> > <p>dalto_at_mail.eng.it
> > <br>&nbsp;
> > <br><b></b>&nbsp;
> > <br>&nbsp;</html>
> >
> > --------------36F19AEC8D900F4D92987833--
> >
> >
>
> Sent via Deja.com
> http://www.deja.com/
Received on Wed Jan 24 2001 - 17:48:35 CET

Original text of this message