title: 'hibernate.dialect' must be set when no Connection available
body: <p>I am trying to run a hello world for: Spring/Hibernate with HSQLDB and C3PO connection pool.
  the same code works with mySQL (only with different dialect and driver)</p>
  
  <p>I have run the database and I can connect to it with the swing GUI. But when I try to run my application, I am getting a start up error.
  Here are the details:</p>
  
  <p>1: the error - </p>
  
  <blockquote>
    <p>INFO: Initializing Spring root WebApplicationContext
    [ERROR] [pool-2-thread-1 05:20:08] (JDBCExceptionReporter.java:logExceptions:101) Connections could not be acquired from the underlying database!
    [ERROR] [pool-2-thread-1 05:20:08] (ContextLoader.java:initWebApplicationContext:220) Context initialization failed
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in ServletContext resource [/WEB-INF/hibernate-context.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: 'hibernate.dialect' must be set when no Connection avalable
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1420)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
    ...
    ...</p>
  </blockquote>
  
  <p>2: hibernate-context.xml - </p>
  
  <pre><code>&lt;tx:annotation-driven transaction-manager="transactionManager" /&gt;
  
  &lt;bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean"&gt;
      &lt;property name="dataSource" ref="dataSource" /&gt;
      &lt;property name="packagesToScan" value="com.gleeb.sample.model" /&gt;
      &lt;property name="hibernateProperties"&gt;
          &lt;props&gt;
              &lt;!-- &lt;prop key="dialect"&gt;org.hibernate.dialect.MySQL5InnoDBDialect&lt;/prop&gt; --&gt;
              &lt;prop key="dialect"&gt;org.hibernate.dialect.HSQLDialect&lt;/prop&gt;
              &lt;prop key="show_sql"&gt;false&lt;/prop&gt;
              &lt;prop key="hbm2ddl.auto"&gt;create&lt;/prop&gt;
          &lt;/props&gt;
      &lt;/property&gt;
  &lt;/bean&gt;
  
          &lt;bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
      destroy-method="close" p:driverClass="org.hsqldb.jdbc.JDBCDriver"
      p:jdbcUrl="jdbc:hsqldb:hsql://localhost/testdb" p:user="sa"
      p:password="" p:acquireIncrement="5" p:idleConnectionTestPeriod="60"
      p:maxPoolSize="100" p:maxStatements="50" p:minPoolSize="10" /&gt;
  
  &lt;!-- Declare a transaction manager --&gt;
  &lt;bean id="transactionManager"
      class="org.springframework.orm.hibernate3.HibernateTransactionManager"
      p:sessionFactory-ref="sessionFactory" /&gt;
  </code></pre>