Eric:
I've never experienced that problem exactly, but you might need newer
Oracle JDBC drivers. There is a classes12.jar which is what we use.
Don't know if that will solve the problem, but it's worth a shot.
And for what it's worth, there's a serious bug in the Oracle drivers.
NEVER call Statement.setQueryTimeout() - If the query returns within the
time set, the thread will go to sleep and become a zombie . .. banged my
head against a wall for quite some time before I figured that one out.
:)
Good luck.
Eric Weber wrote:
>
> Hi
>
> I try to get a BLOB from an oracle database and to save it to a file.
> >From a small test program everything works fine. When I copy the code
> into a servlet I get a strange error from the database at the moment
> when I try to read the first byte on the InputStream:
>
> java.io.IOException: ORA-01013: user requested cancel of current
> operation
> at oracle.jdbc.dbaccess.DBError.SQLToIOException(DBError.java)
> at
> oracle.jdbc.driver.OracleBlobInputStream.needBytes(OracleBlobInputStream.java)
> at
> oracle.jdbc.driver.OracleBufferedStream.read(OracleBufferedStream.java)
> at
> oracle.jdbc.driver.OracleBufferedStream.read(OracleBufferedStream.java)
> at lib.download.service(download.java:60)
> at
> org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
> at
> org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:597)
> at
> org.apache.tomcat.servlets.InvokerServlet.service(InvokerServlet.java:257)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
> at
> org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)
> at
>
>org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:160)
> at
> org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338)
> at java.lang.Thread.run(Thread.java:484)
>
> The JDBC connection works fine for Varchar and other "normal" data from
> the database.
>
> I saw in the archive that somebody had a similar problem, but I couldn't
> find any answer to the problem.
>
> I use Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.0_01)
> and Oracle8i Enterprise Edition Release 8.1.5.0.0. with the thin
> driver(classes111.zip) from oracle.
> I use Tomcat 3.1.
>
> Does anybody have an idea about this problem?
>
> ERic
--
Geoff Lane <[EMAIL PROTECTED]>
(650) 969-5000 x104
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
