Styjun

If your plane is out-of-control, why does military training instruct releasing the joystick to neutralize controls?

The monorail explodes before I can get on it

Who has taken "my" Managed package namespace? Can we find out?

What is the best way to stacked subscripts for a matrix?

Is Arc Length always irrational between two rational points?

How can I deal with a player trying to insert real-world mythology into my homebrew setting?

How did the hit man miss?

Book where the stars go black due to aliens stopping human observation collapsing quantum possibilities

Do you know your 'KVZ's?

What was the definition of "set" that resulted in Russell's Paradox

Machine learning and operations research projects

Are randomly-generated passwords starting with "a" less secure?

What's the minimum number of sensors for a hobby GPS waypoint-following UAV?

What does "it kind of works out" mean?

How can I get a player to accept that they should stop trying to pull stunts without thinking them through first?

How can one write good dialogue in a story without sounding wooden?

Can fluent English speakers distinguish “steel”, “still” and “steal”?

In Parshas Chukas, why is first mention of Parah Adumah "פָרָה" instead of "פָּרָה"?

Shortest distance around a pyramid?

How to know whether a Tamron lens is compatible with Canon EOS 60D?

A pyramid from a square

Professor falsely accusing me of cheating in a class he does not teach, two months after end of the class. What precautions should I take?

What explains 9 speed cassettes price differences?

Is lack of functional requirements agile?

I am getting error after opening the h2 database console, i enter database name but it is showing database not found errir

Where to add the -ifNotExists flag to h2 start command?Heap space error and H2 database corruptionh2 sql, create table with multi-column primary key?No response, while connecting to the databaseNot able to access the tables from H2 database using JavaGeneric error [50000-175] caused by NullPointerExceptionDatabase error after upgrading Grails from 2.3 to 2.4 versionUnable to run org.h2.tools.Script from command line in AUTOSERVER modeCaused by: org.h2.jdbc.JdbcSQLException: Function “TO_TIMESTAMP” not found; SQL statement:Hibernate H2 database not foundWhen i create a H2 Database its throws Error “DataBase Not Created”?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

3

Database "C:/Users/Barlekar/onlineshoppings" not found, and IFEXISTS=true, so we cant auto-create it [90146-199] 90146/90146 (Help)
org.h2.jdbc.JdbcSQLNonTransientConnectionException: Database "C:/Users/Barlekar/onlineshoppings" not found, and IFEXISTS=true, so we cant auto-create it [90146-199]

h2

share|improve this question

asked Mar 26 at 3:20

sonal barlekarsonal barlekar

2611 silver badge22 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Try previous version 1.4.198. I also had the problems after updateing from [1.4.188] to [1.4.199], but [1.4.198] works fine for me.
  
  – Yuriy Balakhonov
  May 21 at 12:49
  

  
  
  
  

add a comment | 

3

Database "C:/Users/Barlekar/onlineshoppings" not found, and IFEXISTS=true, so we cant auto-create it [90146-199] 90146/90146 (Help)
org.h2.jdbc.JdbcSQLNonTransientConnectionException: Database "C:/Users/Barlekar/onlineshoppings" not found, and IFEXISTS=true, so we cant auto-create it [90146-199]

h2

share|improve this question

asked Mar 26 at 3:20

sonal barlekarsonal barlekar

2611 silver badge22 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Try previous version 1.4.198. I also had the problems after updateing from [1.4.188] to [1.4.199], but [1.4.198] works fine for me.
  
  – Yuriy Balakhonov
  May 21 at 12:49
  

  
  
  
  

add a comment | 

Database "C:/Users/Barlekar/onlineshoppings" not found, and IFEXISTS=true, so we cant auto-create it [90146-199] 90146/90146 (Help)
org.h2.jdbc.JdbcSQLNonTransientConnectionException: Database "C:/Users/Barlekar/onlineshoppings" not found, and IFEXISTS=true, so we cant auto-create it [90146-199]

h2

share|improve this question

asked Mar 26 at 3:20

sonal barlekarsonal barlekar

2611 silver badge22 bronze badges

share|improve this question

asked Mar 26 at 3:20

sonal barlekarsonal barlekar

2611 silver badge22 bronze badges

share|improve this question

asked Mar 26 at 3:20

sonal barlekarsonal barlekar

2611 silver badge22 bronze badges

asked Mar 26 at 3:20

sonal barlekarsonal barlekar

2611 silver badge22 bronze badges

asked Mar 26 at 3:20

sonal barlekarsonal barlekar

2611 silver badge22 bronze badges

3 Answers
3

active

oldest

votes

6

Use a pre-2019 version of the H2 database dependency that auto-creates the database every time you run your standalone application. For example version 1.4.193. Your pom.xml should include this dependency:

<dependency>
 <groupId>com.h2database</groupId>
 <artifactId>h2</artifactId>
 <version>1.4.193</version>
</dependency>

share|improve this answer

