Hibernate version: 2.1.6

Name and version of the database you are using:
Oracle 8 and 9

We have some legacy data (that has a snow balls chance in hell of being altered) that is stored in tables that use Oracle PL/SQL structs/objects.

Would Hibernate support these custom data types if I were to extend UserType, and somehow manage to insert the required PL/SQL method calls to get/set the underlying struct?

If so, any pointers?

Hi-

I am also wondering about the use of Oracle's STRUCT type with Hibernate - what is the appropriate mapping type?


My goal (not related to the question) is to store spatial data in an Oracle 10G database. The data is stored as a STRUCT, which Oracle can convert to a JGeometry object.

Any help on how to map an Oracle STRUCT type?

Thanks,
Eric Everman

You could use a custom UserType most likely, if you know how to retrieve that stuff from a ResultSet.

Hi-

Thanks for the response, but I was way to vague in my question. I'm planning on using a custom UserType, but I'm am unsure of what to return from the sqlTypes() method.

Since there is no Hibernate.Struct type, do I return Hibernate.Binary?


====== The UserType method in question =========
public class MyCustomType implements UserType {

public MyCustomType() {}

public int[] sqlTypes() {
return new int[] { ???? what to return? ???? };
}
...
}
======================================

Thanks again,
Eric Everman

Well usually some constant from java.sql.Types - best is to have a look at the source on how it is used, figure out what works that way ...