... ... ... ... ...
    <!-- sql server driver -->
    <dependency>
      <groupId>net.sourceforge.jtds</groupId>
      <artifactId>jtds</artifactId>
      <version>1.2.4</version>
    </dependency>
    ... ... ... ... ...

<hibernate-configuration>

    <session-factory>

        <!-- Database connection settings -->
        <property name="connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property>
        <property name="connection.url">jdbc:jtds:sqlserver://localhost:1433/TEST</property>
        <property name="connection.username">USERNAME</property>
        <property name="connection.password">PASSWORD</property>

        <!-- JDBC connection pool (use the built-in) 
        <property name="connection.pool_size">1</property>
        -->
        
        <!-- SQL dialect -->
        <property name="dialect">org.hibernate.dialect.HSQLDialect</property>

        <!-- Enable Hibernate‘s automatic session context management 
        <property name="current_session_context_class">thread</property>
        -->
        
        <!-- Disable the second-level cache  
        <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
        -->

        <!-- Echo all executed SQL to stdout -->
        <property name="show_sql">true</property>
        
        <!--  
        <property name="format_sql">true</property>
        -->
        
        <!-- Drop and re-create the database schema on startup 
        <property name="hbm2ddl.auto">update</property>
        -->

        <!--  
        <mapping resource="com/fancy/po/person.hbm.xml"/>
        -->
        
    </session-factory>

</hibernate-configuration>