I have been trying to get around an issue (limited Collection returned
thread) , and I have noticed that if I set auto-retrieve=false on my
reference objects, I get the right number of rows returned (minus the
objects of course). So then I wanted to use the pre-fetched relationships to
fill in those objects, but I am getting an error.
( I know that I am working around an issue in an ugly way, but I need to get
this working, and I haven't been able to figure out what OJB is actually
doing that it won't return all of the rows)
when trying to use pre-fetched realationships I get the error
[6/5/03 12:48:03:646 CDT] 2dce7472 SystemOut U
[org.apache.ojb.broker.accesslayer.RsIterator] ERROR: beforeFirst failed !
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0125E Function sequence
error. SQLSTATE=HY010
at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGe
nerator.java:269)
at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGe
nerator.java:206)
at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGen
erator.java:474)
at
COM.ibm.db2.jdbc.app.DB2ScrollableResultSet.fetchOneRow(DB2ScrollableResultS
et.java:486)
at
COM.ibm.db2.jdbc.app.DB2ScrollableResultSet.beforeFirst(DB2ScrollableResultS
et.java:195)
at
com.ibm.ejs.cm.proxy.ResultSetProxy.beforeFirst(ResultSetProxy.java:76)
at
org.apache.ojb.broker.accesslayer.RsIterator.prefetchRelationships(Unknown
Source)
It doesn't matter which reference object I use, I get the same error. it
seems to go through and get the objects, but it always fails on the last
one.
I am using 1.0.rc3 (not latest from cvs)
wsad, datasource, db2
has any one else had an issue with prefetchedrelationships?
any help would be greatly appreciated (getting to the end of my rope)
thanks
-John
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
