JDBC Version 1204 breaks OpenOffice/LibreOffice handling of database table views up to version 1203

From: Stefan M <cluster15(at)web(dot)de>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: JDBC Version 1204 breaks OpenOffice/LibreOffice handling of database table views up to version 1203
Date: 2015-10-26 16:21:07
Message-ID: 562E52F3.3090804@web.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello,

I use the JDBC driver to connect to a postgresql database using the base
component of OpenOffice/LibreOffice. SDBC is not an option since I need to
support Linux, MacOS and Windows. So far this worked fine (including
encryption of the database connection) - thanks to all who develop and
support the JDBC database driver.

However, the latest 1204-version of the driver broke the handling of table
views. Views were handled as read-only tables, their properties (column
names and column types) could be read out and subsequently used. With the
new version table views are recognized as views, but none of the column
names or data types are available, breaking existing forms, that check
e.g. for the correct data type.

This is independent of Java VM Version (1.7 and 1.8 tested) or whether
OpenOffice or LibreOffice is used and happens on Windows as well as Linux
(MacOS not tested so far).

Switching the JDBC driver version back to 1203 solves the issue.

Any Idea what could be the problem?

Best wishes
Stefan

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Thom Brown 2015-10-26 16:37:53 Re: Patch (2): Implement failover on libpq connect level.
Previous Message Robert Haas 2015-10-26 13:18:00 Re: Patch (3): Implement failover on libpq connect level.