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]

Reply via email to