Skip to Content
0
Former Member
Jul 25, 2017 at 08:29 AM

MYSQL getLONG error

80 Views

HI My item type is

                     <persistence type="property"/>
    </attribute>
    </attributes>
    </itemtype>

when i am running this query to get active customers in HAC it is working fine , but at API level i am getting this below error

Select {e.email} from {NewsLetterSubscription as e} where {e.subscribed}=true

Caused by: java.sql.SQLException: Invalid value for getLong() - 'sri.y2@gmail.com' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:963) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:896) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:885) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860) at com.mysql.jdbc.ResultSetImpl.getLong(ResultSetImpl.java:2711) at com.mysql.jdbc.ResultSetImpl.getLong(ResultSetImpl.java:2666) at de.hybris.platform.jdbcwrapper.ResultSetImpl.getLong(ResultSetImpl.java:249) at de.hybris.platform.persistence.property.JDBCValueMappings$ItemPropertyValueReaderWriter.readValue(JDBCValueMappings.java:889) at de.hybris.platform.persistence.property.JDBCValueMappings$ItemPropertyValueReaderWriter.readValue(JDBCValueMappings.java:1) at de.hybris.platform.persistence.property.JDBCValueMappings$AbstractValueReaderWriter.getValue(JDBCValueMappings.java:530) at de.hybris.platform.persistence.property.JDBCValueMappings.readValue(JDBCValueMappings.java:497) at de.hybris.platform.persistence.property.JDBCValueMappings.readColumns(JDBCValueMappings.java:479) at de.hybris.platform.persistence.property.JDBCValueMappings.getRows(JDBCValueMappings.java:461) at de.hybris.platform.persistence.property.JDBCValueMappings.getQueryResults(JDBCValueMappings.java:306) at de.hybris.platform.jalo.flexiblesearch.internal.FlexibleSearchExecutor.execute(FlexibleSearchExecutor.java:132)