title: In Creating a Spring Boot application with a flyway H2 embedded database I am having trouble getting the SQL file to run
body: <p>I have my SQL file titled <code>V2__create_shipwrech.sql</code>. The above file is located in the migration folder of the following path <code>das-boot/src/main/resources/db/migration</code>.</p>
  
  <p>Here's the SQL content:</p>
  
  <pre><code>CREATE TABLE SHIPWRECK(
      ID INT AUTO_INCREMENT,
      NAME VARCHAR(255),
      DESCRIPTION VARCHAR(2000),
      CONDITION VARCHAR(255),
      DEPTH INT,
      LATITUDE DOUBLE,
      LONGITUDE DOUBLE,
      YEAR_DISCOVERED INT
  );
  </code></pre>
  
  <p>Here's my application.properties file contents:</p>
  
  <pre><code>logging.level.org.springframework.web=DEBUG
  server.port=8080
  spring.h2.console.enabled=true
  spring.h2.console.path=/h2
  spring.datasource.url=jdbc:h2:file:~/dasboot
  spring.datasource.username=sa
  spring.datasource.password=
  spring.datasource.driver-class-name=org.h2.Driver
  spring.datasource.max-active=10
  spring.datasource.max-idle=8
  spring.datasource.max-wait=10000
  spring.datasource.min-evictable-idle-time-millis=1000
  spring.datasource.min-idle=8
  spring.datasource.time-between-eviction-runs-millis=1
  flyway.baseline-on-migrate=true
  spring.jpa.hibernate.ddl-auto=false;
  </code></pre>
  
  <p>Here's my pom file contents:</p>
  
  <pre><code>&lt;project xmlns="http://maven.apache.org/POM/4.0.0"                
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      xsi:schemaLocation="http://maven.apache.org/POM/4.0.0         
      http://maven.apache.org/xsd/maven-4.0.0.xsd"&gt;
      &lt;modelVersion&gt;4.0.0&lt;/modelVersion&gt;
      &lt;groupId&gt;com.boot&lt;/groupId&gt;
      &lt;artifactId&gt;das-boot&lt;/artifactId&gt;
      &lt;version&gt;0.0.1-SNAPSHOT&lt;/version&gt;
      &lt;packaging&gt;jar&lt;/packaging&gt;
      &lt;parent&gt;
          &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
          &lt;artifactId&gt;spring-boot-starter-parent&lt;/artifactId&gt;
          &lt;version&gt;1.3.1.RELEASE&lt;/version&gt;
      &lt;/parent&gt;
      &lt;name&gt;das-boot&lt;/name&gt;
      &lt;url&gt;http://maven.apache.org&lt;/url&gt;
      &lt;properties&gt;
          &lt;project.build.sourceEncoding&gt;UTF-8&lt;/project.build.sourceEncoding&gt;
      &lt;/properties&gt;
      &lt;dependencies&gt;
          &lt;dependency&gt;
              &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
              &lt;artifactId&gt;spring-boot-starter-web&lt;/artifactId&gt;
          &lt;/dependency&gt;
          &lt;dependency&gt;
              &lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
              &lt;artifactId&gt;spring-boot-starter-data-jpa&lt;/artifactId&gt;
          &lt;/dependency&gt;
          &lt;dependency&gt;
              &lt;groupId&gt;com.h2database&lt;/groupId&gt;
              &lt;artifactId&gt;h2&lt;/artifactId&gt;
              &lt;version&gt;1.4.193&lt;/version&gt;
          &lt;/dependency&gt;
          &lt;dependency&gt;
              &lt;groupId&gt;org.flywaydb&lt;/groupId&gt;
              &lt;artifactId&gt;flyway-core&lt;/artifactId&gt;
          &lt;/dependency&gt;
          &lt;dependency&gt;
              &lt;groupId&gt;junit&lt;/groupId&gt;
              &lt;artifactId&gt;junit&lt;/artifactId&gt;
              &lt;version&gt;3.8.1&lt;/version&gt;
              &lt;scope&gt;test&lt;/scope&gt;
          &lt;/dependency&gt;
      &lt;/dependencies&gt;
  &lt;/project&gt;
  </code></pre>
  
  <p>This is my first time working with Spring Boot, Flyway, and the h2 embedded database, so please for give me if I sound like a newbie at this, I am.</p>
  
  <p>Here's my console output lines I think stand out to me:</p>
  
  <pre><code>-    Database: jdbc:h2:file:~/dasboot (H2 1.4)
  -    Validated 1 migration (execution time 00:00.039s)
  -    Current version of schema "PUBLIC": 2
  -    Schema "PUBLIC" is up to date. No migration necessary.
  -    Building JPA container EntityManagerFactory for persistence unit 'default'
  -    Processing PersistenceUnitInfo [
  -       name: default
  -       ...]
  -    Hibernate Core {4.3.11.Final}
  -    hibernate.properties not found
  -    HHH000021: Bytecode provider name : javassist
  -    Hibernate Commons Annotations {4.0.5.Final}
  -    Unrecognized value for "hibernate.hbm2ddl.auto": false;
  -    Looking for @ControllerAdvice: 
  </code></pre>
  
  <p>Then there were a ton of debug statements saying bean that were rejected after that, which I don't have enough room to paste.</p>
  
  <p>This was all using java version 1.8</p>
  
  <p>Any help would be greatly appreciated and what I learn from you will be used to teach others as I progress.
  Thanks in advance,
  Joe</p>