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.

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.

Notes

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.

Data Source Methods

public Boolean getEnablePagingWithOrderById()

public void setEnablePagingWithOrderById(Boolean)

Default Value

true

Data Type

Boolean