aspose file tools*
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 Spring in Action this week in the Spring 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
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30764
    
156

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: 18662
    
    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?
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: An SQLException has occuredjava.sql.SQLException: Stream has already been closed