title: Unable to see generated tables generated by hibernate schema export (H2 database)
body: <p>I am trying to get a small app going using Spring Boot (v1.1.1.RELEASE), and H2 database. In the logging i see that the ddl is correctly generated but it i just cannot find the tables inside the H2 database.</p>
  
  <p>I manually copied the ddl into a db visualizer and the sql is ok. I have no clue what i am missing here. When executing code the JPA persistence layer seems to store the data correctly as i get generated ID's back etc.. I was thinking that i made a mistake in the jdbc url, but they all point to the same file based H2 database. But this database just seems to hold no data.</p>
  
  <p>The JPA object
  </p>
  
  <pre><code>@Entity
  @Table(name = "rawdata", schema = "PUBLIC")
  public class RawData {
  
      @Id
      @GeneratedValue
      private Long id;
  
      @Lob
      @Column(name = "payload", nullable = false)
      private String payload;
  
      // getters and setters omitted
  }
  </code></pre>
  
  <p>The JPARepository</p>
  
  <pre><code>@Repository
  public interface RawDataRepository extends JpaRepository&lt;RawData, Long&gt; {
  
  }
  </code></pre>
  
  <p>Application properties</p>
  
  <pre><code>spring.datasource.url=jdbc:h2:file:/home/username/dev-db
  spring.datasource.driverClassName=org.h2.Driver
  spring.jpa.hibernate.ddl-auto=create-drop
  spring.jpa.show-sql=true
  </code></pre>
  
  <p>Logging info</p>
  
  <pre><code>org.hibernate.tool.hbm2ddl.SchemaExport  : HHH000227: Running hbm2ddl schema export
  Hibernate: drop table PUBLIC.rawdata if exists
  Hibernate: create table PUBLIC.rawdata (id bigint generated by default as identity, payload clob not null, primary key (id))
  org.hibernate.tool.hbm2ddl.SchemaExport  : HHH000230: Schema export complete
  </code></pre>
  
  <p>Test code</p>
  
  <pre><code>@Autowired
  private RawDataRepository repository;
  
  repository.saveAndFlush(new RawData("test"));
  System.out.println(repository.count());
  </code></pre>
  
  <p>So saving a JPA object actually seems to persist the object (the count increases etc) but the data and table structure do not appear in the database. I see that the modified date changes of the database when persisting an object but i seem unable to view the data with for example squirrel/dbvisualizer etc.. Any hints or tips?</p>