imo this is an issue with your jdbc-driver. could you please provide more info about the error thrown by the driver ?
jakob
McCaffrey, John G. wrote:
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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
