Carlos Chávez wrote:
> Hi johne.
>
Ops, forget my email,
I misunderstood your mail.
I thought the "region" can be null.
Cheers,
Carlos Chávez.
> I think you need to set the outer join against the object "region",
> query.setPathOuterJoin("region");
>
> Cheers,
> Carlos Chávez.
>
>
>> Hey all,
>>
>> Been a while since I had need to post. I am looking forward to the new
>> release as I am still on 1.0.3. Thank you for all of the hard work Armin.
>>
>> Using 1.0.3, I am getting an unexpected result with one query using the PB.
>>
>> I am using this query:
>>
>> QueryByCriteria query = new QueryByCriteria(objectClass);
>> query.addOrderByAscending("productGroupId");
>> query.addOrderByAscending("country.name");
>> query.addOrderByAscending("region.name");
>>
>>
>> For this query, it is valid to have region names that are null. Despite
>> this, I would want those records to be included in the result set, but they
>> are not.
>>
>>
>>
>> I am using this mapping:
>>
>> <!-- Definitions for the ServiceLocationVO object -->
>> <class-descriptor
>> class="com.jmjmedia.sp.model.service.activelocation.ServiceLocationVO"
>> table="servicelocation">
>>
>> <field-descriptor
>> name="slId"
>> column="slid"
>> jdbc-type="BIGINT"
>> primarykey="true"
>> autoincrement="true"
>> />
>> <field-descriptor
>> name="productGroupId"
>> column="productgroupid"
>> jdbc-type="INTEGER"
>> />
>> <field-descriptor
>> name="countryId"
>> column="countryid"
>> jdbc-type="CHAR"
>> />
>> <field-descriptor
>> name="regionId"
>> column="regionid"
>> jdbc-type="CHAR"
>> />
>>
>> <reference-descriptor
>> name="country"
>> class-ref="com.jmjmedia.sp.model.places.CountryVO"
>> auto-retrieve="true"
>> auto-update="none"
>> auto-delete="none"
>> proxy="false">
>> <foreignkey field-ref="countryId"/>
>> </reference-descriptor>
>>
>> <reference-descriptor
>> name="region"
>> class-ref="com.jmjmedia.sp.model.places.RegionVO"
>> auto-retrieve="true"
>> auto-update="none"
>> auto-delete="none"
>> proxy="false">
>> <foreignkey field-ref="countryId"/>
>> <foreignkey field-ref="regionId"/>
>> </reference-descriptor>
>>
>> </class-descriptor>
>>
>>
>>
>> <!-- Definitions for the Country object -->
>> <class-descriptor class="com.jmjmedia.sp.model.places.CountryVO"
>> table="country">
>>
>> <!-- -1 within a per class cache forces the cache to stay in memory. -->
>> <object-cache
>> class="org.apache.ojb.broker.cache.ObjectCacheDefaultImpl">
>> <attribute attribute-name="timeout" attribute-value="-1" />
>> </object-cache>
>>
>> <field-descriptor name="countryId" column="ccode" jdbc-type="CHAR"
>> primarykey="true" />
>> <field-descriptor name="name" column="cname" jdbc-type="VARCHAR" />
>> </class-descriptor>
>>
>>
>>
>> <!-- Definitions for the Region object -->
>> <class-descriptor class="com.jmjmedia.sp.model.places.RegionVO"
>> table="region">
>>
>> <!-- -1 within a per class cache forces the cache to stay in memory. -->
>> <object-cache
>> class="org.apache.ojb.broker.cache.ObjectCacheDefaultImpl">
>> <attribute attribute-name="timeout" attribute-value="-1" />
>> </object-cache>
>>
>> <field-descriptor name="countryId" column="r_ccode" jdbc-type="CHAR"
>> primarykey="true" />
>> <field-descriptor name="regionId" column="rcode" jdbc-type="CHAR"
>> primarykey="true" />
>> <field-descriptor name="name" column="rname" jdbc-type="VARCHAR" />
>> </class-descriptor>
>>
>>
>>
>>
>>
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
