Hibernate Issue

[Mike Boota]

Hi,

I have an application that's been running for over a year now. I am using jaxb/hibernate. Recently I am running into an issue where Hibernate is not saving the data to the tables. The data does exists as I do see it in the logs but somehow hibernate is not able to save it. Most of the time it saves but once in a while it does not save and I don't get any errors or exceptions. Anyone experienced this before and knows what might be wrong. How to debug this as I don't get any errors or exceptions. There's nothing changed in the application.

Thanks

[Hussein Baghdadi]

I don't think Hibernate is guilty.
Does your database support huge counts of records (or even a heavy load) ?

[Mark Spritzler]

"There's nothing changed in the application."

What about the database, its location, IP address, anything. Something must have changed.

Maybe the network is having issues.

Mark

[Mike Boota]

Hi,

Yes we have an Oracle database and it does support huge counts of records plus there is no issue with the load either. It's been working fine at peak times. I tested this off peak hours too and I sometimes get those errors. So really don't where exactly is this error happening and hiberante succeeds but no data loaded and no errors either.

Thanks

[Mr. C Lamont Gilbert]

Is hibernate issuing SQL to the database to store the objects? You have logging on?

[Mike Boota]

Hi,

This is the snippet of the code where a save is done:

Session session = HibernateUtil.getSession();
      logger.fine("Hibernate Session Created! Begining transaction...");
      Transaction tx = session.beginTransaction();
      logger.fine("Save data!");
      session.save(payLoadData);
      tx.commit();
      logger.fine("Data saved!");
      HibernateUtil.closeSession();

I am using jaxb and data is loaded in java objects from xml. payLoadData is the root class. Before saving I did checked if the root class does contain data and the data does exists. But some how hibernated never saves it to the database. I tried the same file several times and most of the times it works but sometimes it just does not insert any data. That's why I am little confused on what exactly is wrong. Thanks for any help.

[Mr. C Lamont Gilbert]

do you have sql debugging enabled on hibernate so you can see the sql commands hibernate is issuing to the database?

[Mike Boota]

Hi,

I enabled the sql debugging too but don't see anything unusual it's that hibernate commits everything fine but never see the data in the database. I again tested it multiple times with the same data and once a while it just does not save the data. Any ideas what else I can look at. Am using Oracle DB for back-end storage.

Thanks

[Mr. C Lamont Gilbert]

Originally posted by Mike Boota:
Hi,

I enabled the sql debugging too but don't see anything unusual it's that hibernate commits everything fine but never see the data in the database. I again tested it multiple times with the same data and once a while it just does not save the data. Any ideas what else I can look at. Am using Oracle DB for back-end storage.

Thanks

I can not tell from your vague statement if hibernate is in fact issuing SQL commands to your database to store your data, or not!?

I assume you see the log entries for the save call, but I need to know if Hibernate has decided that the data needs to be saved and does so, or if Hibernate has decided this object is not changed and does not require an update. Or maybe you have no persistence by reachability or something else is happening.

[Mark Spritzler]

Are you calls going through EJBs or something else that would create a Transaction, outside the Hibernate scope, that Hibernate is joining that transaction, and that after saving, something goes wrong in that outside transaction, and that transaction is rolled back, causing Hibernate to also rollback?

Mark

[Mike Boota]

Hi,

Here is what' happening. It's a Web Service where I am using hibernate to save the data. A client of the Web Service may send same data over. Now how do I make sure hibernate does save it even if the data is coming over again.

The first step is it validates the data, then it stores the payload in different tables and that's where it's not working (some times it works sometimes it basically does not save and no errors either at save time), then finally it stores the whole payload i.e. xml in one table as a clob and this always works fine, and finally Web Service returns the response to the client.

I never do an update it's always an insert. There is not transaction or ejb's involved it's a straight Web Service. I'll try to debug more but right now am kind of stuck and don't know what else I can look at.

Thanks for the help.

[Mike Boota]

Hi,

I am using

cascade = "save-update"

Don't know if changing it to

cascade = "none"

what will be the effect. Also what if I use merge instead of save when trying to persist the object.

Is there any difference between using cascade=none|save-update and using merge instead of save. Just trying to see what other options I have as I right now I am stuck and really can't figure out what's going on.

Here is the current code snippet where I am saving the object to the databse:

logger.fine("Creating Hibernate Session...");
      Session session = HibernateUtil.getSession();
      logger.fine("Done creating Hibernate Session! Begining transaction...");
      Transaction tx = session.beginTransaction();
      logger.fine("********** Saving data!");
      session.save(data);
      logger.fine("********** Saved data!");
      session.flush();
      logger.fine("********** Data Flushed!");
      tx.commit();
      logger.fine("********** Commited data!");
      HibernateUtil.closeSession();
      logger.fine("Closed session!");

It randomnly does not save the data, I even tried the same file over and over. Any help is appreciated.

Thanks.
[ March 06, 2007: Message edited by: Mike Boota ]

[Mark Spritzler]

Cascade options and merge aren't the same thing.

Cascade options are in regard to what Hibernate should do with related objects. So if I have a relationship between a and b, a has an instance of b. In the mapping for a, there is a relation mapping to b, in that mapping the Cascade option of none would mean when I do save(a) nothing is done with the b it holds. Even if b is changed, new or anything.

Merge is for detached objects and reattaching them to be managed by the Session.

So at this point, can you post your hibernate.cfg.xml (hide your username/password), you mapping hbm.xml files (Or classes with Annotations) and your HibernateUtil class code.

Thanks

Mark

[Mike Boota]

Following are the hbm, hibernate.cfg.xml , and Util Class code. Notification is the root class.

package com.hibernate;
 
