Sybase, hibernate and pagination -
11-20-2007
, 02:20 AM
Hello,
I would like to verify whether anyone seen an issue with using syqanwhere 10
and hibernate for paging once query large tables.
I'm using the dialect org.hibernate.dialect.SybaseAnywhereDialect configured
in the Hibernate mapping files and using Hibernate paging functionality.
However I found out that the dialcet probably doesn't translate well to
Sybase paging SQL syntax (top statement) and as result hibernate fetch all
the table and manage the paging in memory.
Any ideas whether this issue is know and if there are workarounds for it?
Thanks,
Amit. |