Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

EJB and Oracle LONG converting problem

 
Kjartan Aanestad
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 13974
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic