This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes  An SQLException has occuredjava.sql.SQLException: Stream has already been closed Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark " An SQLException has occuredjava.sql.SQLException: Stream has already been closed" Watch " An SQLException has occuredjava.sql.SQLException: Stream has already been closed" New topic
Author

An SQLException has occuredjava.sql.SQLException: Stream has already been closed

Ravindra Nandyala
Greenhorn

Joined: Jun 17, 2008
Posts: 7
Hi All

I am trying to read LONG RAW data type from database and doing some computation on it. But I get this error

when it processes LONG or LONG RAW data type. I have read in forum it occurs when Data is not processed in the same order in which it is fetched. I am processing the data in the same order in which it is fetched yet I am getting this error. Can somebody please help.


Ravindra Nandyala
Greenhorn

Joined: Jun 17, 2008
Posts: 7
Any reply will be highly appreciated
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30070
    
149

Ravindra,
I'm thinking you aren't getting an answer because the amount of code is overwhelming.

Two things you can do to help:
1) What line is the error occuring on?
2) What's the smallest possible example that show the error. Can you get rid of the BLOB conditional and still have the error? The CLOB conditional? Etc.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Ravindra Nandyala
Greenhorn

Joined: Jun 17, 2008
Posts: 7
Here is the code. and I get an error Stream has already been closed on the line that is made bold. please suggest how should htis be fixed.

Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

There's a lot of Oracle-specific things in that code. I'm sorry if this doesn't seem helpful, but why don't I move the post to the Oracle forum?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: An SQLException has occuredjava.sql.SQLException: Stream has already been closed
 
Similar Threads
Blob Clob
Support localization in CLOB file in DB through Java
PKCS7 BouncyCastle encrypt / decrypt with CMSDataEnveloppe dont work ?
CheckSum for RAW datatype.
Out of Memory error