Re: [libreoffice-users] MariaDB Connector Question

2023-05-22 Thread Robert Großkopf

Hi LAP,


However, only the JDBC connector will connect to the specified
database.  The ODBC and C connectors will connect to _all_ the
databases that are present in the MariaDB database directory, i.e.
all tables from all databases are shown.


Not all databases. All the data you are allowed (from your MariaDB) to 
connect to.




Why does only the JDBC connector actually connect to the specified
database?


When connecting here with org.mariadb.jdbc.Driver there are also shown 
all databases I am allowed to read data. Tested with 
mariadb-java-client-3.1.3.jar, LO 7.5.3.2 on OpenSUSE 15.4 64bit rpm Linux.


Go to Tools → Table Filter… and deactivate the databases you do not want 
to see. Go to View  → Refresh Tables and the databases won't be shown 
any more.


Is this normal behavior or is this a bug?


Why should this be a bug. You could connect to different databases with 
this connection. Some people use this to copy data from one database to 
another, to switch during one connection …


Regards

Robert
--
Homepage: https://www.familiegrosskopf.de/robert


--
To unsubscribe e-mail to: users+unsubscr...@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


[libreoffice-users] MariaDB Connector Question

2023-05-22 Thread LAP
LibreOffice Base can connect to a MariaDB database using one
of three connectors:

JDBC
ODBC
C connector

Setting up a connection using any of the above requires
specifying the name of MariaDB database with which to connect.

However, only the JDBC connector will connect to the specified
database.  The ODBC and C connectors will connect to _all_ the
databases that are present in the MariaDB database directory, i.e.
all tables from all databases are shown.

Why does only the JDBC connector actually connect to the specified
database?

Is this normal behavior or is this a bug?

My system is GNU/Linux with the latest LO.



-- 
To unsubscribe e-mail to: users+unsubscr...@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