install4j directory, In this directory create a file named prefjre.cfg if it doesn't already. In the DbVisualizer installation directory there is an. Verify this by checking in the DbVisualizer installation folder that there is no jre folder there. Use the newly created driver and format the URL in one of two ways For unsecure clusters. Make sure you are using DbVisualizer which do not bundle Java with the DbVisualizer installation. Once the driver is created in DBVisualizer, you can proceed to creating a connection. Refer to the DBVisualizer documentation for help using DBVisualizer. Create the driver using the jar file in the external location, then add a copy of the phoenix client jar back into the lib folder. Database password: leave this field blank.Afterward, press the Next button, to enter additional information about the DB. Choose Create new database connection and follow the prompts to set up the connection. You can then select the Database Driver from the available list or add a new one using the Driver Manager.The steps will be similar.Īdd the H2 db driver which is embedded in Bamboo installer:Īdd a new driver file path to /lib/h2-1.4.xxx.jar You can use any administration tool that supports embedded H2 databases. If you instead drop it in the toolbar area, the file is opened in a new SQL Commander tab. If you drop it in an editor, the file content is inserted at the caret position in the editor. Simply switch to the applicable database and run the query. You can also select a file in the platforms file browser and drop it somewhere in the DbVisualizer window. If you only need to find the location of the files for a particular database, you can query the sys.databasefiles system catalog view instead. If you need to make changes directly in the database, and you're using the H2 database, here's how you can connect to it using DBVisualizer.ĭBVisualizer is just one database administration tool. Here’s how to find the default location for data files and log files in SQL Server. Connect to the embedded H2 database using DB Visualizer

It is also highly recommended to back up your data before making any changes.

Bamboo must be shut down before accessing the H2 database.

Dbvisualizer db file location