answered Apr 16 at 4:57

Shaun DashjianShaun Dashjian

16011 silver badge1010 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Problematic if you'd like to have features available on later versions.
  
  – AlikElzin-kilaka
  Jun 6 at 7:05
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I agree with @AlikElzin-kilaka. This cannot be the solution. I don't set the H2 version because I prefer it to be dependent on the version of Spring Boot I am using.
  
  – AnonymousAngelo
  Jun 26 at 8:16
  

  
  
  
  

add a comment | 

3

Have you upgraded H2 by any chance?

I think this is related to the following H2 commit:

https://github.com/h2database/h2database/commit/8b53f3999c6c5c3d5ca29020e2657968f4f59ec4

and this change was made because of the following exploit:

https://www.exploit-db.com/exploits/45506

This means that the default for H2 is now to not auto-create databases when run in standalone network mode.

If you have read and understood the above, and you still want to allow the database to be auto-created, then just add the -ifNotExists flag to your h2 start command (your java -cp ... command).

share|improve this answer

answered Mar 27 at 0:43

joelittlejohnjoelittlejohn

9,74122 gold badges3232 silver badges4949 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Please give us the solution.
  
  – Bandham Manikanta
  May 18 at 16:16
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @BandhamManikanta As I wrote in the answer, just add -ifNotExists to the command you use to start h2.
  
  – joelittlejohn
  Jun 5 at 15:46
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @joelittlejohn, I have tried adding -ifNotExists to my IntelliJ runtime configuration (under "Program arguments"), but it does not seem to work. Am I doing something wrong?
  
  – AnonymousAngelo
  Jun 26 at 8:19
  

  
  
  
  

add a comment | 

3

If you are dealing with the Spring Boot project, please change the JDBC URL jdbc:h2:~/test to jdbc:h2:mem:testdb in the login page, which is the default URL configured by Spring Boot.

share|improve this answer

edited Jun 11 at 8:18

answered Jun 11 at 8:03

Ivan XueIvan Xue

3133 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Worked flawlessly! Many thanks
  
  – xilef
  Jul 1 at 11:24
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55349373%2fi-am-getting-error-after-opening-the-h2-database-console-i-enter-database-name%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

6

Use a pre-2019 version of the H2 database dependency that auto-creates the database every time you run your standalone application. For example version 1.4.193. Your pom.xml should include this dependency:

<dependency>
 <groupId>com.h2database</groupId>
 <artifactId>h2</artifactId>
 <version>1.4.193</version>
</dependency>

share|improve this answer

answered Apr 16 at 4:57

Shaun DashjianShaun Dashjian

16011 silver badge1010 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Problematic if you'd like to have features available on later versions.
  
  – AlikElzin-kilaka
  Jun 6 at 7:05
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I agree with @AlikElzin-kilaka. This cannot be the solution. I don't set the H2 version because I prefer it to be dependent on the version of Spring Boot I am using.
  
  – AnonymousAngelo
  Jun 26 at 8:16
  

  
  
  
  

add a comment | 

6

Use a pre-2019 version of the H2 database dependency that auto-creates the database every time you run your standalone application. For example version 1.4.193. Your pom.xml should include this dependency:

<dependency>
 <groupId>com.h2database</groupId>
 <artifactId>h2</artifactId>
 <version>1.4.193</version>
</dependency>

share|improve this answer

answered Apr 16 at 4:57

Shaun DashjianShaun Dashjian

16011 silver badge1010 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Problematic if you'd like to have features available on later versions.
  
  – AlikElzin-kilaka
  Jun 6 at 7:05
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I agree with @AlikElzin-kilaka. This cannot be the solution. I don't set the H2 version because I prefer it to be dependent on the version of Spring Boot I am using.
  
  – AnonymousAngelo
  Jun 26 at 8:16
  

  
  
  
  

add a comment | 

Use a pre-2019 version of the H2 database dependency that auto-creates the database every time you run your standalone application. For example version 1.4.193. Your pom.xml should include this dependency:

<dependency>
 <groupId>com.h2database</groupId>
 <artifactId>h2</artifactId>
 <version>1.4.193</version>
</dependency>

share|improve this answer

answered Apr 16 at 4:57

Shaun DashjianShaun Dashjian

16011 silver badge1010 bronze badges

<dependency>
 <groupId>com.h2database</groupId>
 <artifactId>h2</artifactId>
 <version>1.4.193</version>
</dependency>

share|improve this answer

answered Apr 16 at 4:57

Shaun DashjianShaun Dashjian

16011 silver badge1010 bronze badges

answered Apr 16 at 4:57

Shaun DashjianShaun Dashjian

16011 silver badge1010 bronze badges

answered Apr 16 at 4:57

Shaun DashjianShaun Dashjian

16011 silver badge1010 bronze badges

3

Have you upgraded H2 by any chance?

I think this is related to the following H2 commit:

