Skip to Content
1
Former Member
Jan 04, 2016 at 02:13 PM

java.sql.SQLSyntaxErrorException: incompatible data type in conversion: from SQL type VARCHAR to java.lang.Long,

940 Views

I am facing an issue which i execute below query through DAO can anybody help me please

final FlexibleSearchQuery fQuery = new FlexibleSearchQuery( "SELECT {sicj.pk},{sicj.uid} FROM {user AS sicj JOIN wishlist2 AS sij ON {sicj:pk} = {sij:user} }");

Exception :

java.sql.SQLSyntaxErrorException: incompatible data type in conversion: from SQL type VARCHAR to java.lang.Long,