Skip to Content
1
Former Member
Jul 29, 2015 at 09:44 AM

Query Running in FlexSearch but Through DAO Layer Exception is raising incompatible data type in conversion: from SQL type VARCHAR to java.lang.Long

851 Views

SELECT {p1.code},{p2.price},{p5.name},{p4.isocode} FROM {Product AS p1 JOIN PriceRow AS p2 ON {p1.code} = {p2.productId} JOIN CatalogVersion AS p3 ON {p3.pk} = {p1.catalogVersion} JOIN Currency AS p4 ON {p4.pk} = {p2.currency} JOIN Catalog AS p5 ON {p3.catalog} = {p5.pk} and {p3.version} = 'Online' and {p4.base} = '1'}

above Query is executes through flexsearch but I am getting error when running through java .

Error is : Caused by: de.hybris.platform.jalo.flexiblesearch.FlexibleSearchException: SQL search error : incompatible data type in conversion: from SQL type VARCHAR to java.lang.Long, value: 74036_red