I am just becoming familiar with Castor JDO, and I am encountering a
strange problem.  If I just retrieve simple attributes of an object,
everything works as expected.  However if I also retrieve related
Objects, mapped either as a one-to-many relationship or a
many-to-many relationship in the database, I get this exception:

java.sql.SQLException: Stream has already been closed
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:285)
        at oracle.jdbc.ttc7.LongTTCItem.getChars(LongTTCItem.java:197)
        at 
oracle.jdbc.dbaccess.DBDataSetImpl.getCharsStreamItem(DBDataSetImpl.java:1188)
        at 
oracle.jdbc.driver.OracleStatement.getCharsInternal(OracleStatement.java:2932)
        at oracle.jdbc.driver.OracleStatement.getStringValue(OracleStatement.java:3047)
        at 
oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:308)
        at org.exolab.castor.jdo.engine.SQLTypes.getObject(SQLTypes.java:341)
        at 
org.exolab.castor.jdo.engine.SQLEngine$SQLQuery.loadSingleField(SQLEngine.java:1814)
        at org.exolab.castor.jdo.engine.SQLEngine$SQLQuery.loadRow(SQLEngine.java:1880)
        at 
org.exolab.castor.jdo.engine.SQLEngine$SQLQuery.fetchRaw(SQLEngine.java:1953)
        at 
org.exolab.castor.jdo.engine.SQLEngine$SQLQuery.nextIdentity(SQLEngine.java:1761)
        at org.exolab.castor.persist.QueryResults.nextIdentity(QueryResults.java:173)
        at 
org.exolab.castor.jdo.engine.OQLQueryImpl$OQLEnumeration.hasMore(OQLQueryImpl.java:638)
        at 
org.exolab.castor.jdo.engine.OQLQueryImpl$OQLEnumeration.hasMore(OQLQueryImpl.java:624)

I also get this exception if I try to execute a second query, while looping through 
the results of my first query.

I am using Castor version 0.9.5 with Oracle.

I have done quite a bit of searching and reading to find a cause for
this, but no luck.  Has anyone seen similar behavior, or have an idea of 
what I might be doing wrong?

Thanks!

John

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
        unsubscribe castor-dev

Reply via email to