I tried read data from HSQL database with multiple tools and with all tools I can read system tables but it seams that there is no other table in the file.
I open the prodDb file as data source and use the user “sa” with no password.
Can you help me finding the correct way to see my data?
Thanks in advance
Versions 7.* don’t use HSQL by default, but H2 instead. Thus, you have to pick an H2 driver in the tools you tried.
The user / password you tried are correct. By the way, you may notice that these credentials are far from secure, that is part of the reason why we strongly recommend switching to an external DBMS. The other reason is that the storage system of H2 is more prone to loosing data than other DBMS.
I am using V7.
Thanks for the information.
It is now working with DBeaver and H2 driver.
Just for everybody know that HSQL tools is showing system tables even if it doesn’t find any database, which makes you feeling that you are opening the database. However, it is creating a new database with HSQL format which differs from H2 and is not stored in the same files.