Custom Key Attribute

The SQL connector framework supports custom key attribute name. The mandatory KEY attribute need not be named KEY always. It can be set to any other name, for example, ID. For a key attribute that is not named KEY, you need to change the JDBC driver information in the drivers.properties file (located at $OH/search/lib/plugins/oracleapplications) to specify the key attribute name: database_name: driver_class_name, key_attribute_name

For example, for a key attribute named ID:
oracle : oracle.jdbc.driver.OracleDriver, ID

The crawling query can then be as follows:
SELECT keyval ID, content, url, lastmodifieddate, lang FROM sales_only