Hello all,
I have two object types: article and attribute for article
repository.xml is as follows:
...
<class-descriptor class="obj.Attribute" table="OBJATTRIBUTE" >
<field-descriptor id="1" name="objId" column="OBJ" jdbc-type="BIGINT"
primary-key="true"/>
<field-descriptor id="2" name="value" column="ATTRIBUTEVALUE"
jdbc-type="VARCHAR"/>
</class-descriptor>
...
<class-descriptor class="obj.Article" table="ARTICLE">
<field-descriptor id="1" name="articleId" column="ID" jdbc-type="BIGINT"
primary-key="true" />
<field-descriptor id="2" name="label" column="LABEL" jdbc-type="VARCHAR"
/>
<collection-descriptor name="parameters"
element-class-ref="obj.Attribute"
<inverse-foreignkey field-id-ref="1" />
</collection-descriptor>
</class-descriptor>
...
Java code is simple:
...
Criteria criteria = new Criteria();
criteria.addLike("name", "%ab%");
Query query = QueryFactory.newQuery(Article.class, criteria);
Collection � = broker.getCollectionByQuery(query)
...
Why this simple example derived from tutorial3 produces 2*(n+1) queries:
// these for articles
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL:
SELECT A0.ID,A0.LABEL FROM ARTICLE A0 WHERE A0.LABEL LIKE ?
// why to queriy count(*) when all rows are fetched
anyway ?
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL:
SELECT count(*) FROM ARTICLE A0 WHERE A0.LABEL LIKE ?
// these for every article
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL:
SELECT A0.ATTRIBUTE,A0.ATTRIBUTEVALUE,A0.OBJ FROM OBJATTRIBUTE A0 WHERE
A0.OBJ = ?
// why to queriy count(*) when all rows are fetched
anyway ?
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL:
SELECT count(*) FROM OBJATTRIBUTE A0 WHERE A0.OBJ = ?
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL:
SELECT A0.ATTRIBUTE,A0.ATTRIBUTEVALUE,A0.OBJ FROM OBJATTRIBUTE A0 WHERE
A0.OBJ = ?
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL:
SELECT count(*) FROM OBJATTRIBUTE A0 WHERE A0.OBJ = ?
...
perfomance is poor, I'm upset.
How to make OJB make 2 queries: one for Articles, one for corresponding
Attributes ?
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
