Hibernate version:2.1.7

Name and version of the database you are using:Oracle 9i

Hi all,

I´m doing a simple HQL, but many selects are generated.

The HQL:



The mapping are:



but I don´t want the companyArchive data, only company data.

Thank you very much!!!!

If I recall my H2 correctly, the outer-join="true" means eagerly fetch the association. Change that to false.

If you set outer-join to false, you change the results. An inner join will return a result set that excludes rows in Company where there is no row in CompanyArchive.

You need to add lazy="true" to your class definition:


http://www.hibernate.org/hib_docs/refer ... tions-lazy

If this helps, please drop me a point :)

Daniel

See, I didn't remember my H2 correctly! :D

Thanks, Daniel.

Hi, thanks all

But in relation to generate query only for company?
It´s generating select for companyArchive. O don´t need
companyArchive data, only company data.

Sorry Daniel, I didn´t understand the mapping that you post.
In your mapping you have the proxy="Company" and lazy="true".
But these are equivalent:



thanks!!!!

Hey Hank,

You have to change your one-one-one association. First thing you need to change is set constrained="true". This indicates that Company always has a CompanyArchive. According to documentation if constrained="false" then it will be always eagerly fetched. I also set lazy="no-proxy"

" specifies that the property should be fetched lazily when the instance variable is first accessed"

So only when you call company.getCompanyArchive() will you issue another select.

http://www.hibernate.org/hib_docs/v3/re ... n-onetoone

<class name="Company" table="company"
proxy="Company">
<id name="id" column="company_id">
<generator class="assigned"/>
</id>

<one-to-one name="companyArchive" class="CompanyArchive"
constrained="true" lazy="no-proxy" />

.
.

.
</class>

Hi,

I´m using hibernate 2.1.7 and the system is in production.
So, the tag proxy on one-to-one is not possible.

I will test the option constrained=true.

thank you very much!!!!

Hi again,

Other problem is that the company can or cannot have a companyArchive.
So, constrained=true is not worked for my case. :-(

Is there other solution? :-)

thanks.

If you are using hibernate2 then the option you want to use is lazy="true". I am not sure about constrained being set to false. Best way it to try it and test to see what happens

Hi bumbalo,

thanks for your attention.

I´m testing with lazy=true. I´m testing here, but...

thank you!

PS.: sorry, I cannot set your post like helpful for me :-)

Hi all,

I found an URL for this:

http://www.hibernate.org/162.html

thanks all!!!!

Is there a way to set the tag constrained=true at run time?