I am trying to connect and load data into a grid. However, the servlet is reporting the following error.
com.dhtmlx.connector.ConnectorOperationException: Invalid SQL: SELECT *
FROM USER u
WHERE u.USERNAME LIKE 'John%'
ResultSet may only be accessed in a forward direction.
Seems to be a problem when using MSSQL - works fine with MySQL.
I have tried MS jdbc driver and also jTDS driver as well - both present the same error.
Can you please advise how to resolve this.