HSQLDB Instance - access with other tools

1
I want to access the mendix internal dev DB to make some exports with the hsqldb tools. This works nicely: Download the hsqldb tools from their site. then goto the hsqldb dir: ./bin java -cp ../lib/hsqldb.jar org.hsqldb.util.DatabaseManagerSwing Connect like this (on Mac - on windows, the path to your mendix project DB should be there: URL: jdbc:hsqldb:hsql:/private/tmp/1124/C/Development/DA/deployment/data/database/hsqldb/MDX_Development User: mendix Passwd: m3n...... (the mendix mxadmin user password) Then you can use SQL to fix the DB etc. H
asked
3 answers
1

Choose as type: HSQL Database Engine Standalone

Use as URL: jdbc:hsqldb:file:project_location\deployment\data\database\hsqldb\database_name\database_name

Leave the user name SA and leave the password field empty.

Please note that the url ends with <name of your database>\<name of your database>.

For a new project, the database name is 'development'. In that case, a valid url can be:

jdbc:hsqldb:file:D:\Mendix\Projects\CustomerPortal\deployment\data\database\hsqldb\development\development
answered
1

Or you just go in the modeler to the console part > advanced button > 'start built-in database viewer' :)

answered
1

Ok - here is the question:

How can one use the HSQL DB manager to connect to a Mendix Dev database, if mendix does not want to start? This works:

C:\Program Files\Mendix\2.5.3\runtime>java -cp ./lib/hsqldb.jar org.hsqldb.util.DatabaseManagerSwing

But then what is the connection string?

answered