oracle « Search « JPA Q&A





1. Search Oracle date type column with hibernate, seach by everything in that day - ignore the time    stackoverflow.com

<property name="batchCreatedDate" type="java.util.Date">
  <meta attribute="field-description">batch create date</meta>
  <column name="BATCH_CREATED_DATE" length="7" not-null="true" />
</property>
table column type is
BATCH_CREATED_DATE  DATE            ...

2. search in blob (oracle/mssql)    forum.hibernate.org

Hi, I need help with searching in BLOB. I have schema, where one column is BLOB and customer wants to search in it. This is possible to do it in SQL by using extra (vendor dependent) functions (Oracle contains(...), MSSQL containstable(...) ). Of course there are some extra DB setup - preparing full text index etc. Is in the hibernate any ...