@Basin : Let me guess, are you using LibreOffice Vanilla from the AppStore ?
If so, then you won’t be able to create any embedded hsqldb ODB files, as all Java functionality is deactivated with the LOVanilla app available from the AppStore. It won’t make any difference whether you have installed a JDK or not, the code is simply non-functional with that particular version of LO. Either create an embedded Firebird database (you need to activate the experimental options under LO Preferences), or alternatively, remove LOVanilla and download and install LO from the TDF download website, then activate recognition and selection of the JDK from within LO > Preferences > Advanced.
Re the Actual Technologies Driver, yes, you should be able to setup an ODBC connection using that driver, but it still requires you to have a database source backend, as ODBC is just the technology allowing you to access a database stored elsewhere (file, server, etc).