This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Java Interview Guide and have Anthony DePalma on-line!
See this thread for details.
The moose likes EJB and other Java EE Technologies and the fly likes EJB and Oracle LONG converting problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "EJB and Oracle LONG converting problem" Watch "EJB and Oracle LONG converting problem" New topic

EJB and Oracle LONG converting problem

Kjartan Aanestad

Joined: Aug 22, 2001
Posts: 7
I am running VAJ and WebSphere together with Oracle 8.1.6 database. I have defined a CMP bean that has a field of type String. This field is mapped to a column of datatype LONG in the Oracle database.
When I call a finder method on this CMP Bean I get an Enumerator
Exception whenever the number of rows that the finder is supposed to return exceeds five. The Exception text is as follows:
original exception: ;
nested exception is: java.sql.SQLException: Stream has already been closed
I am using the VapAsciiStreamToStringConverter.
I read that this SQLException indicates that when reading a LONG column from the database, a binding error occurs due to that the stream have been read in the wrong order. As far as I am concerned it is reading the stream in the correct order, but I might have missed something..
I have seen similar problems posted in newsgroups but I have never seen anyone with an answer to my problem. I would appreciate if there are someone out there who has the answer to this problem!
Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
This sounds like a WebSphere issue so I am moving it to the WebSphere forum.
Sun Certified Programmer for the Java� 2 Platform
Moderator of the forums:
J2EE and EJB
Other Java APIs

Associate Instructor - Hofstra University
Amazon Top 750 reviewer - Blog - Unresolved References - Book Review Blog
I agree. Here's the link:
subject: EJB and Oracle LONG converting problem
It's not a secret anymore!