Newbie Question--Hibernate will not persist

[Russell Ray]

Okay, first let me apologize for such a basic question.....but I am so new I am at a lost on how to fix this simple issue.....

What I have done is created a MYSQL database with all the relationships. There are 3 Xref tables (Many to Many). One table uses a composite for the primary key. All the other tables are very simple relationships. I have used MyEclipse to reverse engineer the source code for Hibernate and Spring (DAOs). I corrected all the Spring errors and now I am onto the Hibernate error. I have updated the hbm.xml file adding the cascade styles for each class and changed the generator for each primary key to native. That's all the changes for the hbm.xl files

I made the first trial as simple as possible by only persisting one object with NO relationships (empty HashSet). However, I am getting this error:

--attach failed
 
org.springframework.orm.hibernate3.HibernateSystemException: reassociated object has dirty collection reference (or an array); nested exception is org.hibernate.HibernateException: reassociated object has dirty collection reference (or an array)
 
Caused by: 
 
org.hibernate.HibernateException: reassociated object has dirty collection reference (or an array)
 
            at org.hibernate.event.def.OnLockVisitor.processCollection(OnLockVisitor.java:66)
 
            at org.hibernate.event.def.AbstractVisitor.processValue(AbstractVisitor.java:101)
 
            at org.hibernate.event.def.AbstractVisitor.processValue(AbstractVisitor.java:61)
 
            at org.hibernate.event.def.AbstractVisitor.processEntityPropertyValues(AbstractVisitor.java:55)
 
            at org.hibernate.event.def.AbstractVisitor.process(AbstractVisitor.java:123)
 
            at org.hibernate.event.def.AbstractReassociateEventListener.reassociate(AbstractReassociateEventListener.java:78)
 
            at org.hibernate.event.def.DefaultLockEventListener.onLock(DefaultLockEventListener.java:59)
 
            at org.hibernate.impl.SessionImpl.fireLock(SessionImpl.java:579)
 
            at org.hibernate.impl.SessionImpl.lock(SessionImpl.java:571)
 
            at org.springframework.orm.hibernate3.HibernateTemplate$10.doInHibernate(HibernateTemplate.java:614)
 
            at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)
 
            at org.springframework.orm.hibernate3.HibernateTemplate.lock(HibernateTemplate.java:612)
 
            at jtdi.metadata.orm.dao.JtdiDocumentDAO.attachClean(JtdiDocumentDAO.java:167)
 
            at jtdi.metadata.persistence.bean.JtdiDocumentBean.addJtdiDocument(JtdiDocumentBean.java:19)
 
            at jtdi.metadata.business.helper.JtdiDocumentBusinessHelper.persistJtdiDocument(JtdiDocumentBusinessHelper.java:76)
 
            at jtdi.metadata.business.helper.JtdiDocumentBusinessHelper.main(JtdiDocumentBusinessHelper.java:131)
 

