Hibernate hql query using list collection mapping problem

Hello everyone,

What I am trying to achieve is to use a HQL query to select objects, the problems start when I want to set a where condition which uses a List collection map.

the used hibernate hbm and java beans are in the code section.


The current (not working) query goes:

golfertype = new GolferType();
golfertype.setId((short)3);
getHibernateTemplate().find("select startTimeHours, startTimeMinutes from BookException where bookExceptionGolferTypes = ?", golfertype)


This below does work (so it is caused by the collection mapping used in the where query):
getHibernateTemplate().find("select startTimeHours, startTimeMinutes from BookException")

The given error is:
SEVERE: Servlet.service() for servlet action threw exception
org.hibernate.QueryException: Expected positional parameter count: 1, actual parameters: [com.GolfOnline.Beans.GolferType@7b1d52] [select startTimeHours, startTimeMinutes from BookException where bookExceptionGolferTypes = ?]

I have no idea how to do this..

Thanks, Max

The following relevant hibernate hbm's are being used:
 
----------------------------------------- BookException.hbm
<hibernate-mapping>
    <class name="com.GolfOnline.Beans.BookException" table="tbl_BookException" lazy="false">
        
        <id name="id" column="be_ID" type="short">
            <generator class="native"/>
        </id>
        
        <list name="bookExceptionGolferTypes" table="tbl_BookExceptionGolferType" lazy="false" inverse="true">
            <key column="eg_BookException_be_ID"/>
            <list-index base="0" column="eg_ID"/>
            <composite-element class="com.GolfOnline.Beans.BookExceptionGolferType"> 
                <many-to-one class="com.GolfOnline.Beans.GolferType" column="eg_GolferType_gt_ID" name="golferType"/>
                <property name="fee" column="eg_Fee" type="integer" />
                <property name="id" column="eg_Id" type="integer" />
            </composite-element>
        </list>
        <property name="startTimeHours" column="be_StartTimeHours"/>
        <property name="startTimeMinutes" column="be_StartTimeMinutes"/>
    </class>
</hibernate-mapping> 
 
----------------------------------------- BookExceptionGolferType.hbm
<hibernate-mapping>
    <class name="com.GolfOnline.Beans.BookExceptionGolferType" table="tbl_BookExceptionGolferType" lazy="false">
        
        <id name="id" column="eg_ID">
            <generator class="native"/>
        </id>
        
        <many-to-one name="bookException" column="eg_BookException_be_ID" class="com.GolfOnline.Beans.BookException"/>
        <many-to-one name="golferType" column="eg_GolferType_gt_ID" class="com.GolfOnline.Beans.GolferType"/>
        <property name="fee" column="eg_Fee"/>
        
    </class>
</hibernate-mapping> 
 
----------------------------------------- GolferType.hbm
<hibernate-mapping>
    <class name="com.GolfOnline.Beans.GolferType" table="tbl_GolferType" lazy="false">
        
        <id name="id" column="gt_ID" type="short">
            <generator class="native"/>
        </id>
        <property name="title" column="gt_Title"/>
 
    </class>
</hibernate-mapping> 
 
The following relevant java beans is being used:
 
----------------------------------------- BookException .java
 
public class BookException implements Serializable {
    
    private List bookexceptiongolfertypes = null;
    private short id;
    private String starttimehours;
    private String starttimeminutes;
    
    public BookException() {
        super();
    }
    
    public List getBookExceptionGolferTypes() {   return bookexceptiongolfertypes; }
    public short getId() {   return id;    }
    public String getStartTimeHours() {   return starttimehours;    }
    public String getStartTimeMinutes() {   return starttimeminutes;    }
    
    public void setBookExceptionGolferTypes(List bookexceptiongolfertypes) {    this.bookexceptiongolfertypes = bookexceptiongolfertypes;  }
    public void setId (short id) { this.id = id;   }
    public void setStartTimeHours (String starttimehours) { this.starttimehours = starttimehours;   }
    public void setStartTimeMinutes (String starttimeminutes) { this.starttimeminutes = starttimeminutes;   }
    
}

Select allOpen in new window