Searching CLOBs through Hibernate

Thread view:

Knut Fjellheim - 03 Oct 2007 08:43 GMT

What would be the best approach to achieve this?

More specifically, our customers have long description texts that need
to be searched. Are there alternative strategies that would be better
suited than trying to search CLOBs?

Reply to this Message

Arne Vajhøj - 05 Oct 2007 02:41 GMT

> What would be the best approach to achieve this?
>
> More specifically, our customers have long description texts that need
> to be searched. Are there alternative strategies that would be better
> suited than trying to search CLOBs?

I would not use Hibernate for that.

It does not sound as a typical persisted objekt.

And besides if the CLOB's are in the GB range loading
them into memory could be a problem.

Preferred solution:
1) if the database supports fulltext then use that
2) else use some more custom code (no Hibernate)

Arne

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...