When I go looking at the Hibernate source code, I see this information concerning Hibernate's OnLockVisitor

 
if ( collection == null ) { 
//do nothing 
} 
else if ( collection instanceof PersistentCollection ) { 
....... // Do something 
} 
else { 
* // brand new collection 
//TODO: or an array!! we can't lock objects with arrays 
now?? 
throw new HibernateException( "reassociated object has 
dirty collection reference (or an array)" );* } 

As you can see for yourself this situation occurs if your collection is not a PersistentCollection (i.e. if you have replaced the collection completely after obtaining the object from the DB) or is you use array (not very likely). Because I have not replaced or created any collections, I am at a lost on how this could be...


Any suggestions would be greatly appreciated.

Russ

[Mark Spritzler]

I'd say post your mapping and your code that ends up calling this part of Hibernate that is throwing that exception.

Mark

[Russell Ray]

Mark,

Thank you so much for reading my post..........

Here is my mapping file:

<?xml version="1.0" encoding="utf-8"?>
 
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
 
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
 
 
 
<hibernate-mapping default-cascade="all">
 
    <class name="jtdi.metadata.orm.JtdiDocument" table="jtdi_document" catalog="jtdi_metadata_db">
 
        <id name="jtdiDocumentId" type="java.lang.Integer">
 
            <column name="jtdi_document_id" />
 
            <generator class="native" />
 
        </id>
 
        <property name="storagePath" type="java.lang.String">
 
            <column name="storage_path" length="256" />
 
        </property>
 
        <property name="storageHostName" type="java.lang.String">
 
            <column name="storage_host_name" length="50" />
 
        </property>
 
        <property name="docFileSize" type="java.lang.Long">
 
            <column name="doc_file_size" />
 
        </property>
 
        <property name="docFileName" type="java.lang.String">
 
            <column name="doc_file_name" length="50" />
 
        </property>
 
        <property name="docDescription" type="java.lang.String">
 
            <column name="doc_description" length="65535" />
 
        </property>
 
        <property name="docType" type="java.lang.String">
 
            <column name="doc_type" length="50" />
 
        </property>
 
        <property name="docCreationDate" type="java.util.Date">
 
            <column name="doc_creation_date" length="0" />
 
        </property>
 
        <property name="docUpdateDate" type="java.util.Date">
 
            <column name="doc_update_date" length="0" />
 
        </property>
 
        <property name="docTitle" type="java.lang.String">
 
            <column name="doc_title" length="256" />
 
        </property>
 
        <property name="docExpirationDate" type="java.util.Date">
 
            <column name="doc_expiration_date" length="0" />
 
        </property>
 
        <property name="docOsDate" type="java.util.Date">
 
            <column name="doc_os_date" length="0" />
 
        </property>
 
 
 
        <set name="operationMaintenances" inverse="true">
 
            <key><column name="fk_jtdi_doc_id" not-null="true" /></key>
 
            <one-to-many class="jtdi.metadata.orm.OperationMaintenance" />
 
        </set>
 
        <set name="engrDrawings" inverse="true">
 
            <key><column name="fk_jtdi_doc_id" not-null="true" /></key>
 
            <one-to-many class="jtdi.metadata.orm.EngrDrawing" />
 
        </set>
 
        <set name="metadataDocuments" inverse="true">
 
            <key><column name="fk_jtdi_document_id" not-null="true" /></key>
 
            <one-to-many class="jtdi.metadata.orm.MetadataDocument" />
 
        </set>
 
        <set name="technicalDirectiveBulletins" inverse="true">
 
            <key><column name="fk_jtdi_doc_id" not-null="true" /></key>
 
            <one-to-many class="jtdi.metadata.orm.TechnicalDirectiveBulletin" />
 
        </set>
 
        <set name="supplySupports" inverse="true">
 
            <key><column name="fk_jtdi_doc_id" not-null="true" /></key>
 
            <one-to-many class="jtdi.metadata.orm.SupplySupport" />
 
        </set>
 
        <set name="techDirectiveChanges" inverse="true">
 
            <key><column name="fk_jtdi_doc_id" not-null="true" /></key>
 
            <one-to-many class="jtdi.metadata.orm.TechDirectiveChange" />
 
        </set>
 
        <set name="techManuals" inverse="true">
 
            <key><column name="fk_jtdi_doc_id" not-null="true" /></key>
 
            <one-to-many class="jtdi.metadata.orm.TechManual" />
 
        </set>
 
        <set name="distribStmts" inverse="true">
 
            <key><column name="fk_jtdi_doc_id" not-null="true" /></key>
 
            <one-to-many class="jtdi.metadata.orm.DistribStmt" />
 
        </set>
 
        <set name="safetyMessages" inverse="true">
 
            <key><column name="fk_jtdi_doc_id" not-null="true" /></key>
 
            <one-to-many class="jtdi.metadata.orm.SafetyMessage" />
 
        </set>
 
        <set name="programMngDocuments" inverse="true">
 
            <key><column name="fk_jtdi_doc_id" not-null="true" /></key>
 
            <one-to-many class="jtdi.metadata.orm.ProgramMngDocument" />
 
        </set>
 
        <set name="iracs" inverse="true">
 
            <key><column name="fk_jtdi_doc_id" not-null="true" /></key>
 
            <one-to-many class="jtdi.metadata.orm.Irac" />
 
        </set>
 
        <set name="trainings" inverse="true">
 
            <key><column name="fk_jtdi_doc_id" not-null="true" /></key>
 
            <one-to-many class="jtdi.metadata.orm.Training" />
 
        </set>
 
        <set name="instructions" inverse="true">
 
            <key><column name="fk_jtdi_doc_id" not-null="true" /></key>
 
            <one-to-many class="jtdi.metadata.orm.Instruction" />
 
        </set>
 
        <set name="techPubDeficiencyRpts" inverse="true">
 
            <key><column name="fk_jtdi_doc_id" not-null="true" /></key>
 
            <one-to-many class="jtdi.metadata.orm.TechPubDeficiencyRpt" />
 
        </set>
 
        <set name="configManagements" inverse="true">
 
            <key><column name="fk_jtdi_doc_id" not-null="true" /></key>
 
            <one-to-many class="jtdi.metadata.orm.ConfigManagement" />
 
        </set>
 
        <set name="hazardousMaterials" inverse="true">
 
            <key><column name="fk_jtdi_doc_id" not-null="true" /></key>
 
            <one-to-many class="jtdi.metadata.orm.HazardousMaterial" />
 
        </set>
 
        <set name="securityClassifications" inverse="true">
 
            <key><column name="fk_jtdi_doc_id" not-null="true" /></key>
 
            <one-to-many class="jtdi.metadata.orm.SecurityClassification" />
 
        </set>
 
    </class>
 
</hibernate-mapping>
 

Here the method that calls the Hibernate framework:

 public void attachClean(JtdiDocument instance) {
 
            log.debug("attaching clean JtdiDocument instance");
 
            try {
 
                  getHibernateTemplate().lock(instance, LockMode.NONE);
 
                  log.debug("attach successful");
 
            } catch (RuntimeException re) {
 
                  log.error("attach failed", re);
 
                  throw re;
 
            }
 
      }
 

As you can see most of this was generated for me. I have made very little changes.

[Mark Spritzler]

So you are just setting a lock on an object? and it is just that line?

getHibernateTemplate().lock(instance, LockMode.NONE);

What do you need the lock for?

I must apologize, I do not use Spring, so I am not familiar with their framework.

for persist I usually have code like the following

Session session = sessionFactory.getSession();
Transaction t = session.beginTransaction();
MyObject m = new MyObject(blah blah blah, set up data);
session.saveOrUpdate(m);
t.commit()

All within a try-catch-finally where I clean up. Now with JPA the code is a little simpler with the EntityManager being injected, and if I was using EJB3 Stateless Sessio bean then I would just have

SOme transaction annotation then

public void newMyObject(){
    MyObject m = new MyObject(blah blah blah, set up data);
    em.persist(m);
}

Not that that really helps.

Mark

[Russell Ray]

Mark,

This is just the information I need.......

The tool I am using (MyEclipse) generates all the code for the DAOs. The DocumentDAO extends the HibernateSupportDAO. It handles most of the required method generation.

From your comment I can tell you are using the JDBC Template. I changed my code to use something very similar. The SQL generated call for UPDATE of the table. It return zero because no record was in the database with the id of 1. Actually the table is empty. When I tried the save function the SQL generated was an INSERT statement. In both cases no data was stored in the database.

The lock method obtains the specific lock level upon the given object, implicitly checking whether the corresponding database entry still exist. In my case, the lock mode is none. The database is empty so there is no corresponding database entry.

As far as JPA is concerned......It's a hard locked into Spring and Hibernate.

Russ

[Mark Spritzler]

From your comment I can tell you are using the JDBC Template.

Nope, I don't use any template. I don't use Spring.

Mark