Hi,

I am trying to execute a stored procedure which takes i/p as an Array of integer and String values.
I am calling this procedure, using jdbc connection object, which I get from hibernate session object,

connection = session.connection();

Now in my code I have following statement which is generating the given exception

ArrayDescriptor objArrayDescriptor= (ArrayDescriptor)ArrayDescriptor.createDescriptor("NUM_ARRAY",connection);

Exception

java.lang.ClassCastException
at oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:103)


I am writing this issue in this forum, as I am getting jdbc connection through hibernate.

When I execute same program using normal JDBC which is obtained as shown, above statement does execute and
I am able to execute stored procedure

Class.forName("oracle.jdbc.driver.OracleDriver");
Connection connection = DriverManager.getConnection("jdbc:oracle:thin:@ip<port>:<usr><pwd><sid>);

Any idea, what might be going wrong

Thanks

Sudhir

Check my answer!

http://forum.hibernate.org/viewtopic.php?t=961710&highlight=arraydescriptor

Regards,