BLOB « Query « JPA Q&A





1. JPA: 'SELECT DISTINCT' with BLOB columns    stackoverflow.com

I'm trying to run this JPQL query:

SELECT DISTINCT i FROM Table i JOIN i.other o
which promptly fails with: "Internal Exception: java.sql.SQLException: Columns of type 'BLOB' may not be used in CREATE INDEX, ...

3. PK BLOB + QUERY BLOB    forum.hibernate.org

Hi, we are developing a legal p2p-filesharing system in JXTA combined with web services and additionally we want to use a persistence layer. Our web services are running on a tomcat server. Before our p2p clients can exchange any data they must verify on a Trusted Third Party(TTP) our web services if the content they want to exchange is legal. Our ...

4. Oracle blob query returns data w/ hb 3.0.3, null w/ 3.1.3    forum.hibernate.org

Newbie Joined: Fri Oct 14, 2005 4:42 pm Posts: 15 My web application is in production with hibernate 3.0.3. Trying to upgrade to 3.1.3, but having problems reading serialized blobs. The blob was read and written by my app using hibernate 3.0.3, and is not null, but hibernate 3.1.3 disagrees. SQL*Plus confirms the field has data. Web Server: Windows XP SP2 ...

5. How to use BLOB columns in HQL query    forum.hibernate.org

6. Criteria API avoid selecting blob columns    forum.hibernate.org

Hi guys, I'm running into a criteria issue. Maybe you can shine some light for me? :) I will attach the mapping files of two domain objs. Activity and UploadedClaim. On UploadedClaim, Activity is mapped as a one-to-one relationship. Because the UploadedClaim has two blob fields, querying those fields really slow down the performance. I'm trying to avoid selecting those fields ...