Enter your password when prompted: sudo /usr/bin/chflags nohidden /Users/ /Library Open Terminal and issue the following command to permanently unhide your user Library from Finder. If you choose the Library location you have to unhide the Library from Finder because the Java pick dialog in LibreOffice can’t see it, even with the Option key trick. Just copy the jar file to the location you choose. I chose my users Library/Application Support/Java directory. Since this is not defined in the user shell find a location to store the jar file where LibreOffice can access it, while at the same time keeping it out the Documents folder. The jar file needs to be in the CLASSPATH for the JVM. To resolve this download the MySQL Connector/J driver (platform independent) from : Įxtract the archive to get access to the jar file.
This time a new error: Unable to load MySQL JDBC driver. Now that LibreOffice doesn’t complain about Java, I tried to set up the MySQL Base application again. So I pointed Base at the MySQL database and was promptly greeted with an error: Through all the trials of software I already setup a MySQL database for the data.
Launched it and proceeded to the “Base” application which is the database application and nearly a clone of Microsoft Access. More trouble than it is worth (for me), though I did work with it in a Linux VM and liked what I saw. I also found Kexi, but it requires mild hacking to get it installed via Fink or Homebrew. Then I started looking at the open source office applications such as OpenOffice and LibreOffice. I really spent far too much time looking at them. I looked at several builder applications both web based and application, again not naming them.
Of the remaining ones (I won’t name them so none get wrongly percieved), some are slow, some don’t allow enough input form customization, some are too expensive, some don’t have enough table relationship support, and others are so new they are not yet feature rich (enough for me). There was a good one called Bento, but it was pulled from the market in 2013. There are several alternative applications out there. This doesn’t exist on the Mac except in the Office 365 package of which I have no interest and only the one application need. Basically I was looking for something like Microsoft Access. That said, it’s a lot of work! I wanted something simple and quick for this, but still need good table relationship support. I have MySQL running on my Synology NAS and have written PHP/ JavaScript/ HTTP interfaces for MySQL databases in the past. Recently I found a need to have a desktop database application for a simple database.
0 kommentar(er)
