Hello,
I recently switched from rc7 to 1.0.4 and lazy loading seem to happen any
more. Can someone please check my config out.
1.0.4 fires twice as much queries?
thanks.
sql output get all organisations 1.0.4
just after clear cache
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT A0.id,A0.lastmodified,A0.creationdate,A0.version,A0.fax,
A0.fieldofinterest,A0.name,A0.noofemployee,A0.phone,A0.postaladress,
A0.postalcity,A0.postalzip,A0.url,A0.visitadress,A0.visitcity,A0.visitzip,
A0.chamberofcommerceno,A0.immediateparentid,A0.ultimateparentid,
A0.postalcountryid,A0.organisationbrancheid,A0.visitcountryid,
A0.organisationtypeid FROM organisation A0
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT A0.id,A0.lastmodified,A0.creationdate,A0.version,A0.code,A0.name,
A0.number FROM country A0 WHERE A0.id = ?
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT A0.id,A0.lastmodified,A0.creationdate,A0.version,A0.defaultvalue,
A0.fixheader,A0.groupby,A0.indescriptor,A0.name,A0.subtablesheight,
A0.descriptorfieldid,A0.defaultqueryid,A0.quicksearchqueryid FROM tablemodel
A0 WHERE A0.name = ?
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT A0.id,A0.lastmodified,A0.creationdate,A0.version,A0.defaultvalue,
A0.indescriptor,A0.name,A0.ordr,A0.showintable,A0.sortdown,A0.fieldtypeid,
A0.fieldcollectionid,A0.parenttablemodelid,A0.calculatedfieldid FROM field
A0 WHERE A0.id = ?
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT A0.id,A0.lastmodified,A0.creationdate,A0.version,A0.name,A0.typeFROM
fieldtype A0 WHERE
A0.id = ?
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT A0.id,A0.lastmodified,A0.creationdate,A0.version,A0.defaultvalue,
A0.name,A0.ordr,A0.property,A0.selectionpath,A0.showintable,
A0.parentcollectionmodelid,A0.innerselectid,A0.parenttablemodelid,
A0.rendertypeid,A0.entityid FROM reference A0 WHERE A0.parenttablemodelid =
?
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT A0.id,A0.lastmodified,A0.creationdate,A0.version,A0.name,
A0.referenceid FROM rendertype A0 WHERE A0.id = ?
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT A0.id,A0.lastmodified,A0.creationdate,A0.version,A0.defaultvalue,
A0.fixheader,A0.groupby,A0.indescriptor,A0.name,A0.subtablesheight,
A0.descriptorfieldid,A0.defaultqueryid,A0.quicksearchqueryid FROM tablemodel
A0 WHERE A0.id IN (?,?,?,?)
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT A0.id,A0.lastmodified,A0.creationdate,A0.version,A0.defaultvalue,
A0.indescriptor,A0.name,A0.ordr,A0.showintable,A0.sortdown,A0.fieldtypeid,
A0.fieldcollectionid,A0.parenttablemodelid,A0.calculatedfieldid FROM field
A0 WHERE A0.id IN (?,?)
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT A0.id,A0.lastmodified,A0.creationdate,A0.version,A0.name,A0.typeFROM
fieldtype A0 WHERE
A0.id = ?
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT A0.id,A0.lastmodified,A0.creationdate,A0.version,A0.defaultvalue,
A0.indescriptor,A0.name,A0.ordr,A0.showintable,A0.sortdown,A0.fieldtypeid,
A0.fieldcollectionid,A0.parenttablemodelid,A0.calculatedfieldid FROM field
A0 WHERE A0.parenttablemodelid = ?
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT A0.id,A0.lastmodified,A0.creationdate,A0.version,A0.name,A0.typeFROM
fieldtype A0 WHERE
A0.id IN (?,?,?)
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT A0.id,A0.lastmodified,A0.creationdate,A0.version,A0.defaultvalue,
A0.fixheader,A0.groupby,A0.indescriptor,A0.name,A0.subtablesheight,
A0.descriptorfieldid,A0.defaultqueryid,A0.quicksearchqueryid FROM tablemodel
A0 WHERE A0.id = ?
second time
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT A0.id,A0.lastmodified,A0.creationdate,A0.version,A0.fax,
A0.fieldofinterest,A0.name,A0.noofemployee,A0.phone,A0.postaladress,
A0.postalcity,A0.postalzip,A0.url,A0.visitadress,A0.visitcity,A0.visitzip,
A0.chamberofcommerceno,A0.immediateparentid,A0.ultimateparentid,
A0.postalcountryid,A0.organisationbrancheid,A0.visitcountryid,
A0.organisationtypeid FROM organisation A0
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT A0.id,A0.lastmodified,A0.creationdate,A0.version,A0.code,A0.name,
A0.number FROM country A0 WHERE A0.id = ?
sql output get all organisations rc7
just after clear cache
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT A0.organisationbrancheid,A0.ultimateparentid,A0.phone,
A0.immediateparentid,A0.visitcountryid,A0.visitzip,A0.postalzip,A0.visitcity
,A0.visitadress,A0.postaladress,A0.fax,A0.id,A0.version,A0.postalcountryid,
A0.postalcity,A0.chamberofcommerceno,A0.organisationtypeid,A0.url,
A0.noofemployee,A0.name,A0.creationdate,A0.lastmodified,A0.fieldofinterestFROM
organisation A0
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT A0.code,A0.name,A0.creationdate,A0.id,A0.number,A0.version,
A0.lastmodified FROM country A0 WHERE A0.id = ?
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT A0.indescriptor,A0.groupby,A0.defaultqueryid,A0.descriptorfieldid
,A0.id,A0.quicksearchqueryid,A0.version,A0.fixheader,A0.name,A0.creationdate
,A0.lastmodified,A0.defaultvalue,A0.subtablesheight FROM tablemodel A0 WHERE
A0.name = ?
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT A0.ordr,A0.property,A0.selectionpath,A0.id,A0.version,
A0.innerselectid,A0.rendertypeid,A0.parentcollectionmodelid,
A0.parenttablemodelid,A0.entityid,A0.name,A0.creationdate,A0.showintable,
A0.lastmodified,A0.defaultvalue FROM reference A0 WHERE
A0.parenttablemodelid = ?
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT A0.indescriptor,A0.ordr,A0.id,A0.version,A0.calculatedfieldid,
A0.sortdown,A0.parenttablemodelid,A0.fieldtypeid,A0.name,A0.creationdate,
A0.showintable,A0.fieldcollectionid,A0.lastmodified,A0.defaultvalue FROM
field A0 WHERE A0.parenttablemodelid = ?
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT A0.type,A0.name,A0.creationdate,A0.id,A0.version,A0.lastmodifiedFROM
fieldtype A0 WHERE
A0.id IN (?,?)
second time
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:SELECT A0.organisationbrancheid,A0.ultimateparentid,A0.phone,
A0.immediateparentid,A0.visitcountryid,A0.visitzip,A0.postalzip,A0.visitcity
,A0.visitadress,A0.postaladress,A0.fax,A0.id,A0.version,A0.postalcountryid,
A0.postalcity,A0.chamberofcommerceno,A0.organisationtypeid,A0.url,
A0.noofemployee,A0.name,A0.creationdate,A0.lastmodified,A0.fieldofinterestFROM
organisation A0
org descriptor
<class-descriptor class="com.myvision.model.Organisation"
table="organisation">
<field-descriptor name="id" column="id" jdbc-type="INTEGER"
primarykey="true" autoincrement="true"/>
<field-descriptor name="lastModified" column="lastmodified"
jdbc-type="TIMESTAMP"/>
<field-descriptor name="creationDate" column="creationdate"
jdbc-type="TIMESTAMP"/>
<field-descriptor name="version" column="version" jdbc-type="INTEGER"/>
<field-descriptor name="fax" column="fax" jdbc-type="VARCHAR"/>
<field-descriptor name="fieldOfInterest" column="fieldofinterest"
jdbc-type="LONGVARCHAR"/>
<field-descriptor name="name" column="name" jdbc-type="VARCHAR"/>
<field-descriptor name="noOfEmployee" column="noofemployee"
jdbc-type="INTEGER"/>
<field-descriptor name="phone" column="phone" jdbc-type="VARCHAR"/>
<field-descriptor name="postalAdress" column="postaladress"
jdbc-type="VARCHAR"/>
<field-descriptor name="postalCity" column="postalcity"
jdbc-type="VARCHAR"/>
<field-descriptor name="postalZip" column="postalzip"
jdbc-type="VARCHAR"/>
<field-descriptor name="url" column="url" jdbc-type="VARCHAR"/>
<field-descriptor name="visitAdress" column="visitadress"
jdbc-type="VARCHAR"/>
<field-descriptor name="visitCity" column="visitcity"
jdbc-type="VARCHAR"/>
<field-descriptor name="visitZip" column="visitzip" jdbc-type="VARCHAR"/>
<field-descriptor name="chamberOfCommerceNo" column="chamberofcommerceno"
jdbc-type="VARCHAR"/>
<reference-descriptor name="immediateParent" class-ref="
com.myvision.model.Organisation">
<foreignkey field-ref="immediateParentId"/>
</reference-descriptor>
<field-descriptor name="immediateParentId" column="immediateparentid"
jdbc-type="INTEGER"/>
<reference-descriptor name="ultimateParent" class-ref="
com.myvision.model.Organisation ">
<foreignkey field-ref="ultimateParentId"/>
</reference-descriptor>
<field-descriptor name="ultimateParentId" column="ultimateparentid"
jdbc-type="INTEGER"/>
<reference-descriptor name="postalCountry" class-ref="
com.myvision.model.Country">
<foreignkey field-ref="postalCountryId"/>
</reference-descriptor>
<field-descriptor name="postalCountryId" column="postalcountryid"
jdbc-type="INTEGER"/>
<reference-descriptor name="organisationBranche" class-ref="
com.myvision.model.OrganisationBranche">
<foreignkey field-ref="organisationBrancheId"/>
</reference-descriptor>
<field-descriptor name="organisationBrancheId"
column="organisationbrancheid" jdbc-type="INTEGER"/>
<reference-descriptor name="visitCountry" class-ref="
com.myvision.model.Country ">
<foreignkey field-ref="visitCountryId"/>
</reference-descriptor>
<field-descriptor name="visitCountryId" column="visitcountryid"
jdbc-type="INTEGER"/>
<reference-descriptor name="organisationType" class-ref="
com.myvision.model.OrganisationType">
<foreignkey field-ref="organisationTypeId"/>
</reference-descriptor>
<field-descriptor name="organisationTypeId" column="organisationtypeid"
jdbc-type="INTEGER"/>
<collection-descriptor name="projectList" element-class-ref="
com.myvision.model.Project " auto-retrieve="true" auto-update="true"
proxy="true" auto-delete="false">
<inverse-foreignkey field-ref="parentOrganisationId"/>
</collection-descriptor>
<collection-descriptor name="contactList" element-class-ref="
com.myvision.model.Contact" auto-retrieve="true" auto-update="true"
proxy="true" auto-delete="false">
<inverse-foreignkey field-ref="parentOrganisationId"/>
</collection-descriptor>
<collection-descriptor name="bankAccountList" element-class-ref="
com.myvision.model.BankAccount " auto-retrieve="true" auto-update="true"
proxy="true" auto-delete="false">
<inverse-foreignkey field-ref="parentOrganisationId"/>
</collection-descriptor>
<collection-descriptor name="smsMessageList" element-class-ref="
com.myvision.model.SmsMessage" auto-retrieve="true" auto-update="true"
proxy="true" auto-delete="false">
<inverse-foreignkey field-ref="parentOrganisationId"/>
</collection-descriptor>
</class-descriptor>
OJB.properties:
ProxyFactoryClass=org.apache.ojb.broker.core.proxy.ProxyFactoryCGLIBImpl
ObjectCacheClass=org.apache.ojb.broker.cache.ObjectCacheDefaultImpl
class
<class-descriptor class="com.myvision.model.Note " table="note">
one2many
<collection-descriptor name="declarationSheetLines" element-class-ref="
com.myvision.model.DeclarationSheetLine " auto-retrieve="true"
auto-update="true" proxy="true" auto-delete="false">
<inverse-foreignkey field-ref="parentDeclarationSheetId"/>
</collection-descriptor>
many2many
<collection-descriptor name="attachmentList" element-class-ref="
com.myvision.model.Attachment" auto-retrieve="true" auto-update="true"
proxy="true" indirection-table="note_attachmentlist_2_attachment">
<fk-pointing-to-this-class column="attachmentListId"/>
<fk-pointing-to-element-class column="attachmentId"/>
</collection-descriptor>
ref
<reference-descriptor name="parentTableModel" class-ref="
com.myvision.model.TableModel">
mvg,
Dennis
