I have a simple select clause with an "IN" I set the parameter as a String Array but get thrown a runtime error saying Hibernate is expecting just a String. When I use an IN it's always because I want to match more than one item. Anyone else see this problem?

Are you sure, that the property name is right?
Can you post your code? I am using Restrictions.in with an Collection (ArrayList<String>) and everything is working fine.

This code works by taking languages, which might be "English", "Spanish" and "Other" and puts the code in line:

Query q = em.createNativeQuery("select id from DT_Collection_Language d where d.language in ('Enlgish', 'Spanish', 'Other') ");


This code throws Exception at Runtime:

java.lang.ClassCastException: [Ljava.lang.String;
at org.hibernate.type.StringType.toString(StringType.java:44)


...
...
@NamedQuery(name="findtest", query="select a.id from DowntimeLanguage a where a.language in (?1)")
...

String[] languagesA = {"English", "Spanish", "Other"};
Query q = em.createNamedQuery("findtest");
q.setParameter(1, languagesA);
return q.getResultList();

The error is thrown at the line q.getResultList() and the query is never run (I have showSQL turned on)

I am not an hibernate expert, but I remember that I had problems by selecting only one column. You tried to select the whole object?

Every thought about Criteria Queries? Should be much easier!

I'm trying to stick with the JPA spec. Yes, this works with just Hibernate, but JPA with Hibernate it does not work. I believe it is a bug in Hibernate.

Hi,
What do you get if you simply execute the JPA query:
"select id from DT_Collection_Language d"
?
Does it work?

Yes it does work and returns all rows of the table

Try using the List interface instead of a String[] array. e.g.
List languages = new ArrayList();
languages.add...
languages.add...
Finally, call setParameter(1, languages)

It Worked! THANK YOU!