skip to main content
DataDirect Connect Drivers : MySQL Driver : Connection Properties : InOrderColumnAccess
  
InOrderColumnAccess
Purpose
Determines whether the driver caches column values for the current row, which allows an application to access the column values in any order.
Valid Values
true | false
Behavior
If set to true, the driver does not cache column values for the current row. Applications must retrieve the column values in the order that they are listed in the result set. Once a value is retrieved, it cannot be retrieved again. For example, suppose an application selects the following rows:
SELECT last_name, first_name, emp_ID FROM Employees
The application must retrieve column values for last_name, first_name, and emp_ID for the current row in the order they appear in the result set. Because the driver does not need to cache the column values, performance is improved. If an application attempts to access column values in an order other than the order in which they appear in the result set, the driver throws an exception. For example, if the application attempts to access the column value for emp_ID and then last_name, the driver throws an exception when the application attempts to access the column value for last_name.
If set to false, the driver caches column values for the current row. Columns of the current row can be accessed in any order.
Default
false
Data Type
boolean
See also
Performance Considerations