Sdbc Driver

Posted onby admin
Sdbc Driver

Notable changes

No Sdbc Driver Was Found For The Given Url

Changed

  • Now the driver uses SASLprep normalization for SCRAM authentication fixing some issues with spaces in passwords.
  • Fix: Actually close unclosed results. Previously was not closing the first unclosed result fixes #1903 (#1905)There is a small behaviour change here as a result. If closeOnCompletion is called on an existing statement and the statementis executed a second time it will fail.

PostgreSQL: The postgresql SDBC Driver allows to use the postgresql database from OpenOffice.org without any other wrapper layer such as odbc or jdbc.: Linux MDB: This driver (which is in development) uses the MDBTools to provide (read) access to Microsoft Access files to Linux users of OpenOffice.org.: SQLite: This SDBC driver (currently in alpha state) is dedicated to giving OpenOffice.org. Download a JDBC driver for MySQL (for example, the Connector/J driver).; If the file that you downloaded is in an archive format (for example,.zip,.tar.gz, and so on), extract its contents. Copy the.jar file from the extracted contents to a location on your hard disk drive.

Added

  • Verify code via forbidden-apis (jdk-internal and jdk-non-portable signatures) PR #2012

Fixed

  • Fix: properly set cancel socket timeout (#2044)
  • Fix 'Required class information missing' when old org.jboss:jandex parses pgjdbc classes [issue 2008][https://github.com/pgjdbc/pgjdbc/issues/2008]
  • Fix PGCopyInputStream returning the last row twice when reading with CopyOut API [issue 2016][https://github.com/pgjdbc/pgjdbc/issues/2016]
  • Fix Connnection.isValid() to not wait longer than existing network timeout PR #2040
  • Fix Passwords with spaces (ASCII and non-ASCII) now work with SCRAM authentication (driver now uses SASLprep normalization) PR #2052
  • Fix DatabaseMetaData.getTablePrivileges() to include views, materialized views, and foreign tables PR #2049
Project Sections: Home Specifications QA Development Database Drivers
Database drivers: PostgreSQL Linux MDB SQLite

There are several database drivers available which enable you to access certain database types which OpenOffice.org does not have native support for. Those drivers are not (yet) part of the 'official' OpenOffice.org distributions, but hosted here. If you like bleeding edge technology, download the driver if your choice, try it out, and give feedback to the author or in our development mailing list!

Note that not even the authors of the drivers would, usually, call the current versions 'production quality', so the least thing you should have is a good backup.

PostgreSQL
The postgresql SDBC Driver allows to use the postgresql database from OpenOffice.org without any other wrapper layer such as odbc or jdbc.
Linux MDB
This driver (which is in development) uses the MDBTools to provide (read) access to Microsoft Access files to Linux users of OpenOffice.org.
SQLite
This SDBC driver (currently in alpha state) is dedicated to giving OpenOffice.org native access to SQLite databases.

Sdbc Driver Libreoffice