Skip to Content
1
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 ?

244 Views

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