Creating a macOS executable

The generic download does not contain a native executable for macOS. Using "Automator", you can create your own executable by following these steps:

  1. Open Automator (in the Applications folder) and select File/New from the menu.
  2. Select 'Application' as the type of document and click on 'Choose'.
  3. Under "Library" on the left, select "Utilities".
  4. Look for the "Run Shell Script" task and drag it into the open area on the right.
  5. At the bottom of the task select "Options" the check "Ignore this action's input"
  6. Cut and paste the following into text area:

    cd "/Applications/SQL Workbench" r=$(java \ --add-opens java.desktop/com.apple.laf=ALL-UNNAMED \ -cp sqlworkbench.jar:ext/* \ -Dawt.useSystemAAFontSettings=on \ -Dapple.awt.showGrowBoxtrue=true \ -Dapple.laf.useScreenMenuBar=true \ -Xmx4096m \ -Xdock:name=SQLWorkbench/J \ workbench.WbStarter 2>&1)

  7. You have to adjust the installation path on the first line of the script to match your installation location.
  8. Press Cmd-S (or select File/Save from the menu) and save the app in the Applications folder.
  9. Close Automator
  10. By default, Automator saves every app with its own icon. If you want to set an Icon to more easily identify the app then
    1. Right click on the app and select 'Get Info'
    2. Drag and drop Workbench.icns (or your own icon) over the icon at the top left corner of the info screen.
    3. Close the info screen.
    4. You will have to repeat this if you save the app with Automator again.
    5. You can drag the newly created app to the Dock for easy access.