import com.EmailSender;
import com.SystemException;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
 

 
public class HibernateUtil {
 
private static Logger log = Logger.getLogger(HibernateUtil.class.getName());
 
private static Configuration configuration;
private static SessionFactory sessionFactory;
private static final ThreadLocal threadSession = new ThreadLocal();
 
// Create the initial SessionFactory from the default configuration files
static {
try {
configuration = new Configuration();
      configuration.configure().buildSessionFactory();
//sessionFactory = configuration.configure().buildSessionFactory();
} catch (Throwable ex) {
// We have to catch Throwable, otherwise we will miss
// NoClassDefFoundError and other subclasses of Error
log.log(Level.SEVERE,"Building SessionFactory failed.", ex);
throw new ExceptionInInitializerError(ex);
}
}
 
/**
 * Returns the SessionFactory used for this static class.
 *
 * @return SessionFactory
 */
public static SessionFactory getSessionFactory() throws SystemException {
/* Instead of a static variable, use JNDI:*/
SessionFactory sessions = null;
try {
Context ctx = new InitialContext();
String jndiName = "hibernate/IntakeSessionFactory";
sessions = (SessionFactory)ctx.lookup(jndiName);
} catch (NamingException ex) {
throw new SystemException(ex.getMessage(),ex);
}
return sessions;

//return sessionFactory;
}
 
/**
 * Returns the original Hibernate configuration.
 *
 * @return Configuration
 */
public static Configuration getConfiguration() {
return configuration;
}
 

 

/**
 * Retrieves the current Session local to the thread.
 * <p/>
 * If no Session is open, opens a new Session for the running thread.
 *
 * @return Session
 */
public static Session getSession()
throws Exception {
Session s = (Session) threadSession.get();
try {
if (s == null) {
log.fine("Opening new Session for this thread.");
s = getSessionFactory().openSession();
threadSession.set(s);
}
} catch (HibernateException ex) {
throw new Exception(ex);
}
return s;
}
 
/**
 * Closes the Session local to the thread.
 */
public static void closeSession()
throws Exception {
try {
Session s = (Session) threadSession.get();
threadSession.set(null);
if (s != null && s.isOpen()) {
log.fine("Closing Session of this thread.");
s.close();
}
} catch (HibernateException ex) {
throw new Exception(ex);
}//end try
}
 

}
 
*******************************************
 
CODE that saves the data:
 
logger.fine("********** Patient DOB BEFORE SAVE " + (notification.getPatient().getDob() == null ? null : notification.getPatient().getDob().toString()));
      logger.fine("********** Patient First Name " + (notification.getPatient().getFirstName() == null ? "NULL NAME" : notification.getPatient().getFirstName().toString()));
      logger.fine("********** Notification CLIENT ID " + (notification.getClientId() == null ? "NULL CLIENT ID" : notification.getClientId().toString()));
      logger.fine("********** Notification ID BEFORE SAVE " + notification.getId());
      logger.fine("Creating Hibernate Session...");
      Session session = HibernateUtil.getSession();
      logger.fine("Done creating Hibernate Session! Begining transaction...");
      Transaction tx = session.beginTransaction();
      logger.fine("********** Saving data!");
      session.save(notification);
      logger.fine("********** Saved Notification!");
      session.flush();
      logger.fine("********** Notification Flushed!");
      tx.commit();
      logger.fine("********** Commited Notification data!");
      HibernateUtil.closeSession();
      logger.fine("Closed session!");
      logger.fine("********** Patient DOB AFTER SAVE " + (notification.getPatient().getDob() == null ? null : notification.getPatient().getDob().toString()));
      logger.fine("********** Notification ID AFTER SAVE " + notification.getId());
 

 
******************************************
 
<?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 name="hibernate/IntakeSessionFactory">
    <!--session-factory-->
        <property name="hibernate.cglib.use_reflection_optimizer">true</property>
<property name="hibernate.connection.driver_class">oracle.jdbc.OracleDriver</property>
        <property name="hibernate.connection.password">stage</property>
        <property name="hibernate.connection.url">jdbc :-o	 racle:thin:@someserver:1521 :mrgreen: evelop</property>
        <property name="hibernate.connection.username">stage</property>
        <!--property name="hibernate.connection.datasource">jdbc/IntakeStagingDS</property-->
        <property name="hibernate.jdbc.batch_size">0</property>
        <property name="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</property>
        <property name="hibernate.show_sql">true</property>
        <mapping resource="com/Prescription.hbm.xml" />
        <mapping resource="com/Physician.hbm.xml" />
        <mapping resource="com/Insurance.hbm.xml" />
        <mapping resource="com/Dea.hbm.xml" />
        <mapping resource="com/Email.hbm.xml" />
        <mapping resource="com/Patient.hbm.xml" />
        <mapping resource="com/Benefits.hbm.xml" />
        <mapping resource="com/PatientAssistance.hbm.xml" />
        <mapping resource="com/PatientRelations.hbm.xml" />
        <mapping resource="com/Attributes.hbm.xml" />
        <mapping resource="com/PriorAuthorization.hbm.xml" />
        <mapping resource="com/DrugAllergies.hbm.xml" />
        <mapping resource="com/Attachments.hbm.xml" />
        <mapping resource="com/Phone.hbm.xml" />
        <mapping resource="com/Address.hbm.xml" />
        <mapping resource="com/NonDrugAllergies.hbm.xml" />
        <mapping resource="com/Notification.hbm.xml" />
        <mapping resource="com/Diagnosis.hbm.xml" />
        <mapping resource="com/Measurment.hbm.xml" />
        <mapping resource="com/MessageArchive.hbm.xml" />
        <mapping resource="com/Msr.hbm.xml" />
        <mapping resource="com/MsrItems.hbm.xml" />        
    </session-factory>
</hibernate-configuration>
 
***************************************
 
<?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>
<!-- 
        Auto-generated mapping file from
        the hibernate.org cfg2hbm engine
-->
    <class name="com.Notification" table="NOTIFICATION" schema="STAGE">
        <id name="id"  type="long">
            <column name="ID" />
            <generator class="sequence">
            <param name="sequence">NOTIFICATION_SEQ</param>
        </generator>
        </id>
        <many-to-one name="patient" class="com.Patient"  cascade="save-update">
            <column name="PATIENT_ID"/>
        </many-to-one>
        <property name="clientId" type="string">
            <column name="CLIENT_ID" length="50" />
        </property>
        <property name="transmissionReason" type="string">
            <column name="TRANSMISSION_REASON" />
        </property>
        <property name="patientStatus" type="string">
            <column name="PATIENT_STATUS" />
        </property>
        <property name="status" type="string">
            <column name="STATUS" />
        </property>
        <property name="fileType" type="string">
            <column name="FILE_TYPE" />
        </property>
        <property name="correlationId" type="string">
            <column name="CORRELATION_ID" />
        </property>
        <property name="createdDate" type="timestamp">
            <column name="CREATED_DATE" />
        </property>
        <property name="createdBy" type="string">
            <column name="CREATED_BY" length="32" />
        </property>
        <property name="modifiedDate" type="timestamp">
            <column name="MODIFIED_DATE" />
        </property>
        <property name="modifiedBy" type="string">
            <column name="MODIFIED_BY" length="32" />
        </property>
        <set name="attributeses" inverse="true" cascade="save-update">
            <key>
                <column name="NOTIFICATION_ID"/>
            </key>
            <one-to-many class="com.Attributes" />
        </set>
        <set name="msres" inverse="true" cascade="save-update">
            <key>
                <column name="NOTIFICATION_ID"/>
            </key>
            <one-to-many class="com.Msr" />
        </set>
        <set name="attachmentses" inverse="true" cascade="save-update">
            <key>
                <column name="NOTIFICATION_ID"/>
            </key>
            <one-to-many class="com.Attachments" />
        </set>
    </class>
