Can not open confluence h2 database file

[Thomas Pauli]

Hey guy's

I would like to open the h2 database file of my confluence instance. But there aren't tables in it.

I took the database file from here: "C:\Program Files\Atlassian\Application Data\Confluence\database\h2db.mv.db".

But now when I try to open it with several tools the program always says that no tables exists in this file. Is it the correct file?

Thank your for your help.

[Angel Ruiz]

Hi Thomas,

I was able to see the tables by removing the .h2.db extension from the connection URL. I hope it helps

[Angel Ruiz]

Hi again,

I have found that accessing the H2 embedded db pointing to the file directly can cause problems when Confluence is also running. It looks like the best is to access via TCP with a URL like this:

jdbc:h2:tcp://localhost:9092//Users/.../target/confluence/home/database/h2db

[Angel Ruiz]

Please disregard this comment cause it is not working

[Angel Ruiz]

I am having the same problem trying to open the embedded H2 Confluence DB located at: /target/confluence/home/database/h2db.h2.db

I used to be able to connect to PUBLIC schema and see the tables and execute SQL queries on them

[Shannon S]

Thomas,

Per our procedure in Embedded H2 database, you can either use DBVisualizer or the Console.

Can you take a moment to confirm you are working through the steps for either process exactly as it's outlined there?

If so, and you're still having issues, then I would recommend migrating to a supported database (also available on the above article) and see if you are able to access your data that way.

Regards,

Shannon