Unable to view maps when using Postgres geography/geometry columns.
Article ID: KB0076556
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | All Versions |
Description
After setting up an information link containing a geography or geometry column that comes from Postgres, and following the instructions in the manual to enable the correct handling of geographic data, the result is a blank map or table column. This is due to the Postgres JDBC driver.
Symptoms:
Maps, charts or columns in tables that should render maps are blank, even though the columns are set up correctly in the Postgres database and in the Information Designer.
Cause:
Older Postgres JDBC drivers are known to cause this type of issue.
Symptoms:
Maps, charts or columns in tables that should render maps are blank, even though the columns are set up correctly in the Postgres database and in the Information Designer.
Cause:
Older Postgres JDBC drivers are known to cause this type of issue.
Issue/Introduction
Unable to view maps when using Postgres geography/geometry columns.
Resolution
Upgrade to the latest Postgres JDBC driver:
1). Copy the latest Postgres JDBC driver to the <server install directory>\tomcat\lib (default C:\tibco\tss\X.X.X\tomcat\lib where X.X.X is the server version).
2). Remove any old Postgres drivers.
3). Restart the server.
Confirmed to work when using the driver 'postgresql-9.4-1201.jdbc4.jar'.
1). Copy the latest Postgres JDBC driver to the <server install directory>\tomcat\lib (default C:\tibco\tss\X.X.X\tomcat\lib where X.X.X is the server version).
2). Remove any old Postgres drivers.
3). Restart the server.
Confirmed to work when using the driver 'postgresql-9.4-1201.jdbc4.jar'.
Additional Information
https://jdbc.postgresql.org/
Feedback
Yes
No
Powered by
