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

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


1205 will fix the issue


On 26 October 2015 at 12:21, Stefan M <cluster15@web.de> wrote:
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


--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc

Great news.  Thanks

Am 26.10.2015 um 19:27 schrieb Dave Cramer:
> 1205 will fix the issue
>
> Dave Cramer
>
> davec@postgresintl.com <mailto:davec@postgresintl.com>
> www.postgresintl.com <http://www.postgresintl.com>
>
> On 26 October 2015 at 12:21, Stefan M <cluster15@web.de
> <mailto:cluster15@web.de>> wrote:
>
>     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
>
>
>     --
>     Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org
>     <mailto:pgsql-jdbc@postgresql.org>)
>     To make changes to your subscription:
>     http://www.postgresql.org/mailpref/pgsql-jdbc
>
>