Hello,
I'm using hibernate and XTT Access and all is working fine.
Except if i use myQuery.getSingleResult() the query is "encapsulated" inside:
select * from ( here is my query ) where RECNO() <= ?
But the RECNO value is no good and the query doesn't return the result.
If i use the query directly (with aqua studio) it works.
How can i remove this?
Thanks in advance
|
Whether your query has more than one table?
|
It seems that we need to provide LIMIT clause support.
|
No only one table.
Using getResultList() and returning the first index is working...
|
LIMIT supported. Please redownload hibernate support package and HXTT Access package.
|
Yes it works!
Great support, thanks
|