oracle « Search « JPA Q&A

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

<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" />
table column type is

2. search in blob (oracle/mssql)

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 ...