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]
