<?xml version="1.0"?>

<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD//EN"
        "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<!-- Copyright (c) 2004 Attensity Corporation, All Rights Reserved. -->

<hibernate-mapping>

  <!-- Category Table (class Category) -->
  <class name="com.attensity.powerdrill.dao.beans.Category"
         table="Categories">

    <meta attribute="class-description">
      A category bean.  A category can contain multiple terms.
      @author Don Mitchell
    </meta>

    <meta attribute="implement-equals">true</meta>

    <id name="id" column="CategoryID" type="long" unsaved-value="null">
      <meta attribute="use-in-tostring">true</meta>
      <meta attribute="use-in-equals">true</meta>
      <generator class="native"/>
    </id>

    <property name="name" type="string">
      <meta attribute="use-in-tostring">true</meta>
      <meta attribute="use-in-equals">true</meta>
      <column name="Name" unique-key="NameType" length="128" not-null="true"/>
    </property>

    <property name="type" type="character">
      <meta attribute="use-in-tostring">true</meta>
      <meta attribute="use-in-equals">true</meta>
      <column name="CategoryType" unique-key="NameType" not-null="true"/>
    </property>

    <property name="lastModDate" column="LastModDate"
              type="timestamp" not-null="true"/>

    <!-- Reference back to self for parent category. -->
    <many-to-one name="parent" column="ParentID"
        class="com.attensity.powerdrill.dao.beans.Category"/>

    <!-- CategoryTerms Table -->
    <set name="terms" table="CategoryTerms"
         cascade="all" lazy="false" inverse="false">
      <meta attribute="field-description">Terms within this category</meta>
      <key column="CategoryID" foreign-key="TermID"/>
      <many-to-many
        class="com.attensity.powerdrill.dao.beans.CategoryTerm">
        <column name="TermID" unique-key="CategoryTerm"/>
      </many-to-many>
    </set>

  </class>

  <!-- Terms Table (class CategoryTerm) -->
  <class name="com.attensity.powerdrill.dao.beans.CategoryTerm"
         table="Terms">

    <meta attribute="class-description">
      A category term bean.  A term may belong to multiple categories.
      @author Don Mitchell
    </meta>

    <meta attribute="implement-equals">true</meta>

    <id name="id" column="TermID" type="long" unsaved-value="null">
      <meta attribute="use-in-tostring">true</meta>
      <meta attribute="use-in-equals">true</meta>
      <generator class="native"/>
    </id>

    <property name="term" type="string">
      <meta attribute="use-in-tostring">true</meta>
      <meta attribute="use-in-equals">true</meta>
      <column name="Term" unique-key="Term" length="255" not-null="true"/>
    </property>

    <property name="lastModDate" column="LastModDate" type="timestamp"
              not-null="true">
      <meta attribute="use-in-tostring">true</meta>
    </property>

    <set name="categories" lazy="false" table="CategoryTerms" inverse="true">
      <key column="TermID" foreign-key="CategoryID"/>
      <many-to-many
        class="com.attensity.powerdrill.dao.beans.Category">
        <column name="CategoryID" unique-key="CategoryTerm"/>
      </many-to-many>
    </set>

  </class>

</hibernate-mapping>

Caused by: net.sf.hibernate.HibernateException: Batch update row count wrong: 0
        at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.
java:65)
        at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:122)
        at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:5
9)
        at net.sf.hibernate.impl.BatcherImpl.prepareStatement(BatcherImpl.java:5
6)
        at net.sf.hibernate.impl.BatcherImpl.prepareBatchStatement(BatcherImpl.j
ava:109)
        at net.sf.hibernate.persister.EntityPersister.delete(EntityPersister.jav
a:582)
        at net.sf.hibernate.impl.ScheduledDeletion.execute(ScheduledDeletion.jav
a:29)
        at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2414)
        at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2372)
        at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2236)
        at com.attensity.apps.hibernate.ejb.HibernateDAO.removeObj(HibernateDAO.
java:70)
        ... 14 more

create table Categories (
   CategoryID BIGINT NOT NULL AUTO_INCREMENT,
   Name VARCHAR(128) not null,
   CategoryType CHAR(1) not null,
   LastModDate DATETIME not null,
   ParentID BIGINT,
   primary key (CategoryID),
    unique (Name, CategoryType)
);
create table CategoryTerms (
   CategoryID BIGINT not null,
   TermID BIGINT not null,
   primary key (TermID, CategoryID),
    unique (TermID, CategoryID)
);
create table Terms (
   TermID BIGINT NOT NULL AUTO_INCREMENT,
   Term VARCHAR(255) not null,
   LastModDate DATETIME not null,
   primary key (TermID),
    unique (Term)
);
alter table Categories add index FKC419223C49E5F365 (ParentID), add constraint FKC419223C49E5F365 foreign key (ParentID) references Categories (CategoryID);
alter table CategoryTerms add index FK43303B09951BCEA7 (TermID), add constraint FK43303B09951BCEA7 foreign key (TermID) references Terms (TermID);
alter table CategoryTerms add index FK43303B09C4195AB9 (CategoryID), add constraint FK43303B09C4195AB9 foreign key (CategoryID) references Categories (CategoryID);