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.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: Getting Error when Fetching data of Object Type Column using Hibernate