Re: Searching CLOBs through Hibernate
- From: Arne Vajhøj <arne@xxxxxxxxxx>
- Date: Thu, 04 Oct 2007 21:41:00 -0400
Knut Fjellheim wrote:
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
.
- References:
- Searching CLOBs through Hibernate
- From: Knut Fjellheim
- Searching CLOBs through Hibernate
- Prev by Date: Re: com.mysql.jdbc.UpdatableResultSet.updateBlob gives AbstractMethodError
- Next by Date: [ANN] WebSQL - web based database administrator tool
- Previous by thread: Searching CLOBs through Hibernate
- Next by thread: Binding table with backened bean in JSF
- Index(es):
Relevant Pages
|
