One of my tables has a column of type ROWID in my Oracle database. If I omit mapping this column, I can get result list, however, iterating the list to retrieve list elements throws NullPointException - all elements are null. If I map the column as type="rowid", and in my JavaBean I use Long type for this field, I get Hibernate Configuration Error - "Could not determine type for: rowid, for columns: [org.hibernate.mapping.Column(SEQUENCE_NUM)]". I am using Hibernate3.

Anybody has experience of mapping ROWID columns? Any help is greatly appreciated.

A ROWID in Oracle is actually a logical address for a row. Every ROWID is unique; it is not merely the offset of a row within a table (unlike ROWNUM). You can't really cast it to a numeric type--it's more complex than that.

What you probably need to do is implement a org.hibernate.usertype.UserType class that uses Oracle-specific calls to extract the ROWID and return it as a special object type (oracle.sql.ROWID). Set your property to be that type and then set the <property> type to be your UserType implementation in the Hibernate mapping file.

That, or just maybe mapping it as type Object and casting as necessary in your code might work....

- Jesse

Thank you Jesse for your reply.

I have figured out that if I treat ROWID same as VARCHAR2 and map to string, then everything works fine.