</hibernate-mapping>
 
***********************************
 
<?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>
<!-- 
        Auto-generated mapping file from
        the hibernate.org cfg2hbm engine
-->
    <class name="com.Patient" table="PATIENT" schema="STAGE">
        <id name="id"  type="long">
            <column name="ID" />
            <generator class="sequence">
            <param name="sequence">PATIENT_SEQ</param>
        </generator>
        </id>
        <property name="activeIndicator" type="string">
            <column name="ACTIVE_INDICATOR" length="32" />
        </property>
        <property name="patientId" type="string">
            <column name="PATIENT_ID" />
        </property>
        <property name="firstName" type="string">
            <column name="FIRST_NAME" />
        </property>
        <property name="lastName" type="string">
            <column name="LAST_NAME" />
        </property>
        <property name="middleName" type="string">
            <column name="MIDDLE_NAME" />
        </property>
        <property name="ssn" type="string">
            <column name="SSN" />
        </property>
        <property name="dob" type="date">
            <column name="DOB" length="7" />
        </property>
        <property name="gender" type="string">
            <column name="GENDER" />
        </property>
        <property name="comments" type="string">
            <column name="COMMENTS" length="2000" />
        </property>
        <set name="physicians" inverse="true" cascade="save-update">
            <key>
                <column name="PATIENT_ID"/>
            </key>
            <one-to-many class="com.Physician"/>
        </set>
        <set name="nonDrugAllergieses" inverse="true" cascade="save-update">
            <key>
                <column name="PATIENT_ID"/>
            </key>
            <one-to-many class="com.NonDrugAllergies" />
        </set>
        <set name="insurances" inverse="true"  cascade="save-update">
            <key>
                <column name="PATIENT_ID"/>
            </key>
            <one-to-many class="com.Insurance" />
        </set>
        <set name="measurments" inverse="true" cascade="save-update">
            <key>
                <column name="PATIENT_ID"/>
            </key>
            <one-to-many class="com.Measurment" />
        </set>
        <set name="diagnosises" inverse="true" cascade="save-update">
            <key>
                <column name="PATIENT_ID"/>
            </key>
            <one-to-many class="com.Diagnosis" />
        </set>
        <set name="drugAllergieses" inverse="true" cascade="save-update">
            <key>
                <column name="PATIENT_ID"/>
            </key>
            <one-to-many class="com.DrugAllergies" />
        </set>
        <set name="referals" inverse="true" cascade="save-update">
            <key>
                <column name="PATIENT_ID"/>
            </key>
            <one-to-many class="com.Referal" />
        </set>
        <set name="prescriptions" inverse="true" cascade="save-update">
            <key>
                <column name="PATIENT_ID"/>
            </key>
            <one-to-many class="com.Prescription" />
        </set>
        <set name="patientRelationses" inverse="true" cascade="save-update">
            <key>
                <column name="PATIENT_ID" />
            </key>
            <one-to-many class="com.PatientRelations" />
        </set>
        <set name="patientAssistances" inverse="true" cascade="save-update">
            <key>
                <column name="PATIENT_ID"/>
            </key>
            <one-to-many class="com.PatientAssistance" />
        </set>
        <set name="notifications" inverse="true">
            <key>
                <column name="PATIENT_ID"/>
            </key>
            <one-to-many class="com.Notification" />
        </set>
        <set name="addresses" table="PATIENT_ADDRESS_MAP" cascade="save-update">
            <key>
                <column name="PATIENT_ID" not-null="true" />
            </key>
            <many-to-many class="com.Address" column="ADDRESS_ID" />
        </set>
        <set name="emails" table="PATIENT_EMAIL_MAP" cascade="save-update">
            <key>
                <column name="PATIENT_ID" not-null="true" />
            </key>
            <many-to-many class="com.Email" column="EMAIL_ID" />
        </set>
    </class>
</hibernate-mapping>
 
****************************
 
<?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>
<!-- 
        Auto-generated mapping file from
        the hibernate.org cfg2hbm engine
-->
    <class name="com.NonDrugAllergies" table="NON_DRUG_ALLERGIES" schema="STAGE">
        <id name="id"  type="long">
            <column name="ID" />
            <generator class="sequence">
            <param name="sequence">NON_DRUG_ALLERGIES_SEQ</param>
        </generator>
        </id>
        <many-to-one name="patient" class="com.Patient">
            <column name="PATIENT_ID"  not-null="true"/>
        </many-to-one>
        <property name="description" type="string">
            <column name="DESCRIPTION" length="2000" />
        </property>
        <property name="comments" type="string">
            <column name="COMMENTS" length="2000" />
        </property>
    </class>
</hibernate-mapping>
 
****************************
 
<?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>
<!-- 
        Auto-generated mapping file from
        the hibernate.org cfg2hbm engine
-->
    <class name="com.MsrItems" table="MSR_ITEMS" schema="STAGE">
        <id name="id"  type="long">
            <column name="ID" />
            <generator class="sequence">
            <param name="sequence">MSR_ITEM_SEQ</param>
        </generator>
        </id>
        <many-to-one name="msr" class="com.Msr">
            <column name="MSR_ID" not-null="true"/>
        </many-to-one>
        <property name="itemDescription" type="string">
            <column name="ITEM_DESCRIPTION" />
        </property>
        <property name="itemQuantity" type="string">
            <column name="ITEM_QUANTITY" />
        </property>
    </class>
</hibernate-mapping>
 
******************************
 
<?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>
<!-- 
        Auto-generated mapping file from
        the hibernate.org cfg2hbm engine
-->
    <class name="com.Msr" table="MSR" schema="STAGE">
        <id name="id"  type="long">
            <column name="ID" />
            <generator class="sequence">
            <param name="sequence">MSR_SEQ</param>
        </generator>
        </id>
        <many-to-one name="notification" class="com.Notification">
            <column name="NOTIFICATION_ID"  not-null="true"/>
        </many-to-one>
        <property name="name" type="string">
            <column name="NAME" />
        </property>
        <property name="msrdate" type="date">
            <column name="MSRDATE" length="7" />
        </property>
        <property name="reason" type="string">
            <column name="REASON" />
        </property>
        <property name="srnumber" type="string">
            <column name="SRNUMBER" />
        </property>
        <set name="msrItems" inverse="true" cascade="save-update">
            <key>
                <column name="MSR_ID" />
            </key>
            <one-to-many class="com.MsrItems" />
        </set>
    </class>
