Re: ORA-01013

From: <deja2alex_at_my-deja.com>
Date: Wed, 24 Jan 2001 17:29:35 GMT
Message-ID: <94n3dh$ehg$1_at_nnrp1.deja.com>


sorry, again only guessing:

--something wrong with connection pool, regular cleanning procedure, non-synchronized methods checking if connection are alive, wrong or unpreductable behaviour when there are more than 6 simultanous request...

  • customer presses submit button 2 times, and that somehow causes wrong behaviour...
  • only experiment will tell you if increasing init number helps....

AlexV

In article <3A6F0763.B3B05B19_at_tiscalinet.it>,   rocco <roccodalto_at_tiscalinet.it> wrote:
> 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.
> 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/
>
>

Sent via Deja.com
http://www.deja.com/ Received on Wed Jan 24 2001 - 18:29:35 CET

Original text of this message