<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>

    <class name="OrderDetail" table="Order Details">
        <id name="id" column="OrderID" type="integer" />
        <property name="productid" column="ProductID" type="integer"/>
        <property name="unitprice" column="UnitPrice" type="big_decimal" />
   <property name="qty" column="Quantity" type="short" />
    </class>
</hibernate-mapping>

dataSource {
   pooled = false
   driverClassName = "com.ddtek.jdbc.sqlserver.SQLServerDriver"
   username = "sa"
   password = "*"
}
hibernate {
    cache.use_second_level_cache=true
    cache.use_query_cache=true
    cache.provider_class='org.hibernate.cache.EhCacheProvider'
}
// environment specific settings
environments {
   development {
      dataSource {
         //dbCreate = "create-drop" // one of 'create', 'create-drop','update'
         url = "jdbc:datadirect:sqlserver://localhost:1433;databasename=northwind"
      }
   }
   test {
      dataSource {
         dbCreate = "update"
         url = "jdbc:hsqldb:mem:testDb"
      }
   }
   production {
      dataSource {
         dbCreate = "update"
         url = "jdbc:hsqldb:file:prodDb;shutdown=true"
      }
   }
}