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:
select A.ID as ID_1, B.ID as ID_2 from A join B on... where ....
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.
Feedback
Yes
No
Powered by
