Skip to Content
Former Member
Oct 23, 2016 at 09:48 AM

I need to set the Blob Object column value in the List object and handling with setResultClassList() of FlexibleSearchQuery ..Is there a way to achieve this ?


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

Error Logs: Flexiblesearch error: SQL search error : Invalid column type: getString not implemented for class oracle.jdbc.driver.T4CBlobAccessor query