Hello,
I have the following column name: whereToBuyLink.
The data is displayed correctly in the list, but when I try to filter any column I get the following exception
Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: AND near line 1, column 72 [SELECT COUNT(*) from Product e AND e.productPK = :p0]
When I change to column name in the database for example with wereToBuyLink everything works fine.
I'm using Java and MySql
Last edit: Alex 2015-09-18
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello,
I have the following column name: whereToBuyLink.
The data is displayed correctly in the list, but when I try to filter any column I get the following exception
Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: AND near line 1, column 72 [SELECT COUNT(*) from Product e AND e.productPK = :p0]
When I change to column name in the database for example with wereToBuyLink everything works fine.
I'm using Java and MySql
Last edit: Alex 2015-09-18
Hi Alex,
Add it as a bug, please.
In the meantime, just change the property name, you can preserve the column name using @Column.
Help others in this forum as I help you.