</hibernate-mapping>
 
********************************
 
<?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>
<!-- 
        Auto-generated mapping file from
        the hibernate.org cfg2hbm engine
-->
    <class name="com.MessageArchive" table="MESSAGE_ARCHIVE" schema="STAGE">
        <id name="id"  type="long">
            <column name="ID" />
            <generator class="sequence">
            <param name="sequence">MESSAGE_ARCHIVE_SEQ</param>
        </generator>
        </id>
        <property name="clientId" type="string">
            <column name="CLIENT_ID" />
        </property>
        <property name="correlationId" type="string">
            <column name="CORRELATION_ID" />
        </property>
        <property name="messageBlob" type="blob">
            <column name="MESSAGE" />
        </property>
        <property name="status" type="string">
            <column name="STATUS" />
        </property>                
        <property name="createdDate" type="timestamp">
            <column name="CREATED_DATE"  />
        </property>
        <property name="createdBy" type="string">
            <column name="CREATED_BY" length="32" />
        </property>
        
    </class>
</hibernate-mapping>
 
********************************
 
<?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>
<!-- 
        Auto-generated mapping file from
        the hibernate.org cfg2hbm engine
-->
    <class name="com.Measurment" table="MEASURMENT" schema="STAGE">
        <id name="id"  type="long">
            <column name="ID" />
            <generator class="sequence">
            <param name="sequence">MEASURMENT_SEQ</param>
        </generator>
        </id>
        <many-to-one name="patient" class="com.Patient">
            <column name="PATIENT_ID"  not-null="true"/>
        </many-to-one>
        <property name="datemeasured" type="date">
            <column name="DATEMEASURED" length="7" />
        </property>
        <property name="weightunit" type="string">
            <column name="WEIGHTUNIT" />
        </property>
        <property name="weightvalue" type="big_decimal">
            <column name="WEIGHTVALUE" precision="22" scale="0" />
        </property>
        <property name="heightunit" type="string">
            <column name="HEIGHTUNIT" />
        </property>
        <property name="heightvalue" type="big_decimal">
            <column name="HEIGHTVALUE" precision="22" scale="0" />
        </property>
        <property name="surfacearea" type="big_decimal">
            <column name="SURFACEAREA" precision="22" scale="0" />
        </property>
        <property name="bodymassindex" type="big_decimal">
            <column name="BODYMASSINDEX" precision="22" scale="0" />
        </property>
    </class>
</hibernate-mapping>
 
***********************************
 
<?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>
<!-- 
        Auto-generated mapping file from
        the hibernate.org cfg2hbm engine
-->
    <class name="com.Insurance" table="INSURANCE" schema="STAGE">
        <id name="id"  type="long">
            <column name="ID" />
            <generator class="sequence">
            <param name="sequence">INSURANCE_SEQ</param>
        </generator>
        </id>
        <many-to-one name="patient" class="com.Patient">
            <column name="PATIENT_ID"  not-null="true"/>
        </many-to-one>
        <property name="billingSequence" type="string">
            <column name="BILLING_SEQUENCE" />
        </property>
        <property name="policyholderFirstName" type="string">
            <column name="POLICYHOLDER_FIRST_NAME" />
        </property>
        <property name="policyholderLastName" type="string">
            <column name="POLICYHOLDER_LAST_NAME" />
        </property>
        <property name="policyholderEmployer" type="string">
            <column name="POLICYHOLDER_EMPLOYER" />
        </property>
        <property name="policyholderRelationship" type="string">
            <column name="POLICYHOLDER_RELATIONSHIP" />
        </property>
        <property name="policyholderSSN" type="string">
            <column name="POLICYHOLDER_SSN" />
        </property>
        <property name="policyholderDOB" type="date">
            <column name="POLICYHOLDER_DOB" />
        </property>
        <property name="effectiveStartDate" type="date">
            <column name="EFFECTIVE_START_DATE" length="7" />
        </property>
        <property name="effectiveEndDate" type="date">
            <column name="EFFECTIVE_END_DATE" length="7" />
        </property>        
        <property name="medicareEligible" type="string">
            <column name="MEDICARE_ELIGIBLE" length="32" />
        </property>
        <property name="medicareType" type="string">
            <column name="MEDICARE_TYPE" />
        </property>        
        <property name="policyNumber" type="string">
            <column name="POLICY_NUMBER" />
        </property>
        <property name="groupNumber" type="string">
            <column name="GROUP_NUMBER" />
        </property>
        <property name="planName" type="string">
            <column name="PLAN_NAME" />
        </property>
        <property name="planType" type="string">
            <column name="PLAN_TYPE" />
        </property>
        
        <property name="payerName" type="string">
            <column name="PAYER_NAME" />
        </property>
        <property name="payerId" type="string">
            <column name="PAYER_ID" />
        </property>
        <property name="payerType" type="string">
            <column name="PAYER_TYPE" />
        </property>
        <property name="pbmName" type="string">
            <column name="PBM_NAME" />
        </property>
        <property name="pbmNumber" type="string">
            <column name="PBM_NUMBER" />
        </property>
        <property name="pbmGroupNumber" type="string">
            <column name="PBM_GROUP_NUMBER" />
        </property>
        <property name="pbmContact" type="string">
            <column name="PBM_CONTACT" />
        </property>
        
        <property name="drugCard" type="string">
            <column name="DRUG_CARD" />
        </property>
        <property name="clientInsuranceId" type="string">
            <column name="CLIENT_INSURANCE_ID" />
        </property>
        <property name="comments" type="string">
            <column name="COMMENTS" />
        </property>
        <set name="benefitses" inverse="true" cascade="save-update">
            <key>
                <column name="INSURANCE_ID" />
            </key>
            <one-to-many class="com.Benefits" />
        </set>
        <set name="empAddresses" table="INSURANCE_EMPLOYER_ADDRESS_MAP" cascade="save-update">
            <key>
                <column name="INSURANCE_ID" not-null="true" />
            </key>
            <many-to-many class="com.Address" column="ADDRESS_ID" />
        </set>
        <set name="empPhones" table="INSURANCE_EMPLOYER_PHONE_MAP" cascade="save-update">
            <key>
                <column name="INSURANCE_ID" not-null="true" />
            </key>
            <many-to-many class="com.Phone" column="PHONE_ID" />
        </set>
        <set name="pbmPhones" table="INSURANCE_PBM_PHONE_MAP" cascade="save-update">
            <key>
                <column name="INSURANCE_ID" not-null="true" />
            </key>
            <many-to-many class="com.Phone" column="PHONE_ID" />
        </set>
        <set name="phones" table="INSURANCE_PHONE_MAP" cascade="save-update">
            <key>
                <column name="INSURANCE_ID" not-null="true" />
            </key>
            <many-to-many class="com.Phone" column="PHONE_ID" />
        </set>
        <set name="payerAddresses" table="INSURANCE_PAYER_ADDRESS_MAP" cascade="save-update">
            <key>
                <column name="INSURANCE_ID" not-null="true" />
            </key>
            <many-to-many class="com.Address" column="ADDRESS_ID" />
        </set>
        
    </class>
