Connect SQL adds 'UNKNOWN_COLUMN_0' error in clipboard
When using Connect-SQL to retrieve data from external HP SQL/MX non stop database, an error message is added to the Clipboard page ResultsPage.pxResults(1):
.UNKNOWN_COLUMN_0: Column number 0 has an invalid name.
SQL is executed successfully and values are mapped to the clipboard irrespective of the above message in the clipboard.
Error in the Clipoboard page 'UNKNOWN_COLUMN_0: Column number 0 has an invalid name.'
Steps to Reproduce
Connect to SQLMX database with a select query and the result is not populated correctly
A third-party product issue. as per the jdbc type 4 driver specification, getColumnLabel() should return the column name but it is not. code changes are made at engine level to retrieve column name using 'getColumnName()' if 'getColumnLabel()' returns empty.
0% found this useful