Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

embedded H2 database - how can i deactivate read-only mode ?

I have a problem with the embedded H2 database of Confluence.
I follow this link to create a local admin user for Confluence(at the moment we are using Conflunce 5.9.7. ), but I can't execute the Insert SQL because of the error "SQL-Error [90097] - The database is read only".
I've already looked and supposedly "ACCESS_MODE_DATA=rws" at the end of the JDBC URL should help. Unfortunately it does not help.

We tried the H2 console from the installation directory and DBeaver 7.

Does anyone know how I can get the database into write mode?



1 answer

I'm a little late to the party but in case anyone stumbles upon this, one reason might be the database file itself; either its read only flag is set or the system user executing the console doesn't have write permissions for it.

See here 

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Confluence Cloud

🎨 Add some visual life to your templates

Hi Atlassian Community, My name is Avni Barman, and I am a Product Manager on the Confluence Cloud team. Based on feedback from you, we are giving admins more power to create templates that a...

184 views 3 8
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you