I am using Hibernate 3.2.5, MS SQL Server 2000, and JDK 1.5.

I need to use SQLQuery for full-text index search in two entities with inheritance relationship. I am using MS SQL Server's full text index.

Here is my simplified mapping file:

<class name="Parent" table="TEST_PARENT">

<id name="id" type="long" column="ID">
<meta attribute="scope-set">public</meta>
<generator class="native"/>
</id>

<property name="name" type="string">
<column name="NAME" length="40"/>
</property>

<joined-subclass name="Child" table="TEST_CHILD" lazy="false">

<key column="CHILD_ID"/>

<property name="childName" type="string">
<column name="CHILD_NAME" length="40"/>
</property>

</joined-subclass>

</class>


I am trying to do a search such as follows:

String qry = "question 1"; // use contains clause
SQLQuery q = s.createSQLQuery(qry).addEntity(question 2);
List list = q.list();

I have difficulty writing the correct query and building SQLQuery (see question 1 and 2). I tried many possibilities and always got errors.

I searched the forum and did not see any examples. The online Hibernate Reference Documentation says very lightly about this inheritance situation.

Does anyone have examples about this situation? I got stuck. I really appreciate any help.

Thanks!

I don't know how to do exactly what you are asking, because it involves both non-standard SQL and inheritance, but if you use HQL instead, where you are in the inheritance world, you can use "extra" SQL functions in the WHERE clause of the query and Hibernate will pass them through to the database, something like

from <top-level class> where contains(name, '"foo*" near bar')

to find names containing foo* and bar.

Ignore this accidental post