</hibernate-mapping>
 
**********************************
 
<?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>
<!-- 
        Auto-generated mapping file from
        the hibernate.org cfg2hbm engine
-->
    <class name="com.DrugAllergies" table="DRUG_ALLERGIES" schema="STAGE">
        <id name="id"  type="long">
            <column name="ID" />
            <generator class="sequence">
            <param name="sequence">DRUG_ALLERGIES_SEQ</param>
        </generator>
        </id>
        <many-to-one name="patient" class="com.Patient">
            <column name="PATIENT_ID" not-null="true"/>
        </many-to-one>
        <property name="drug" type="string">
            <column name="DRUG" />
        </property>
        <property name="reactionOnsetDate" type="date">
            <column name="REACTION_ONSET_DATE" length="7" />
        </property>
        <property name="shockSymptom" type="string">
            <column name="SHOCK_SYMPTOM" />
        </property>
        <property name="skinSymptom" type="string">
            <column name="SKIN_SYMPTOM" />
        </property>
        <property name="asthmaSymptom" type="string">
            <column name="ASTHMA_SYMPTOM" />
        </property>
        <property name="nauseaSymptom" type="string">
            <column name="NAUSEA_SYMPTOM" />
        </property>
        <property name="anemiaSymptom" type="string">
            <column name="ANEMIA_SYMPTOM" />
        </property>
        <property name="otherSymptom" type="string">
            <column name="OTHER_SYMPTOM" />
        </property>
        <property name="otherDescription" type="string">
            <column name="OTHER_DESCRIPTION" />
        </property>
        <property name="comments" type="string">
            <column name="COMMENTS" length="2000" />
        </property>
    </class>
</hibernate-mapping>
 
********************************
 
<?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>
<!-- 
        Auto-generated mapping file from
        the hibernate.org cfg2hbm engine
-->
    <class name="com.Diagnosis" table="DIAGNOSIS" schema="STAGE">
        <id name="id"  type="long">
            <column name="ID" />
            <generator class="sequence">
            <param name="sequence">DIAGNOSIS_SEQ</param>
        </generator>
        </id>
        <many-to-one name="patient" class="com.Patient">
            <column name="PATIENT_ID" not-null="true"/>
        </many-to-one>
        <property name="icd9code" type="string">
            <column name="ICD9CODE" />
        </property>
        <property name="startdate" type="date">
            <column name="STARTDATE" length="7" />
        </property>
        <property name="enddate" type="date">
            <column name="ENDDATE" length="7" />
        </property>
        <property name="comments" type="string">
            <column name="COMMENTS" length="2000" />
        </property>
    </class>
</hibernate-mapping>
 

************************************
 
<?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>
<!-- 
        Auto-generated mapping file from
        the hibernate.org cfg2hbm engine
-->
    <class name="com.Dea" table="DEA" schema="STAGE">
        <id name="id"  type="long">
            <column name="ID" />
            <generator class="sequence">
            <param name="sequence">DEA_SEQ</param>
        </generator>
        </id>
        <many-to-one name="physician" class="com.Physician">
            <column name="PHYSICIAN_ID" not-null="true"/>
        </many-to-one>
        <property name="deaNumber" type="string">
            <column name="DEA_NUMBER" />
        </property>
        <property name="expirationDate" type="date">
            <column name="EXPIRATION_DATE" length="7" />
        </property>
    </class>
</hibernate-mapping>
 

*************************************
 
<?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>
<!-- 
        Auto-generated mapping file from
        the hibernate.org cfg2hbm engine
-->
    <class name="com.Benefits" table="BENEFITS" schema="STAGE">
        <id name="id"  type="long">
            <column name="ID" />
            <generator class="sequence">
            <param name="sequence">BENEFIT_SEQ</param>
        </generator>
        </id>
        <many-to-one name="insurance" class="com.Insurance">
            <column name="INSURANCE_ID" not-null="true"/>
        </many-to-one>
        <property name="payorName" type="string">
            <column name="PAYOR_NAME" />
        </property>
        <property name="contactPerson" type="string">
            <column name="CONTACT_PERSON" />
        </property>
        <property name="copayAmount" type="big_decimal">
            <column name="COPAY_AMOUNT" precision="22" scale="0" />
        </property>
        <property name="percentDollar" type="string">
            <column name="PERCENT_DOLLAR" length="32" />
        </property>
        <property name="quantity" type="big_decimal">
            <column name="QUANTITY" precision="22" scale="0" />
        </property>
        <property name="deductible" type="big_decimal">
            <column name="DEDUCTIBLE" precision="22" scale="0" />
        </property>
        <property name="deductibleMet" type="big_decimal">
            <column name="DEDUCTIBLE_MET" precision="22" scale="0" />
        </property>
        <property name="coverageAfterDeductible" type="big_decimal">
            <column name="COVERAGE_AFTER_DEDUCTIBLE" precision="22" scale="0" />
        </property>
        <property name="lifetimeLimit" type="string">
            <column name="LIFETIME_LIMIT" />
        </property>
        <property name="annualLimit" type="string">
            <column name="ANNUAL_LIMIT" />
        </property>
        <property name="percentPaid" type="big_decimal">
            <column name="PERCENT_PAID" precision="22" scale="0" />
        </property>
        <property name="maximumOutOfPocket" type="big_decimal">
            <column name="MAXIMUM_OUT_OF_POCKET" precision="22" scale="0" />
        </property>
        <property name="maximumOutOfPocketMet" type="big_decimal">
            <column name="MAXIMUM_OUT_OF_POCKET_MET" precision="22" scale="0" />
        </property>
        <property name="pharmacyCap" type="big_decimal">
            <column name="PHARMACY_CAP" precision="22" scale="0" />
        </property>
        <property name="pharmacyCapMet" type="big_decimal">
            <column name="PHARMACY_CAP_MET" precision="22" scale="0" />
        </property>
        <property name="stoploss" type="string">
            <column name="STOPLOSS" length="32" />
        </property>
        <property name="preexistingCondition" type="string">
            <column name="PREEXISTING_CONDITION" length="32" />
        </property>
        <property name="comments" type="string">
            <column name="COMMENTS" length="2000" />
        </property>
        <set name="priorAuthorizations" inverse="true" cascade="save-update">
            <key>
                <column name="BENEFIT_ID" />
            </key>
            <one-to-many class="com.PriorAuthorization" />
        </set>
    </class>
