blob « Fetch « JPA Q&A

1. Retrieve the lenght of text/blob fron a db

2. How do I retrieve blob value using native sql query

Hi, Im using Hibernate 3.0 and Oracle9 DB. (org.hibernate.dialect.Oracle9Dialect) I wrote a sample code to retrieve a blob value from Oracle and update that value in another employee profile. I used CreateSQLQuery method and executed a native sql query in hibernate for retrieving a blob value (EMP photo image) from Oracle. I get a class cast exception when I retrieve ...