title: (Spring Boot and H2) Can't use h2 database
body: <p>I'm learning Spring boot and I'm trying to create a very simple RESTful API that access an in-memory database and perform CRUD actions.</p>
  
  <p>However, everytime I try to Connect or Test Connection on <a href="http://localhost:8080/h2-console" rel="nofollow noreferrer">http://localhost:8080/h2-console</a>, I get this error:</p>
  
  <p>"Database "C:/Users/XXX/test" not found, and IFEXISTS=true, so we cant auto-create it [90146-199] 90146/90146"</p>
  
  <p><a href="https://imgur.com/a/oYgkK1C" rel="nofollow noreferrer">https://imgur.com/a/oYgkK1C</a></p>
  
  <p>I followed EXACTLY the instructions from <a href="http://www.springboottutorial.com/spring-boot-crud-rest-service-with-jpa-hibernate" rel="nofollow noreferrer">http://www.springboottutorial.com/spring-boot-crud-rest-service-with-jpa-hibernate</a>. I have tried everything I could find online: using jdbc:h2:mem:test as JDBC URL etc, but none of them worked for me and I'm not sure what am I doing wrong. 
  I didn't install h2 database from the official website as I read it is not necessary to use the in-memory module (and I still don't know if I should've installed it or not, as there is not a single mention of it online, as far as I checked).</p>
  
  <p>Any thoughts? I'm a beginner when it comes to Spring Boot and I'm really lost. I just want to test CRUD actions and I don't care about the persistence of the DB.</p>
  
  <p>I have provided my application.properties below.</p>
  
  <p>Thank you! :)</p>
  
  <pre><code># H2
  spring.h2.console.enabled=true
  spring.h2.console.path=/h2
  
  # Datasource
  spring.datasource.url=jdbc:h2:mem:test
  spring.datasource.username=user
  spring.datasource.password=user
  spring.datasource.driver-class-name=org.h2.Driver
  </code></pre>