wood burning stoves 2.0*
The moose likes Object Relational Mapping and the fly likes Getting Error when Fetching data of Object Type Column using Hibernate Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Getting Error when Fetching data of Object Type Column using Hibernate" Watch "Getting Error when Fetching data of Object Type Column using Hibernate" New topic
Author

Getting Error when Fetching data of Object Type Column using Hibernate

Sapan Shah
Greenhorn

Joined: Jan 01, 2010
Posts: 25
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.
 
wood burning stoves
 
subject: Getting Error when Fetching data of Object Type Column using Hibernate