title: In-memory database is not created but logs shows that DDL was executed
body: <p>I am trying to setup spring environment to run with in memory database which is automatically created based on provided mappings. During execution I can see in logs that DDL statements are executed, but when hibernate tries to insert data into created tables, I am getting 'Table not found' exception.<br/></p>
  
  <p><strong>What can be a problem?</strong><br/></p>
  
  <p>Using spring 3.1.1 and Hibernate 4.1.1 and H2 version 1.3.165.</p>
  
  <p>Logs looks like (only revelant records left):</p>
  
  <pre><code>INFO at '25-04-2012 13:23:56.318' by thread 'main' from category 'org.hibernate.tool.hbm2ddl.SchemaExport':
  HHH000227: Running hbm2ddl schema export
  DEBUG at '25-04-2012 13:23:56.318' by thread 'main' from category 'org.hibernate.SQL':
  
      drop table DUMMIES if exists
  Hibernate: 
      drop table DUMMIES if exists
  DEBUG at '25-04-2012 13:23:56.318' by thread 'main' from category 'org.hibernate.SQL':
  
      create table DUMMIES (
          id bigint generated by default as identity,
          title varchar(255),
          primary key (id),
          unique (title)
      )
  Hibernate: 
      create table DUMMIES (
          id bigint generated by default as identity,
          title varchar(255),
          primary key (id),
          unique (title)
      )
  INFO at '25-04-2012 13:23:56.334' by thread 'main' from category 'org.hibernate.tool.hbm2ddl.SchemaExport':
  HHH000230: Schema export complete
  INFO at '25-04-2012 13:23:56.334' by thread 'main' from category 'org.springframework.context.support.ClassPathXmlApplicationContext':
  Bean 'mySessionFactory' of type [class org.springframework.orm.hibernate4.LocalSessionFactoryBean] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
  INFO at '25-04-2012 13:23:56.631' by thread 'main' from category 'org.springframework.orm.hibernate4.HibernateTransactionManager':
  Using DataSource [org.springframework.jdbc.datasource.SimpleDriverDataSource@a86d12] of Hibernate SessionFactory for HibernateTransactionManager
  WARN at '25-04-2012 13:23:56.865' by thread 'main' from category 'org.hibernate.engine.jdbc.spi.SqlExceptionHelper':
  SQL Error: 42102, SQLState: 42S02
  ERROR at '25-04-2012 13:23:56.865' by thread 'main' from category 'org.hibernate.engine.jdbc.spi.SqlExceptionHelper':
  Table "DUMMIES" not found; SQL statement:
  insert into DUMMIES (id, title) values (null, ?) [42102-165]
  </code></pre>
  
  <p>Beans.xml looks like ('mypackage' is a replacement for full package name):</p>
  
  <pre><code>&lt;bean id="myDataSource"
      class="org.springframework.jdbc.datasource.SimpleDriverDataSource"&gt;
      &lt;property name="driverClass" value="org.h2.Driver" /&gt;
      &lt;property name="url" value="jdbc:h2:mem:" /&gt;
      ...
  &lt;/bean&gt;
  
  &lt;bean id="mySessionFactory"
      class="org.springframework.orm.hibernate4.LocalSessionFactoryBean"&gt;
      &lt;property name="dataSource" ref="myDataSource" /&gt;
      &lt;property name="packagesToScan"&gt;
          &lt;array&gt;
              &lt;value&gt;mypackage.entities&lt;/value&gt;
          &lt;/array&gt;
      &lt;/property&gt;
  &lt;/bean&gt;
  
  &lt;bean id="myTransactionManager"
      class="org.springframework.orm.hibernate4.HibernateTransactionManager"&gt;
      &lt;property name="sessionFactory" ref="mySessionFactory" /&gt;
  &lt;/bean&gt;
  
  &lt;aop:config&gt;
      &lt;aop:pointcut id="daoMethods" expression="execution(* mypackage.*Dao.*(..))" /&gt;
      &lt;aop:advisor advice-ref="requiredTxAdvice" pointcut-ref="daoMethods" /&gt;
  &lt;/aop:config&gt;
  
  &lt;tx:advice id="requiredTxAdvice" transaction-manager="myTransactionManager"&gt;
      &lt;tx:attributes&gt;
          &lt;tx:method name="*" propagation="REQUIRED" /&gt;
      &lt;/tx:attributes&gt;
  &lt;/tx:advice&gt;
  
  class="org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor" /&gt;
  &lt;bean id="dummyDao" class="mypackage.DummyDaoImpl"&gt;
      &lt;property name="sessionFactory" ref="mySessionFactory" /&gt;
  &lt;/bean&gt;
  </code></pre>
  
  <p>hibernate.properties looks like:</p>
  
  <pre><code>hibernate.dialect=org.hibernate.dialect.H2Dialect
  hibernate.show_sql=true
  hibernate.format_sql=true
  hibernate.id.new_generator_mappings=true
  hibernate.hbm2ddl.auto=create-drop
  </code></pre>
  
  <p>(create does not worked too)</p>