Re: [libreoffice-users] Failed connection to MySQL database

Hi Robert,

> Hi Harvey,
> > I am running mariadb 10 on the backend. File mysql-connector-
> > java.jar
> > is registered under Options -> LibreOffice -> Advanced -> Class
> > Path at
> > /usr/share/java/
>
> For MariaDB I would use the JDBC-connector fro MariaDB, not from
> MySQL.
> You could get the connector form here:
> https://downloads.mariadb.com/Connectors/java/
> Connection to: org.mariadb.jdbc.Driver
> For connecting with drivers since version 3.0. you have to add
> ?permitMysqlScheme to the database name
> test?permitMysqlScheme
> will be the connection string for the database 'test'.
> > I'm not sure I follow what you saying about connection change. I
> > haven't changed the connection parameters nor the method. I have
> > tried
> > setting up the database with an alternative connection method (i.e
> > 'Direct'). That succeeds, but I need to transfer all my macros,
> > queries,  forms and reports from the old .odb to the new one.
>
> Couldn't you change the connection in the file, which had been
> connected 
> by JDBC?
>
> Regards
>
> Robert
> -- 
> Homepage: https://www.familiegrosskopf.de/robert
For the moment, I have discovered that the name of the file referred to
in the Class Path (or the actual file name) had been changed to 'mysql-
connector-j.jar- not by me, but possibly during the course of recent
repository updates.

All works now as before. I would not have noticed it without your
inputs, so many thanks for the tips! 

It seems wise to consider switching to mariadb connectors but for the
moment, I won't experiment with the mariadb connectors until I have
made sure that Plan Bs are in place.

Cheers
Harvey

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy