FYI - Iam getting the values stored in a BLOB defined column(oracle.sql.BLOB@f7cb73f) in oracle table: the property is defined as a collectiontype in the my items.xml.
Please find my snippet code: final FlexibleSearchQuery query = new FlexibleSearchQuery(getOrderDBQuery(cronjob, baseStore)); final List resultClassList = new ArrayList<>();
//ce.trackAndTraceIds oracle.sql.BLOB@f7cb73f
//resultClassList.add(List.class);
//resultClassList.add(java.sql.Blob.class);
//resultClassList.add(Object.class);
resultClassList.add(String.class);
query.setResultClassList(resultClassList)
Error Logs: Flexiblesearch error: SQL search error : Invalid column type: getString not implemented for class oracle.jdbc.driver.T4CBlobAccessor query