I've written an own type for Oracle Spatial data but there is a problem right now when Hibernate wants to load the object which contains this own type. There is a ClassCastException been thrown within the nullSafeGet() function of my own type.

I do a:
Object object = rs.getObject(names[0]);

Afterwards do a:
System.out.println(object.getClass().getName());
System.out.println(object);
for debugging reasons and the first System.out.println() brings oracle.sql.STRUCT, the second one oracle.sql.STRUCT@...

For me this seems all right so far and object seems to be of the type oracle.sql.STRUCT.

Afterwards I do a:
STRUCT struct = (STRUCT)object;
and at this point the ClassCastException is thrown. Does anyone of you have an idea where I could look for further problem clearing or do you perhaps already have a solution?

BTW: The entry for the sqlTypes of this field is Types.STRUCT.

Hibernate version:
2.1.3

Name and version of the database you are using:
Oracle 10g

oracle probably did not load/instantiate it with a classloader that you have in your classloader hiearchy.

It implements java.sql.Struct, doe's not it ?

Can you point me to the direction where I can try to check this and/or better solve the problem? I cannot really think of where to look for.

one thing is to try cast it to java.sql.Struct as baliukas suggests.

if that does not help then you will need to ensure that the .jar file from which the STRUCT is created (probably oracle's driver jar/zip) is visible in
your applications classloader.

currently it is probably loaded by your appservers connection pool which has the driver.jar which you cannot see - but you can use them because you are just using the jdk interfaces.

a hacky way to ensure it is to but the .jar in the classpath of the container....

Thanks a lot for the hint with the classloader. Moving the Oracle JAR out of the Webapps lib directory solved the problem.