I have following query that work with oracle:
SELECT * FROM Company WHERE Company.name LIKE ? AND ROWNUM <= 20;
For Test, I use HSQLDB this query fails and I have the follwing exception:
org.hsqldb.HsqlException: user lacks privilege or object not found: ROWNUM
at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.3.3.jar:2.3.3]
how can I resolve this problem?