Getting a ClassCastException upon executing getHibernateTemplate().find(

[Kim Kantola]

Hello All,

In my java code, I create some Hibernate Query Language (HQL) and execute it as follows :

 StringBuffer enrollQuerry = new StringBuffer("select enr from Enrollment enr where enr.patient.patientId in (");
		for(int count =0 ; count < patients.size(); count++ )
		{
			enrollQuerry.append("?");
			if(patients.size()-1 != count)
			{
				enrollQuerry.append(",");				
			}
		}
		enrollQuerry.append(") ");
		List enrollments = getHibernateTemplate().find(enrollQuerry.toString(), patients);   

where the parameter patients is a java.util.List object of String values.

When this code is run, I do not get any SQL exceptions, but I do get a class Cast exception as follows :

java.lang.ClassCastException
at org.hibernate.type.StringType.toString(StringType.java:44)


I am new to Spring and Hibernate, maybe my problem is something obvious to you out there with more experience?
Thanks in advance,
Kim

[Hong Anderson]

You should debug StringType to see what actually happened.

[Kim Kantola]

I got past this, not sure if this is the only solution as I am so new to this, but I do know that what I changed did make the error go away.

The problem appeared to be here :

List enrollments = getHibernateTemplate().find(enrollQuerry.toString(), patients);

The object patients was a java.util.List. It looks like the find method of getHibernateTmeplate looks for an array there. I took my list of Strings, created an array of Strings ( String[] ) and passed that instead. This worked.

Kim