Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

There are two methods to connect to a MySQL/MariaDB database using JDBC. One method works perfectly. The other method appears to work, in that you can edit your tables, but it does not allow editing relationships, and furthermore linked sub-forms don't work as expected.

So when setting up your connected database do not choose JDBC directly, rather first choose MySQL, then in the next screen choose JDBC and proceed from there.

image description

I have a more complete answer to document this here.

Note, ODBC is broken down with a known bug and has to my knowledge not yet been fixed. Also I noticed that after upgrading to LO 5.3.0.3, the native MySQL connector option is gone.

There are two methods to connect to a MySQL/MariaDB database using JDBC. One method works perfectly. The other method appears to work, in that you can edit your tables, but it does not allow editing relationships, and furthermore linked sub-forms don't work as expected.

So when setting up your connected database do not choose JDBC directly, rather first choose MySQL, then in the next screen choose JDBC and proceed from there.

image description

I have a more complete answer to document this here.

Note, Notes

  • ODBC is broken down with a known bug and has to my knowledge not yet been fixed.

  • Also I noticed that after upgrading to LO 5.3.0.3, the native MySQL connector option is gone.

    .

  • And unlike MS Access the relationship editor when used w/ MySQL/MariaDB only appears to work with InnoDB database engine databases (i.e. it won't work with ISAM databases.) In other words it does not allow table-to-table relationships to be set up unless there is underlying relationship support in the database engine. The reason one might want to connect to and use ISAM is because it is much faster than InnoDB, like for example if you are using it under a web site, and trying to use LO as a development front end.