Hibernate Community • View topic

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Blob problem

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

Kasi

Post subject: Blob problem

Posted: Mon Oct 30, 2006 6:53 pm

Newbie

Joined: Wed May 17, 2006 1:44 pm
Posts: 6

Hi,
When i use HQl I am getting an error message stating that

Quote:

ORA-00932: inconsistent datatypes: expected - got BLOB

I looked into the URL and modified code Still I am getting the same error..

http://hansonchar.blogspot.com/2005/06/oracle-blob-mapped-to-byte-in.html

I am getting this errors when I use HQL.. Example query is

Code:

select disticnt a from A a left join fetch a.bs where a.id = ?

A and B are Entitys.. B contains Blob...

Does any body have any idea how to resolve the blob issue.

thanks
kASI[/url][/quote]

Top

sudhir0104

Post subject:

Posted: Tue Oct 31, 2006 4:09 am

Regular

Joined: Mon May 08, 2006 6:00 am
Posts: 53
Location: India

Could you post the mapping file content also ?

Top

Kasi

Post subject:

Posted: Wed Nov 01, 2006 5:18 pm

Newbie

Joined: Wed May 17, 2006 1:44 pm
Posts: 6

Hi,
its working now.. the problem is "I cant use Distinct or unique with BLOB coz oracle can not compare blobs."

Thanks for the Help
Kasi

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum