Re: OJB RC4 does not select all objects?

[Guido Beutler]

Hi again,

because I did not get any reply for my postings I'm trying to get some 
information.

What mean "side effect"? I'm running inside of jboss and without 
eager-releas='true'
the datasource extends it's maximum limit.
Why not all objects are selected and why without throwing any exception?
Is there a workaround (instead of making a lot of primary key selects)?

best regards,

Guido

Armin Waibel wrote:

Hi Guido,

this can be a side-effect of the eager-release
attribute when set 'true'.
Did you tried to run your test with 'false'?
Or is your test successful in standalone OJB?
regards,
Armin
----- Original Message -----
From: "Guido Beutler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 01, 2003 3:27 PM
Subject: Re: OJB RC4 does not select all objects?
 

Hi,,

I tried a workaround and select all A by a loop with direct primary
   

key
 

access like:

"select allobject from A where key=$1"

Whith this select I get all expected objects but of course this is not
   

very comfortable
 

to code a loop for every IN clause.

best regards,

Guido

-------- Original Message --------
Subject: OJB RC4 does not select all objects?
Date: Wed, 01 Oct 2003 14:20:15 +0200
From: Guido Beutler <[EMAIL PROTECTED]>
To: OJB Users List <[EMAIL PROTECTED]


Hello,

I've got a strange problem. I have two Tables A and B with
   

corresponding
 

classes.
B has a foreign key to A and so I have a 1:N  between A and B.
A has a reference-descriptor to B and
B has a collection-descriptor  to A.
If I try to select all instances of A i only get a few entries instead
of 20. If I reinvoke
the test case the number of retrieved objects raises until 20 is
   

reached.
 

"select allobject from A where key is in ($1)"

$1 is a collection of 20 integers.
If I select all objects of B first and then select all A i get the
expected 20
objects.
In both cases no exception is thrown.
I'm using rc4 with ODMG inside of JBoss 3.2.2. with DB/2.
Has anybody seen this before?

gest regards,

Guido



---------------------------------------------------------------------
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]
 



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]