You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-dev@db.apache.org by Jakob Braeuchi <jb...@hotmail.com> on 2003/06/03 22:52:05 UTC
[OJB] Issue #OJB173 modified
Issue OJB173 has just been modified by user brj
You can view the issue detail at the following URL:
<http://scarab.werken.com/scarab/issues/id/OJB173>
The following modifications were made to this issue:
I have a 1:1 relationship between objects A and B sharing a primary key.
<class-descriptor class="com.dla.A" table="A">
<field-descriptor name="id" column="ID" jdbc-type="INTEGER"
primarykey="true" autoincrement="true"/>
...
</class-descriptor>
<class-descriptor class="com.dla.B" table="B">
<field-descriptor name="id" column="ID" jdbc-type="INTEGER"
primarykey="true" autoincrement="true"/>
...
<reference-descriptor name="a" class-ref="com.dla.A"
auto-retrieve="true">
<foreignkey field-ref="id"/>
</reference-descriptor>
</class-descriptor>
within OBJ.properties the following SQL IN limit is set:
SqlInLimit=200
When asking for all B objects with A as a prefetched relationship, all
instances of B are loaded, then the first 200 (the value of SqlInLimit)
instances of A are loaded using one IN statement, but all subsequent
instances of A are loaded with a SELECT statement per instance.