Re: OJB RC4 does not select all objects?

[Armin Waibel]

Hi Guido,

sorry for the late reply!

On Mon, 06 Oct 2003 09:37:26 +0200, Guido Beutler <[EMAIL PROTECTED]> 
wrote:

Hi again,

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

What mean "side effect"?
when set eager-releas='true' the connection
was closed after each statement in StatementManager
was closed.
I'm running inside of jboss and without eager-releas='true'
the datasource extends it's maximum limit.
That's the reason why eager-release was introduced ;-)

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)?
as I said in my previous post "this can be" a side-effect
of eager-release, but I'm not sure. Did your test case
pass in OJB standalone mode? If yes, the problem is
eager-release.
regards,
Armin
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]





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