Embedded H2 URL template erased: recover original value?

Answered
Avatar
Permanently deleted user
Created

When configuring a Data Source, I selected H2. Unfortunately, I did not use the drop-down. I wanted an embedded instance, so I edited the Embedded value in the URL templates section. Sadly, I saved the changes.

Then I realized I was supposed to use the drop-down. Now if I choose an Embedded instance, I always get the specific values I entered into the template file, which makes perfect sense. I edited the template.

I understand what I did wrong. How can I restore the original value for the URL template for an Embedded H2 instance? Hopefully a full re-install of IntelliJ is not required...

I am using IntelliJ 2019.3.4

For reference, the value of the template for In-memory H2 is: jdbc:h2:mem:{database::default}?[;<;,{:identifier}={:param}>]

Votes

0

Share

1 comment
Avatar
Konstantin Annikov
Created

Here are the default URL templates for H2 database: 

 

Remote: jdbc:h2:tcp://{host::localhost}[:{port::9092}]/{database::default}[;<;,user={user:param},password={password:param},{:identifier}={:param}>]
In-memory: jdbc:h2:mem:{database::default}?[;<;,{:identifier}={:param}>]
Embeded: jdbc:h2:!(mem:)!(tcp://)[file:]{path:h2_db_file}[;<;,user={user:param},password={password:param},MV_STORE={MV_STORE:#param},{:identifier}={:param}>]

Feel free to insert them in H2 template: https://i.imgur.com/LmJPqAx.png

1

Please sign in to leave a comment.