Index: grails-app/services/com/lemans/ds/product/ProductService.groovy =================================================================== diff -u -r065541de6663f1d509fb9446cc38b4b8b180c29a -r5a285a972a74dac967b7983313ab90ebd23d474f --- grails-app/services/com/lemans/ds/product/ProductService.groovy (.../ProductService.groovy) (revision 065541de6663f1d509fb9446cc38b4b8b180c29a) +++ grails-app/services/com/lemans/ds/product/ProductService.groovy (.../ProductService.groovy) (revision 5a285a972a74dac967b7983313ab90ebd23d474f) @@ -3,6 +3,7 @@ import com.lemans.services.LemansService import grails.transaction.Transactional import groovy.json.JsonSlurper +import net.sourceforge.jtds.jdbc.ClobImpl @Transactional(readOnly = true) class ProductService extends LemansService { @@ -317,14 +318,15 @@ } private Map transformClobAndGroup(List data, String name) { - if (name in ['COMMON_ATTRIBUTES', 'MISSING_FITMENTS']) { - data.collect { Map m -> - [attribute: m.combinedAttributeValue?.asciiStream?.text, partNumber: m.partNumber] }.groupBy { it.attribute } - } else { - data.collect { Map m -> - [attribute: m.combinedAttributeValue?.asciiStream?.text, partNumber: m.partNumber, modelName: m.modelName, year: m.year] - }.groupBy { it.attribute } - } + data.collect { Map m -> + m = transformClobToText(m) + Map result = [attribute: m.combinedAttributeValue, partNumber: m.partNumber] + if (name in ['COMMON_ATTRIBUTES', 'MISSING_FITMENTS']) { + result.modelName = m.modelName + result.year = m.year + } + result + }.groupBy { it.attribute } } private Map transformClobToText(Map data) {