is your db2 database version 8? my database is only version 7, I am wondering if there is a fixpak for version 7
-----Original Message----- From: Michael Schulze [mailto:[EMAIL PROTECTED] Sent: Friday, June 06, 2003 2:50 AM To: OJB Users List Subject: Re: pre-fetched relationships error Hi, i too had a problem with prefetched relationships, db2 and the app jdbc driver. In my case no rows were returned at all when using prefetched relationships. the net jdbc driver worked fine. db2 fixpak 8 solved the problem for me. cheers, Michael On Thu, 2003-06-05 at 20:20, 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. > 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 --------------------------------------------------------------------- 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]