Hibernate-SQL-Problem

mart05 · **Joined:** Tue Jun 06, 2006 6:50 am **Posts:** 3

Hello,
i've a problem with hibernate 3. i have two tables in my database, one is called QUESTIONNAIRE with a primary key qid, the other is called ANSWERS with a primary key aid and a column qid - which is not declarated as foreign key!

in my code i have the following statement:

Code:

ses = HibernateSessionFactory.currentSession();
sql = "from Questionnaire as questionnaire order by questionnaire.qid";
Query query = ses.createQuery(sql);

but: after calling this, all lines of the EVALUATION-table are included into the resulting set too!

how can this be possible, what can i do to fix it (or what do i wrong - but something like that shouldn't happen)?

thx in advance,
mart05

ramnath · **Posted:** Tue Jun 06, 2006 8:38 am

Hi,

Is EVALUTION table is ANSWERS table?

If you want hibernate not to load all the other values then you need to set lazy="true" in the mapping for Lazy Initialization.

mart05 · **Joined:** Tue Jun 06, 2006 6:50 am **Posts:** 3

i solved the problem. the EVALUATION-class was extended from QUESTIONNAIRE-class.
it was an error/bug in the auto-generated hibernate-mapping of myeclipse. i don't know if there are general problems with that, but we had some ..

mart05