PostgreSQL JDBC driver adds an "@" symbol to an information link's auto-generated SQL query, causing the information link to fail with a syntax error.
Article ID: KB0083082
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | 7.0.x and later |
Description
When using PostgreSQL JDBC driver version 8.4.x to build information links in Spotfire, the information link's auto-generated SQL query will have the "@" symbol (also called the "at" sign) added into its FROM clause. The following is an example of such a SQL query:
Symptoms:
The presence of the "@" symbol will cause the information link to fail. When executed, the information link will display the following error:
Cause:
This issue is a known problem when using version 8.4 of the PostgreSQL JDBC driver.
==
SELECT *
FROM
"VeloDB"."processed"@"emp" n1
WHERE
<conditions>
==
Symptoms:
The presence of the "@" symbol will cause the information link to fail. When executed, the information link will display the following error:
InformationModelException at Spotfire.Dxp.Data:
Failed to execute query: ERROR: syntax error at or near "@".
This issue is a known problem when using version 8.4 of the PostgreSQL JDBC driver.
Issue/Introduction
PostgreSQL JDBC driver adds an "@" symbol to an information link's auto-generated SQL query, causing the information link to fail with a syntax error.
Resolution
There are two methods to address this behavior.
1). Manually modify the information link's default SQL query, by replacing the "@" (the "at sign") with "." (a period), so that the information link's modified SQL query, for the example shown above, looks like this:
==
SELECT *
FROM
"VeloDB"."processed"."emp" n1
WHERE
<conditions>
==
OR
2). Use a later version of the PostgreSQL JDBC driver, such as version 9.x. PostgreSQL JDBC drivers can be downloaded from the following URL:
https://jdbc.postgresql.org/download.html
Feedback
Yes
No
Powered by
