...
When configuring either a JDBC authority connector or a JDBC repository connector, in the ‘Database Type’ tab you have to select an ‘Access Method’. The access method serves to find the columns in the resultsets by name or by label, . “by name” will search for original column name whereas the “by label” option will search for the column label. A column label is by default the original column name if there is no mapping (e.g ‘SELECT id AS doc_id’ is a mapping of the original column name ‘id’ to the mapping name ‘doc_id’), if a mapping is defined, then the label will be the mapping name. In our case we definitely want to use labels instead of original column names, so ALWAYS USE the “by label” access method !
...