aspose file tools*
The moose likes Object Relational Mapping and the fly likes Issue while retrieving BLOB from ORACLE 9i, using Hibernate 3.0 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Issue while retrieving BLOB from ORACLE 9i, using Hibernate 3.0" Watch "Issue while retrieving BLOB from ORACLE 9i, using Hibernate 3.0" New topic
Author

Issue while retrieving BLOB from ORACLE 9i, using Hibernate 3.0

Gajen Pingalkar
Ranch Hand

Joined: Aug 29, 2006
Posts: 37
In my application I am using Hibernate 3.0, Oracle 9i and JAVA 5.0. Here I want to store more than 4000 charecter in table column.
For that I used this mapping,

My POJO object have,


Using this code, I am able to save BLOB in table,



In my DAO, I am using this code,


but I cant retrive it. While fetching list, I am getting this error.



Please reply

Thanks,
Gajendra
Travis Hein
Ranch Hand

Joined: Jun 06, 2006
Posts: 161
does using type="bytea" work ?

Error: Keyboard not attached. Press F1 to continue.
Gajen Pingalkar
Ranch Hand

Joined: Aug 29, 2006
Posts: 37
When I add type ="bytea" into hbm, I got this exception :
 
jQuery in Action, 2nd edition
 
subject: Issue while retrieving BLOB from ORACLE 9i, using Hibernate 3.0