Sign Up

Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.

Have an account? Sign In

Have an account? Sign In Now

Sign In

Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.

Sign Up Here

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

You must login to ask question.

Forgot Password?

Need An Account, Sign Up Here

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Sign InSign Up

StackOverflow Point

StackOverflow Point Navigation

  • Web Stories
  • Badges
  • Tags
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Web Stories
  • Badges
  • Tags
Home/ Questions/Q 1874
Alex Hales
  • 0
Alex HalesTeacher
Asked: May 31, 20222022-05-31T05:42:56+00:00 2022-05-31T05:42:56+00:00

microservices – Database “C:/data/sample” not found, and IFEXISTS=true, so we cant auto-create it – Error in Spring Boot

  • 0

[ad_1]

This is an incorrect error message that appears only in 1.4.198 and 1.4.199. The next version of H2 (1.4.200) will show a better message like

Database … not found, either pre-create it or allow remote database creation (not recommended in secure environments)

You see this error message because your database doesn’t exist yet. The normal way to fix your problem is to create the database first with your application before trying to login into it with H2 Console.

H2 Console can be configured to allow database creation, but it may create a security hole in your system, anyone who can open this page may do anything with your system with yours access permissions in such configuration.

Note that H2 Console in browser’s session launched by H2 from its icon in the system tray (you can simply launch the h2-1.4.199 jar as Java application, or use java -jar h2-1.4.199.jar) gives you permission to create a new database in secure way. You can use it for that purpose. If you’re not planning to use it as a TCP Server, close it from the system tray icon after database creation to make sure that it doesn’t hold your database. You can also use the command-line Shell tool:
https://h2database.com/html/tutorial.html#creating_new_databases

H2 Console from the Spring doesn’t ship with such feature.

Older versions of H2 (up to 1.4.197) also allow the database creation, including the console from the Spring, but, again, it creates a security hole in you system.

[ad_2]

  • 0 0 Answers
  • 4 Views
  • 0 Followers
  • 0
Share
  • Facebook
  • Report
Leave an answer

Leave an answer
Cancel reply

Browse

Sidebar

Ask A Question

Related Questions

  • xcode - Can you build dynamic libraries for iOS and ...

    • 0 Answers
  • bash - How to check if a process id (PID) ...

    • 4995 Answers
  • database - Oracle: Changing VARCHAR2 column to CLOB

    • 1084 Answers
  • What's the difference between HEAD, working tree and index, in ...

    • 1028 Answers
  • Amazon EC2 Free tier - how many instances can I ...

    • 0 Answers

Stats

  • Questions : 43k

Subscribe

Login

Forgot Password?

Footer

Follow

© 2022 Stackoverflow Point. All Rights Reserved.

Insert/edit link

Enter the destination URL

Or link to existing content

    No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.