db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jakob Braeuchi <jbraeu...@hotmail.com>
Subject [OJB] Issue #OJB173 modified
Date Tue, 03 Jun 2003 20:52:05 GMT

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.  




Mime
View raw message