Re: OJB RC4 does not select all objects?

[Guido Beutler]

Hi Armin,  :-)

yes I'm using eager-release = 'true'
with 'false' my connection pool die's when running under load :-(
I'll try 'false' just for a test and post the result.
Do you mean that I can not trust select results if running with 'true'?
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]