I want to bring an sqlite database into Base. Java development kit is downloaded. I downloaded mysql-connector-java-5.1.23-bin.jar.zip, but cannot open it. (1) where do I get the right version for Mac and (2) what do I do with the file once I have it (e.g. where does it go)?
Know very little about Mac but here is a bit of info. On Linux have never gotten connection to SQLite using JDBC (Java connector). Only way was to use ODBC. Not sure where to get this for Mac as all I can find (without cost) is for Linux & Windows. Also, here is my post on setting up → Base: how to connect to an SQLite database?
Did a little more searching. First make sure you install Oracle JDK (Java) first. Base will not work at all without this.
Here is a post which describes how to use SQLite in OS X → Use LibreOffice Base as a GUI for an SQLite database in OS X. Link for driver is there also.
It may not be necessary to install JDK when using ODBC connector. However some functionality is lost (Report Builder, Wizards and possibly a bit more).
If this answers your question please tick the (upper left area of answer). It helps others to know there was an accepted answer.
It might be worse than it appears. See this bug report (mine!) and the comment trail under it. At the moment would-be Base users might be scuppered on OSX, but I might be missing something.
@dajare Please see edit in answer.