https://github.com/h2database/h2database/commit/8b53f3999c6c5c3d5ca29020e2657968f4f59ec4

and this change was made because of the following exploit:

https://www.exploit-db.com/exploits/45506

This means that the default for H2 is now to not auto-create databases when run in standalone network mode.

If you have read and understood the above, and you still want to allow the database to be auto-created, then just add the -ifNotExists flag to your h2 start command (your java -cp ... command).

share|improve this answer

answered Mar 27 at 0:43

joelittlejohnjoelittlejohn

9,74122 gold badges3232 silver badges4949 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Please give us the solution.
  
  – Bandham Manikanta
  May 18 at 16:16
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @BandhamManikanta As I wrote in the answer, just add -ifNotExists to the command you use to start h2.
  
  – joelittlejohn
  Jun 5 at 15:46
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @joelittlejohn, I have tried adding -ifNotExists to my IntelliJ runtime configuration (under "Program arguments"), but it does not seem to work. Am I doing something wrong?
  
  – AnonymousAngelo
  Jun 26 at 8:19
  

  
  
  
  

add a comment | 

3

Have you upgraded H2 by any chance?

I think this is related to the following H2 commit:

https://github.com/h2database/h2database/commit/8b53f3999c6c5c3d5ca29020e2657968f4f59ec4

and this change was made because of the following exploit:

https://www.exploit-db.com/exploits/45506

This means that the default for H2 is now to not auto-create databases when run in standalone network mode.

If you have read and understood the above, and you still want to allow the database to be auto-created, then just add the -ifNotExists flag to your h2 start command (your java -cp ... command).

share|improve this answer

answered Mar 27 at 0:43

joelittlejohnjoelittlejohn

9,74122 gold badges3232 silver badges4949 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Please give us the solution.
  
  – Bandham Manikanta
  May 18 at 16:16
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @BandhamManikanta As I wrote in the answer, just add -ifNotExists to the command you use to start h2.
  
  – joelittlejohn
  Jun 5 at 15:46
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @joelittlejohn, I have tried adding -ifNotExists to my IntelliJ runtime configuration (under "Program arguments"), but it does not seem to work. Am I doing something wrong?
  
  – AnonymousAngelo
  Jun 26 at 8:19
  

  
  
  
  

add a comment | 

Have you upgraded H2 by any chance?

I think this is related to the following H2 commit:

https://github.com/h2database/h2database/commit/8b53f3999c6c5c3d5ca29020e2657968f4f59ec4

and this change was made because of the following exploit:

https://www.exploit-db.com/exploits/45506

This means that the default for H2 is now to not auto-create databases when run in standalone network mode.

If you have read and understood the above, and you still want to allow the database to be auto-created, then just add the -ifNotExists flag to your h2 start command (your java -cp ... command).

share|improve this answer

answered Mar 27 at 0:43

joelittlejohnjoelittlejohn

9,74122 gold badges3232 silver badges4949 bronze badges

share|improve this answer

answered Mar 27 at 0:43

joelittlejohnjoelittlejohn

9,74122 gold badges3232 silver badges4949 bronze badges

answered Mar 27 at 0:43

joelittlejohnjoelittlejohn

9,74122 gold badges3232 silver badges4949 bronze badges

answered Mar 27 at 0:43

joelittlejohnjoelittlejohn

9,74122 gold badges3232 silver badges4949 bronze badges

3

If you are dealing with the Spring Boot project, please change the JDBC URL jdbc:h2:~/test to jdbc:h2:mem:testdb in the login page, which is the default URL configured by Spring Boot.

share|improve this answer

edited Jun 11 at 8:18

answered Jun 11 at 8:03

Ivan XueIvan Xue

3133 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Worked flawlessly! Many thanks
  
  – xilef
  Jul 1 at 11:24
  

  
  
  
  

add a comment | 

3

If you are dealing with the Spring Boot project, please change the JDBC URL jdbc:h2:~/test to jdbc:h2:mem:testdb in the login page, which is the default URL configured by Spring Boot.

share|improve this answer

edited Jun 11 at 8:18

answered Jun 11 at 8:03

Ivan XueIvan Xue

3133 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Worked flawlessly! Many thanks
  
  – xilef
  Jul 1 at 11:24
  

  
  
  
  

add a comment | 

If you are dealing with the Spring Boot project, please change the JDBC URL jdbc:h2:~/test to jdbc:h2:mem:testdb in the login page, which is the default URL configured by Spring Boot.

share|improve this answer

edited Jun 11 at 8:18

answered Jun 11 at 8:03

Ivan XueIvan Xue

3133 bronze badges

share|improve this answer

edited Jun 11 at 8:18

answered Jun 11 at 8:03

Ivan XueIvan Xue

3133 bronze badges

answered Jun 11 at 8:03

Ivan XueIvan Xue

3133 bronze badges

answered Jun 11 at 8:03

Ivan XueIvan Xue

3133 bronze badges