skip to main content
Reference : Connection Property Descriptions : EnablePagingWithOrderById
  

Try DataDirect Drivers Now

EnablePagingWithOrderById

Purpose

Specifies whether the driver can inject the Order By clause in the Select query for each JDBC call. When enabled, this property provides a stable paging mechanism for retrieving result sets that are larger than the site configured maximum number of rows.
Note: If your application does not retrieve large result sets, consider disabling this feature because adding the Order By clause can have a negative performance impact on queries.

Valid Values

true | false

Behavior

If set to true, the driver can inject the Order By clause in the Select query.
If set to false, the driver cannot inject the Order By clause in the Select query.

Default

true

Data Type

Boolean