When clicking on the fetch button on the JDBC Query palette, the output schema displays an error and does not show the output schema.
Article ID: KB0089873
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks | - |
| Not Applicable | - |
Description
Resolution:
First, check if the SQL statement has a syntax error. For instance, you can run the SQL in database client for cross checking. Second, you can move cursor over the error. It may show a detailed error message. If you join two tables A and B, and if A and B both contain a column of with the same name, you will need to give an alias name to distinguish the columns.
Example:
select A.ID as ID_1, B.ID as ID_2 from A join B on... where ....
Issue/Introduction
When clicking on the fetch button on the JDBC Query palette, the output schema displays an error and does not show the output schema.
Was this article helpful?
Yes
No
Powered by
