I am developing a hibernate project plase help me how to implement in the following senario

1. i have table1 say " USER" with some columns

2. Table2 say "USER_DETAILS" with some columns and this table has reference to first table (USER).

3. Then i have created a user defined SQl type object say(T_USER_DETAILS) which have some of the columns like in "USER_DETAILS" table.

4. Then i have created a view which have some of the columns of table1("USER") and also have a column which have a type "T_USER_DETAILS"( which was created at point 3)


5. The stored procedure will return view object

6. This query will return multiple rows.

In this senario, without user defined object(T_USER_DETAILS) in view, i am able to fetch data.

if view does have user defined sqltype column(T_USER_DETAILS) it gives an error
org.hibernate.type.SerializationException: could not deserialize


Please let me know how to map java objects to User defined data type object in oracle.

if any body have idea please let me know.

Thanks in advance

Sairam

What do you mean by that? Have you implemented
org.hibernate.usertype.UserType ? If so, please let me see it.

cheers,
spunky