I'm a newbee in HQL (and in SQL also) and I have dificulties crafting the HQL query named "LRUDAO.find_by_name_for_sil28" below.

Could someone help me ?

TIA.



Hibernate version:
3.1

Mapping documents:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >

<hibernate-mapping package="com.airbus.bimat.domain.lru">

<class name="LRU" table="LRUS">
<id name="id" column="LRU_ID" access="field">
<generator class="native" />
</id>

<natural-id mutable="true">
<property name="name" column="LRU_NAME" type="string" not-null="true" length="60" />
<property name="ATA" column="LRU_ATA" type="string" not-null="true" length="6" />
</natural-id>

<set name="parts" cascade="all-delete-orphan" inverse="true">
<key column="LRU_ID" not-null="true" />
<one-to-many class="Part" />
</set>
</class>

<class name="Part" table="PARTS">
<id name="id" column="PART_ID" access="field">
<generator class="native" />
</id>

<natural-id>
<property name="pn" column="PART_PN" type="string" not-null="true" length="40" />
</natural-id>

<many-to-one name="LRU" column="LRU_ID" class="LRU" not-null="true" lazy="false" />

<property name="comments" column="PART_COMMENTS" type="string" length="100" />

<property name="A318" column="PART_a318" type="boolean" not-null="true" />
<property name="A319" column="PART_a319" type="boolean" not-null="true" />
<property name="A320" column="part_a320" type="boolean" not-null="true" />
<property name="A321" column="PART_a321" type="boolean" not-null="true" />
<property name="A330" column="PART_a330" type="boolean" not-null="true" />
<property name="A340" column="PART_a340" type="boolean" not-null="true" />
<property name="A3456" column="PART_a3456" type="boolean" not-null="true" />
<property name="A380" column="PART_a380" type="boolean" not-null="true" />
</class>

<!-- queries -->

<!--
Select from the LRUS table all records having at least one child record in
the PARTS table where either the A318 or the A319 or the A320 or A321 is true.
In SQL :
select
distinct LRUS.lru_id
from
LRUS, PARTS
where
LRUS.lru_id = PARTS.lru_id
and (PART_A318 = 1 OR PART_A319 = 1 OR PART_A320 = 1 OR PART_A321 = 1)
-->
<query name="LRUDAO.find_by_name_for_sil28">
<![CDATA[
select
l
from
LRU as l, PART as p
where
l.id = p.LRU.id
and (p.A318 = 1 OR p.A319 = 1 OR p.A320 = 1 OR p.A321 = 1)
]]>
</query>

</hibernate-mapping>

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

java.lang.ExceptionInInitializerError
at com.airbus.bimat.persistance.HibernateUtil.startup(HibernateUtil.java:72)
at com.airbus.bimat.persistance.HibernateUtil.getSessionFactory(HibernateUtil.java:103)
at com.airbus.bimat.persistance.HibernateUtil.getCurrentSession(HibernateUtil.java:119)
at com.airbus.bimat.persistance.HibernateUtil.closeSession(HibernateUtil.java:163)
at com.airbus.bimat.persistance.SQLScriptRunner.executeSQLScript(SQLScriptRunner.java:98)
at com.airbus.bimat.persistance.SQLScriptRunner.executeSQLScript(SQLScriptRunner.java:56)
at com.airbus.bimat.service.lru.TestLruService.setUp(TestLruService.java:47)
at junit.framework.TestCase.runBare(TestCase.java:125)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:478)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:344)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
Caused by: org.hibernate.HibernateException: Errors in named queries: LRUDAO.find_by_name_for_sil28
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:338)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1154)
at com.airbus.bimat.persistance.HibernateUtil.startup(HibernateUtil.java:66)
... 16 more


Name and version of the database you are using:

Oracle 9i

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

at first glance, I'm not sure if having select I from LRU as I... is valid sql. change to

select
*
from
LRU as l, PART as p
where
l.id = p.LRU.id
and (p.A318 = 1 OR p.A319 = 1 OR p.A320 = 1 OR p.A321 = 1)

query is case sensitive, your class is named Part but the query uses PART.

I finally solve the problem with the following HQL:



PLM you are right, in the previous query version, Part was misspelled as PART.

HQL syntax and semantic is realy obscure to me right now as I'm just begining to write my first queries, where can I found a deep and didactic tutorial about HQL ?

Thancks.

You dont need the l.id = p.LRU.id as thats how the internal mapping is done according to your hbm.xml. The join is only keyed off the LRU.id.

should suffice.

The UserGuide at http://www.hibernate.org/hib_docs/v3/re ... ml_single/
contains various examples of HQL although you probably have to try a few before you master them.