We have oracle database in which we have table name (PRICES) and in that having one column of object type (MYMONEY).
create table prices ( id number, price mymoney );
create type mymoney as object (local_value number,mnemonic varchar2(3));
Problem is that we are not able to retrieve data list of object type column using Hibernate but we are able to insert the data on the above tables successfully.
Below is the error we are getting when we try to retrieve the data...
The following are the files we are using as follows:--
Step I) We have created Prices.java file to map with prices table.
Step II) We have created Mymoney.java file.
Step III) We have created MoneyUserType.java file using Hibernate Custom UserType.
Step IV) Then we have created HibernateMapping.xml
Step V) Then we have created HibernateUtil.java
Step VI) Then we finally created Main.java to Run the program.