Implementing SQLData and retreiveing object array

[Prashanth menon]

I created an oracle object. Created a java class that implements java.sql.SQLData.
By overriding the writeSQL method I was able to pass to the data base the object.
The reverse did not work.

 
Hashtable htMap = (Hashtable) con.getTypeMap();
//SAMPLE_OBJ_TY is oracle object and Sample is the java class that implements SQLData
htMap .put("SAMPLE_OBJ_TY",Sample.class);
//procedure returns a java.sql.Array object
CallableStatement cs = con.prepareCall(
"{call work_pkg.test_proc(?)}");
//SAMPLE_OBJ_COL_TY is the collection type defined for the object.
cs.registerOutParameter(1, OracleTypes.ARRAY, "SAMPLE_OBJ_COL_TY");
cs.execute();
 

When I tried to retreive the sql array and subsequently the object out of the array (casted as "Sample") the following exeception occurs
java.sql.SQLException: Inconsistent java and sql object types
Can anyone give some pointer to the possible solution.
thanks
Prashanth

[Prashanth menon]

Ok I got rid of the exception now.
It was because I had missed out on the default constructor.
Prashanth