</hibernate-mapping>
 

**********************************
 
<?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>
<!-- 
        Auto-generated mapping file from
        the hibernate.org cfg2hbm engine
-->
    <class name="com.Attributes" table="ATTRIBUTES" schema="STAGE">
        <id name="id"  type="long">
            <column name="ID" />
            <generator class="sequence">
            <param name="sequence">ATTRIBUTES_SEQ</param>
        </generator>
        </id>
        <many-to-one name="notification" class="com.Notification">
            <column name="NOTIFICATION_ID"  not-null="true"/>
        </many-to-one>
        <property name="domain" type="string">
            <column name="DOMAIN" />
        </property>
        <property name="name" type="string">
            <column name="NAME" />
        </property>
        <property name="value" type="string">
            <column name="VALUE" length="4000" />
        </property>
    </class>
</hibernate-mapping>
 
************************************
 
<?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>
<!-- 
        Auto-generated mapping file from
        the hibernate.org cfg2hbm engine
-->
    <class name="com.Attachments" table="ATTACHMENTS" schema="STAGE">
        <id name="id"  type="long">
            <column name="ID" />
            <generator class="sequence">
            <param name="sequence">ATTACHMENTS_SEQ</param>
        </generator>
        </id>
        <many-to-one name="notification" class="com.Notification">
            <column name="NOTIFICATION_ID"  not-null="true"/>
        </many-to-one>
        <property name="domain" type="string">
            <column name="DOMAIN" />
        </property>
        <property name="type" type="string">
            <column name="TYPE" />
        </property>
        <property name="name" type="string">
            <column name="NAME" />
        </property>
        <property name="value" type="blob">
            <column name="VALUE" />
        </property>
    </class>
</hibernate-mapping>
 
*******************
 
<?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>
<!-- 
        Auto-generated mapping file from
        the hibernate.org cfg2hbm engine
-->
    <class name="com.Address" table="ADDRESS" schema="STAGE">
        <id name="id"  type="long">
            <column name="ID" />
            <generator class="sequence">
            <param name="sequence">ADDRESS_SEQ</param>
        </generator>
        </id>
        <property name="type" type="string">
            <column name="TYPE" />
        </property>
        <property name="contactperson" type="string">
            <column name="CONTACTPERSON" />
        </property>
        <property name="address1" type="string">
            <column name="ADDRESS1" />
        </property>
        <property name="address2" type="string">
            <column name="ADDRESS2" />
        </property>
        <property name="city" type="string">
            <column name="CITY" />
        </property>
        <property name="state" type="string">
            <column name="STATE" />
        </property>
        <property name="zip" type="string">
            <column name="ZIP" />
        </property>
        <property name="countryCode" type="string">
            <column name="COUNTRY_CODE" />
        </property>
        <property name="county" type="string">
            <column name="COUNTY" />
        </property>
        <set name="phones" table="ADDRESS_PHONE_MAP" cascade="save-update">
            <key>
                <column name="ADDRESS_ID"  not-null="true" />
            </key>
            <many-to-many class="com.Phone" column="PHONE_ID" />
        </set>
    </class>
</hibernate-mapping>
 

*****************************
 
<?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>
<!-- 
        Auto-generated mapping file from
        the hibernate.org cfg2hbm engine
-->
    <class name="com.PatientAssistance" table="PATIENT_ASSISTANCE" schema="STAGE">
        <id name="id"  type="long">
            <column name="ID" />
            <generator class="sequence">
            <param name="sequence">PATIENT_ASSISTANCE_SEQ</param>
        </generator>
        </id>
        <many-to-one name="patient" class="com.Patient">
            <column name="PATIENT_ID" not-null="true" />
        </many-to-one>
        <property name="startDate" type="date">
            <column name="START_DATE" length="7" />
        </property>
        <property name="endDate" type="date">
            <column name="END_DATE" length="7" />
        </property>
        <property name="programName" type="string">
            <column name="PROGRAM_NAME" length="250" />
        </property>
        <property name="programId" type="string">
            <column name="PROGRAM_ID" length="250" />
        </property>
    </class>
</hibernate-mapping>
 

*******************************
 
<?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>
<!-- 
        Auto-generated mapping file from
        the hibernate.org cfg2hbm engine
