Hibernate Community • View topic - Can we override the Query generated by Hibernate Association

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Can we override the Query generated by Hibernate Association

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

sampathkumarpb

Post subject: Can we override the Query generated by Hibernate Association

Posted: Tue Sep 14, 2010 11:09 am

Newbie

Joined: Tue Sep 14, 2010 10:59 am
Posts: 2

Hi,

Assuming the following set gets all the Events for Person.

<set name="events" table="PERSON_EVENT">
<key column="PERSON_ID"/>
<many-to-many column="EVENT_ID" class="Event"/>
</set>

can we Override the Query generated by the hibernate with my own Query (HQL or SQL).

Thanks
Sampath Kumar

Top

nordborg

Post subject: Re: Can we override the Query generated by Hibernate Association

Posted: Tue Sep 14, 2010 2:04 pm

Expert

Joined: Wed Mar 03, 2004 6:35 am
Posts: 1240
Location: Lund, Sweden

It seems like you can but I have never used it myself: http://docs.jboss.org/hibernate/stable/ ... rysql-load

Top

easwaran2180

Post subject: Re: Can we override the Query generated by Hibernate Association

Posted: Wed Sep 15, 2010 11:48 am

Newbie

Joined: Tue Sep 14, 2010 9:44 am
Posts: 3

Hi,

I feel you can override the query generated.

Code:

<set name="events" table="PERSON_EVENT">
       <key column="PERSON_ID"/>
       <many-to-many column="EVENT_ID" class="Event"/>
       <loader query-ref="personquery"/>
</set>

<sql-query name="personquery">
    <load-collection alias="pers" ....../>
    your query goes here
</sql-query>

cheers

VT

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum