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