Embedded H2 Database

To enable you to try Confluence without setting up an external database, your Confluence installation includes an embedded H2 database. 

The embedded H2 database is used by default when you choose the Trial installation path. 

The embedded database files are stored in your Confluence home directory <confluence-home>/database

The embedded H2 database is only supported while you are evaluating Confluence. You must migrate to a supported external database before using Confluence as a production system. 

To find out if you are still using the embedded database, go to  > General Configuration > Support Tools.

Connect to the embedded H2 database using DB Visualizer

DBVisualizer is just one database administration tool. You can use any administration tool that supports embedded H2 databases. The steps will be similar.

  1. Shut down Confluence.
  2. Back up your <confluence-home>/database directory.
  3. Launch DBVisualizer.
  4. Choose Create new database connection and follow the prompts to set up the connection. 
    The information you'll need is:
    • Database driver: H2 embedded 
    • Database Userid: sa
    • Database password: leave this field blank
    • Database filename:<confluence-home>/database/h2db
      (warning) leave off the .h2.db file extension.
  5. Connect to the database. 

Refer to the DBVisualizer documentation for help using DBVisualizer.

Connect to the embedded H2 database using the H2 console

Alternatively you can connect using the browser based H2 console. The easiest way to access the console is to double click the H2 database jar file at <installation-directory>\confluence\WEB-INF\lib\h2-x.x.x.jar

Last modified on Sep 10, 2017

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.