cancel
Showing results for 
Search instead for 
Did you mean: 

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 ?

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi All,

Did anyone find answer for this issue, I'm also facing a similar issue now.

Thanks, Venkatesan