We have inherited a DB with user defined object types (eg: 'address' containing city, state zip et.al.).

This zip column can be retrieved from Oracle by setting the column as follows:
@Column(name = "SHIP_TO.zip")

However, you cannot update using this.

Does anyone know how to update Oracle user defined object types in Hibernate ?

Thanks,
Craig.

I found out that it will work if the columns are prefixed with a table identifier in the SQL.

So, this would work:

update tbl_xxx t set t.SHIP_TO.zip = '33333' where cust_id = 2549;

The question now becomes:

How do I get Hibernate to generate table qualifiers on the update statements ?