-->
    <class name="com.PatientRelations" table="PATIENT_RELATIONS" schema="STAGE">
        <id name="id"  type="long">
            <column name="ID" />
            <generator class="sequence">
            <param name="sequence">PATIENT_RELATIONS_SEQ</param>
        </generator>
        </id>
        <many-to-one name="patient" class="com.Patient">
          <column name="PATIENT_ID" not-null="true" />
        </many-to-one>
        <property name="firstName" type="string">
            <column name="FIRST_NAME" />
        </property>
        <property name="lastName" type="string">
            <column name="LAST_NAME" />
        </property>
        <property name="middleName" type="string">
            <column name="MIDDLE_NAME" />
        </property>
        <property name="generation" type="string">
            <column name="GENERATION" />
        </property>
        <property name="relationship" type="string">
            <column name="RELATIONSHIP" />
        </property>
        <property name="ssn" type="string">
            <column name="SSN" />
        </property>
        <property name="responsiblePartyFlag" type="string">
            <column name="RESPONSIBLE_PARTY_FLAG" length="32" />
        </property>
        <property name="emergencyContactFlag" type="string">
            <column name="EMERGENCY_CONTACT_FLAG" length="32" />
        </property>
        <property name="financiallyResponsibleFlag" type="string">
            <column name="FINANCIALLY_RESPONSIBLE_FLAG" length="32" />
        </property>
        <property name="employmentStatus" type="string">
            <column name="EMPLOYMENT_STATUS" />
        </property>
        <property name="comments" type="string">
            <column name="COMMENTS" length="2000" />
        </property>
        <set name="addresses" table="PATIENT_RELATIONS_ADDRESS_MAP" cascade="save-update">
            <key>
                <column name="PATIENT_RELATIONS_ID" not-null="true" />
            </key>
            <many-to-many class="com.Address" column="ADDRESS_ID" />
        </set>
        <set name="phones" table="PATIENT_RELATIONS_PHONE_MAP" cascade="save-update">
            <key>
                <column name="PATIENT_RELATIONS_ID" not-null="true" />
            </key>
            <many-to-many class="com.Phone" column="PHONE_ID" />
        </set>
        <set name="empAddresses" table="PATIENT_REL_EMP_ADDRESS_MAP" cascade="save-update">
            <key>
                <column name="PATIENT_RELATIONS_ID" not-null="true" />
            </key>
            <many-to-many class="com.Address" column="ADDRESS_ID" />
        </set>
        <set name="empPhones" table="PATIENT_REL_EMP_PHONE_MAP" cascade="save-update">
            <key>
                <column name="PATIENT_RELATIONS_ID" not-null="true" />
            </key>
            <many-to-many class="com.Phone" column="PHONE_ID" />
        </set>
    </class>
</hibernate-mapping>
 
***************
 
<?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>
<!-- 
        Auto-generated mapping file from
        the hibernate.org cfg2hbm engine
-->
    <class name="com.Phone" table="PHONE" schema="STAGE">
       <id name="id"  type="long">
            <column name="ID" />
            <generator class="sequence">
            <param name="sequence">PHONE_SEQ</param>
        </generator>
        </id>
        <property name="phoneType" type="string">
            <column name="PHONE_TYPE" length="32" />
        </property>
        <property name="areaCode" type="string">
            <column name="AREA_CODE" length="32" />
        </property>
        <property name="prefix" type="string">
            <column name="PREFIX" length="32" />
        </property>
        <property name="suffix" type="string">
            <column name="SUFFIX" length="32" />
        </property>
        <property name="extension" type="string">
            <column name="EXTENSION" length="32" />
        </property>
    </class>
</hibernate-mapping>
 
************************
 
<?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>
<!-- 
        Auto-generated mapping file from
        the hibernate.org cfg2hbm engine
-->
    <class name="com.Physician" table="PHYSICIAN" schema="STAGE">
        <id name="id"  type="long">
            <column name="ID" />
            <generator class="sequence">
            <param name="sequence">PHYSICIAN_SEQ</param>
        </generator>
        </id>
        <many-to-one name="patient" class="com.Patient">
            <column name="PATIENT_ID" />
        </many-to-one>
        <property name="firstName" type="string">
            <column name="FIRST_NAME" />
        </property>
        <property name="lastName" type="string">
            <column name="LAST_NAME" />
        </property>
        <property name="middleName" type="string">
            <column name="MIDDLE_NAME" />
        </property>
        <property name="title" type="string">
            <column name="TITLE" />
        </property>
        <property name="specialty" type="string">
            <column name="SPECIALTY" />
        </property>
        <property name="prescriberNumber" type="string">
            <column name="PRESCRIBER_NUMBER" />
        </property>
        <property name="prescriberNumberType" type="string">
            <column name="PRESCRIBER_NUMBER_TYPE" />
        </property>
        <property name="siteName" type="string">
            <column name="SITE_NAME" />
        </property>
        <property name="officeContact" type="string">
            <column name="OFFICE_CONTACT" />
        </property>
        <property name="physicianId" type="string">
            <column name="PHYSICIAN_ID" />
        </property>
        <property name="physicianNpi" type="string">
            <column name="PHYSICIAN_NPI" />
        </property>
        <set name="deas" inverse="true"  cascade="save-update">
            <key>
                <column name="PHYSICIAN_ID"/>
            </key>
            <one-to-many class="com.Dea" />
        </set>
        <set name="addresses" table="PHYSICIAN_ADDRESS_MAP" cascade="save-update">
            <key>
                <column name="PHYSICIAN_ID" not-null="true" />
            </key>
            <many-to-many class="com.Address" column="ADDRESS_ID" />
        </set>
        <set name="emails" table="PHYSICIAN_EMAIL_MAP" cascade="save-update">
            <key>
                <column name="PHYSICIAN_ID" not-null="true" />
            </key>
            <many-to-many class="com.Email" column="EMAIL_ID" />
        </set>
    </class>
</hibernate-mapping>
 
******************************
 
<?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>
<!-- 
        Auto-generated mapping file from
        the hibernate.org cfg2hbm engine
