I developed a custom servlet that uses the oracle classes12.zip class file which works
well with Jrun when I set the classpath.
I am having problems running it on Tom Cat 3.2.1. It might be that the zip file is not
recodnised. I looked for a download of a Jar file from oracle but could not find one.
I unzipped the classes12.zip and the program worked but oviously this is not how it
must work. How can I solve this problem or how can I get a Jar file? I am not even
sure if this is the problem.
Any help is appreciated.
Thanks
>>> [EMAIL PROTECTED] 01/17/01 08:25PM >>>
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]
**********************************************************************
Any unauthorized use and interception of this e-mail is illegal.
If this e-mail is not intended for you, you may not copy,
distribute or disclose the contents to anyone. This e-mail
does not give rise to any binding legal obligations upon the
City of Cape Town unless the City of Cape Town subsequently
confirms the content in writing non-electronically. This e-mail
may be confidential, legally privileged or otherwise protected
by law. Unauthorised disclosure or copying of any or all of it
may be unlawful. If you receive this e-mail in error please notify
the sender and delete the message
**********************************************************************
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
