Package org.hibernate.community.dialect.pagination
package org.hibernate.community.dialect.pagination
-
ClassesClassDescriptionLimit handler for
AltibaseDialect.ALimitHandlerfor Apache Derby, which fully supports the ANSI SQL standard syntaxFETCH FIRST m ROWS ONLYandOFFSET n ROWS FETCH NEXT m ROWS ONLY.ALimitHandlerfor older versions of Informix, Ingres, and TimesTen, which supported the syntaxSELECT FIRST n.ALimitHandlerfor Firebird 2.5 and older which supports the syntaxFIRST n SKIP m.ALimitHandlerfor Ingres.ALimitHandlerfor HSQL prior to 2.0.ALimitHandlerfor Oracle prior to 12c, which usesROWNUM.ALimitHandlerthat works in Interbase and Firebird, using the syntaxROWS nandROWS m TO n.ALimitHandlerfor Informix which supports the syntaxSKIP m FIRST n.ALimitHandlercompatible with SQL Server 2005 and later that usestop()andrownumber().ALimitHandlerfor TimesTen, which usesROWS n, but at the start of the query instead of at the end.