Meaningless Drivel is fun!*
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
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 :
 
Consider Paul's rocket mass heater.
 
subject: Issue while retrieving BLOB from ORACLE 9i, using Hibernate 3.0
 
Similar Threads
Read/Write BLOB in byte[] with Hibernate in MySQL..
problem using hibernate and stored procedures for reading portion of data from database
distinct and order by Problem
Working with BLOB in Oracle and Java using hibernate
Executing stored procedures in hibernate