Date Posted:
Product: TIBCO Spotfire®
Product: TIBCO Spotfire®
Problem:
Unable to view maps when using Postgres geography/geometry columns.
Solution:
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.
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'.
https://jdbc.postgresql.org/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'.