-->
    <class name="com.Prescription" table="PRESCRIPTION" schema="STAGE">
        <id name="id"  type="long">
            <column name="ID" />
            <generator class="sequence">
            <param name="sequence">PRESCRIPTION_SEQ</param>
        </generator>
        </id>
        <many-to-one name="patient" class="com.Patient">
            <column name="PATIENT_ID" />
        </many-to-one>
        <property name="ndc" type="string">
            <column name="NDC" />
        </property>
        <property name="prescriberNumber" type="string">
            <column name="PRESCRIBER_NUMBER" />
        </property>
        <property name="quantity" type="string">
            <column name="QUANTITY"/>
        </property>
        <property name="refill" type="string">
            <column name="REFILL"/>
        </property>
        <property name="prescriptionNumber" type="string">
            <column name="PRESCRIPTION_NUMBER" />
        </property>
        <property name="prescriptionShipType" type="string">
            <column name="PRESCRIPTION_SHIP_TYPE" />
        </property>
        <property name="therapyType" type="string">
            <column name="THERAPY_TYPE" />
        </property>
        <property name="drugroute" type="string">
            <column name="DRUGROUTE" />
        </property>
        <property name="maxRefills" type="string">
            <column name="MAX_REFILLS" />
        </property>
        <property name="prescriptionShipDate" type="date">
            <column name="PRESCRIPTION_SHIP_DATE" length="7" />
        </property>
        <property name="shipmentDurationInDays" type="big_decimal">
            <column name="SHIPMENT_DURATION_IN_DAYS" precision="22" scale="0" />
        </property>
        <property name="numberOfDoses" type="string">
            <column name="NUMBER_OF_DOSES" />
        </property>
        <property name="frequency" type="string">
            <column name="FREQUENCY" />
        </property>
        <property name="verbalOrder" type="string">
            <column name="VERBAL_ORDER" />
        </property>
        <property name="storageType" type="string">
            <column name="STORAGE_TYPE" />
        </property>
        <property name="nextDeliveryDate" type="date">
            <column name="NEXT_DELIVERY_DATE" length="7" />
        </property>
        <property name="nextDeliveryNote" type="string">
            <column name="NEXT_DELIVERY_NOTE" />
        </property>
        <property name="specialInstructions" type="string">
            <column name="SPECIAL_INSTRUCTIONS" length="4000" />
        </property>
        <property name="labelInstructions" type="string">
            <column name="LABEL_INSTRUCTIONS" length="4000" />
        </property>
        <property name="deliveryInstructions" type="string">
            <column name="DELIVERY_INSTRUCTIONS" length="4000" />
        </property>
        <property name="employmentFlag" type="string">
            <column name="EMPLOYMENT_FLAG" length="10" />
        </property>
        <property name="autoAccidentFlag" type="string">
            <column name="AUTO_ACCIDENT_FLAG" length="10" />
        </property>
        <property name="otherAccidentFlag" type="string">
            <column name="OTHER_ACCIDENT_FLAG" length="10" />
        </property>
        <property name="accidentState" type="string">
            <column name="ACCIDENT_STATE" length="10" />
        </property>
        <property name="rxWrittenDate" type="date">
            <column name="RX_WRITTEN_DATE" length="7" />
        </property>
        <property name="rxStartDate" type="date">
            <column name="RX_START_DATE" length="7" />
        </property>
        <property name="rxStopDate" type="date">
            <column name="RX_STOP_DATE" length="7" />
        </property>
        <property name="refillThruDate" type="date">
            <column name="REFILL_THRU_DATE" length="7" />
        </property>
        <property name="triplicateSerialNumber" type="string">
            <column name="TRIPLICATE_SERIAL_NUMBER" />
        </property>
        <property name="dawCode" type="string">
            <column name="DAW_CODE" />
        </property>
        <property name="orderTakenCode" type="string">
            <column name="ORDER_TAKEN_CODE" />
        </property>
        <property name="comments" type="string">
            <column name="COMMENTS" length="2000" />
        </property>
        <property name="localPharmacyName" type="string">
            <column name="LOCAL_PHARMACY_NAME" />
        </property>
        
        <set name="locPharmPhones" table="PRESC_LOC_PHARM_PHONE_MAP" cascade="save-update">
            <key>
                <column name="PRESCRIPTION_ID" not-null="true" />
            </key>
            <many-to-many class="com.Phone" column="PHONE_ID" />
        </set>
    </class>
</hibernate-mapping>
 
*******************************
 
<?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>
<!-- 
        Auto-generated mapping file from
        the hibernate.org cfg2hbm engine
-->
    <class name="com.PriorAuthorization" table="PRIOR_AUTHORIZATION" schema="STAGE">
        <id name="id"  type="long">
            <column name="ID" />
            <generator class="sequence">
            <param name="sequence">PRIOR_AUTHORIZATION_SEQ</param>
        </generator>
        </id>
        <many-to-one name="benefit" class="com.Benefits">
            <column name="BENEFIT_ID" />
        </many-to-one>
        <property name="paId" type="string">
            <column name="PA_ID" />
        </property>
 
        <property name="paContact" type="string">
            <column name="PA_CONTACT" />
        </property>
      
        <property name="paNumber" type="string">
            <column name="PA_NUMBER" />
        </property>
        <property name="paStartDate" type="date">
            <column name="PA_START_DATE" length="7" />
        </property>
        <property name="paEndDate" type="date">
            <column name="PA_END_DATE" length="7" />
        </property>
        <property name="paNumberFills" type="string">
            <column name="PA_NUMBER_FILLS" />
        </property>
      
        <property name="priorAuthorizationRequired" type="string">
            <column name="PRIOR_AUTHORIZATION_REQUIRED" length="32" />
        </property>
        <set name="phones" table="PRIOR_AUTHORIZATION_PHONE_MAP" cascade="save-update">
            <key>
                <column name="PRIOR_AUTHORIZATION_ID" not-null="true" />
            </key>
            <many-to-many class="com.Phone" column="PHONE_ID" />
        </set>
    </class>
</hibernate-mapping>
 
******************************
 
<?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>
<!-- 
        Auto-generated mapping file from
        the hibernate.org cfg2hbm engine
-->
    <class name="com.Referal" table="REFERAL" schema="STAGE">
        <id name="id"  type="long">
            <column name="ID" />
            <generator class="sequence">
            <param name="sequence">REFERRAL_SEQ</param>
        </generator>
        </id>
        <many-to-one name="patient" class="com.Patient">
            <column name="PATIENT_ID" not-null="true"/>
        </many-to-one>
        <property name="responseRequiredDate" type="date">
            <column name="RESPONSE_REQUIRED_DATE" length="7" />
        </property>
        <property name="patientReferredToClientDate" type="date">
            <column name="PATIENT_REFERRED_TO_CLIENT" length="7" />
        </property>
        <property name="source" type="string">
            <column name="SOURCE" />
        </property>
        <property name="sourceId" type="string">
            <column name="SOURCE_ID" />
        </property>
        <property name="comments" type="string">
            <column name="COMMENTS" />
        </property>        
    </class>
</hibernate-mapping>
 
************************
 
<?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>
<!-- 
        Auto-generated mapping file from
        the hibernate.org cfg2hbm engine
-->
    <class name="com.Email" table="EMAIL" schema="STAGE">
        <id name="id"  type="long">
            <column name="ID" />
            <generator class="sequence">
            <param name="sequence">EMAIL_SEQ</param>
        </generator>
        </id>
        <property name="sequence" type="big_decimal">
            <column name="SEQUENCE" precision="22" scale="0" />
        </property>
        <property name="type" type="string">
            <column name="TYPE" length="32" />
        </property>
        <property name="address" type="string">
            <column name="ADDRESS" length="100" />
        </property>
    </class>
</hibernate-mapping>
 

Thanks

[Mark Spritzler]

Wow, lots of stuff.

Is it

session.save(notification);

or session.save(data);

that is your code. In one post I see "data" and in the last one I see "notification". probably not the issue, but confusing to me.

I don't see anything in your mapping that looks weird, but there is lots to it. Your HibernateUtil is a bit older ways of doing things, as you can now call getCurrentSession from the SessionFactory, but you might be using Hibernate 2.x instead.

Anyone else see anything to help Mike out?

Mark