Someone else asked this question but I think the question was misunderstood.

I have a stored procedure that takes an array of strings and an int as parameters. The org.hibernate.Query class does not have a setArray method, only setInt, setString etc.

If you do this invocation with straight jdbc you need to create an ArrayDescriptor and an Oracle ARRAY object and then pass that into the CallableStatement.

so write a custom type that does what you want it to and use it with Query.setParameter(name, value, Hibernate.custom(YourArrayType.class));

Thanks for the response.

Does this work? Has this been tried before and proven to work?
I will try it but I'm concerned that hibernate won't know how to turn my custom type into an ArrayDescriptor.

since you write the custom type you write the code that does the conversion....and yes it has been done before ;)

You are the man!
That worked.

Now how am I supposed to make my code platform independent and work with different dialects?

Here is my nullSafeGet method which is mapping a List of objects to an Oracle type defined as TANGO.STRING_ARRAY which is a TABLE OF VARCHAR2(255)

public void nullSafeSet(PreparedStatement statement, Object value, int index)
throws HibernateException, SQLException {
if (value == null)
statement.setNull(index, SQL_TYPES[0]);
else if(value instanceof ARRAY){
statement.setArray(index, (ARRAY) value);
}
else if(value instanceof List)
{
List valueList = (List)value;
String[] stringArray = new String[valueList.size()];
valueList.toArray(stringArray);
ArrayDescriptor arrayDesc = ArrayDescriptor.createDescriptor("TANGO.STRING_ARRAY", statement.getConnection());
ARRAY array = new oracle.sql.ARRAY(arrayDesc, statement.getConnection(), stringArray);
statement.setArray(index, array);
}
}

hey it ain't me who is using db specifc functionallity ;)