dbTalk Databases Forums  

Sybase, hibernate and pagination

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss Sybase, hibernate and pagination in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Amit Tropper
 
Posts: n/a

Default 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.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.