File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 Soft Skills 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
Author

EJB and Oracle LONG converting problem

Kjartan Aanestad
Greenhorn

Joined: Aug 22, 2001
Posts: 7
Hi,
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:
javax.ejb.FinderException: com.ibm.ejs.persitence.EnumeratorException
original exception: com.ibm.ejs.container.ContainerInternalError: ;
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!
Regards
Kjartan
------------------
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.
------------------
Tom
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: http://aspose.com/file-tools
 
subject: EJB and Oracle LONG converting problem