If I have a query:

String sql = "from Cat cat where cat.id in :keys";
Query q = getSession().createQuery(sql);

How do I bind an array into the :keys parameter?

There doesn't seem to be a Query.setArray() method, and the generic Query.setParameter("keys", new Object[] {"foo", "bar"}) doesn't seem to be working.

I know I can do this with the Criteria api, but I can't seem to find a sample of how to do this with the query interface.

First, the query should be:
from Cat cat where cat.id in (:keys)

Next, the method is Query.setParameterList() which is overloaded where one form takes an Object array