Next step will be to implement the binary import and create unit tests for all.Chapter 4. Currently, as the binary import is not ready yet, the result of the migration is some empty tables mostly. The migration can be enabled using DBACCESS_HSQL_MIGRATION=1 when starting A modification is needed in statements which contain column definitions (since the types typically differ in different systems), and there are some HSQLDB specific keywords too (e.g. The new library reads these SQL statements line-by-line, transforms it a little, and then executes them using the sdbc driver. This file consists of DDL statements in a strict format.

The database schema is zipped into the odf file in a text file called “script”. Splitting it to subtasks, I decided to implement the schema import first. Technically it means a new library in module “dbaccess”, which does all the import, and which is used in the dba (core) library when creating connection. For example the impossibility to copy integer values from Calc to Base (tdf#70425) is fixed by allowing the driver to set numerical values even with the setString method, when it is called on a column with numerical type (int, smallint, etc.).Īfter that, in order to prepare the removal of the legacy java-based DBMS, it is needed to create a way to import the database schema and the binary data stored in older odf files without Java.

Really big, I implemented this as a subtype of BLOB.īesides that, to prevent the changing of the DBMS back end being a setback, there were some bugs with high priority to fix. This type is responsible for holding images. That it stores binary format, and it is needed to indicate that no character These types can be created as a CHAR/VARCHARįield with a special character set called OCTETS.

LONGVARCHAR, implemented as a BLOB holding text in Firebird context.

Within this context I implemented those types which could be created with the HSQLDB driver, but not with Firebird. In this post I would like to explain what steps are made at Collabora so far to achieve this goal.īefore dealing with the compatibility of the old HSQLDB-based odf files, an improvement had to be made on the Firebird driver. The goal here is to implement the import of HSQLDB databases without Java Runtime Environment, in order to facilitate the change-over toįirebird. TDF has published tenders to improve LibreOffice in some areas, including its database management program, Base.

Libreoffice base firebird