<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
  <session-factory>
<!-- for client-server app, Hibernate can use direct JDBC connection -->
  <property name="hibernate.connection.driver_class">org.hsqldb.jdbcDriver</property>
  <property name="hibernate.connection.url">jdbc:hsqldb:hsql://localhost</property>
  <property name="hibernate.connection.username">sa</property>
  <property name="hibernate.dialect">org.hibernate.dialect.HSQLDialect</property> 
<!-- for web app, use DataSource obtained by JNDI lookup -->
<!-- no-JTA case: DataSource config is given JDBC connection properties -->
<!--
  <property name="hibernate.connection.datasource">java:comp/env/jdbc/hsql</property>
  <property name="hibernate.dialect">org.hibernate.dialect.HSQLDialect</property>  
-->
<!-- Oracle 9 or later for webapp. Also note OracleDialect means Oracle8 -->
<!-- 
  <property name="hibernate.connection.datasource">java:comp/env/jdbc/xxxx</property>
  <property name="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</property>  
-->
   <!-- no JTA in use, so enable thread-local session binding -->
   <property name="hibernate.current_session_context_class">thread</property>
   <property name="hibernate.transaction_factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>

   <!-- SQL to console logging -->
   <property name="show_sql">true</property>
   <property name="format_sql">true</property>
   <property name="use_sql_comments">true</property>

   <!--Hibernate mapping files -->
   <mapping resource="pizza/domain/PizzaOrder.hbm.xml" />
   <mapping resource="pizza/domain/SysTime.hbm.xml" />
   <mapping resource="pizza/domain/PizzaSize.hbm.xml" />
   <mapping resource="pizza/domain/Topping.hbm.xml" />
  </session-factory>
</hibernate-configuration>
