update problem

[lynn fann]

i tried to do the update for records, but the datas are not being update and there are no errors.

im using hibnerateUtils.update(oSession,obj);

I pass in the session and the Object to be updated. but the datas in the DB does not change. In the console, the update HQL did print out.

Im really lost in this. thanks.

[saranga rao]

Hi,

Can you give more details related to tables/Codes/database connection/hbm.xml/main?



regards
Saranga

[lynn fann]

update function:

 Date oDate = new Date();
            oSession = HibernateUtils.openSession();
            List lEnq= HibernateAction.search(oSession, "from Enquiry where id="+threadId);
            Enquiry oEnquiry = (Enquiry) lEnq.get(0);
            Long id= (Long)oSession.getIdentifier(oEnquiry);
            Enquiry oEnq = (Enquiry) oSession.get(Enquiry.class, id);
            oEnq.setQueryStatus(queryStatus);
            oEnq.setModifyDate(oDate);
            
            HibernateUtils.flushSession();

main():

msgr.updateThreadDetails(30,3)

from the console, this line is printed:
Hibernate: update CTHREAD set TOPIC_ID=?, MSG_TEXT=?, EMAIL_ADDR=?, SUBMIT_USER_ID=?, CREATED_DATE=?, THREAD_STATUS=?,
QUERY_REFERENCE_NO=?, QUERY_STATUS=?, LAST_MODIFY_DATE=?, RESOLUTION_MODE=?, RESOLUTION_STATUS=? where ID=?


mapping:

<hibernate-mapping>
    <class name="com.Enquiry" table="CTHREAD">
        <id name="id" column="ID">
            <generator class="increment"/>
        </id>    
        <set name="files" cascade="save-update" lazy="false">
           <key column="MESSAGE_ID" not-null="false"/>
           <one-to-many class="com.MessageAttachment"/>
       </set>
        <property name="topicId" type="java.lang.Integer" column="TOPIC_ID"/>
        <property name="msgText" type="java.lang.String" column="MSG_TEXT"/>
        <property name="emailAddr" type="java.lang.String" column="EMAIL_ADDR"/>
        <many-to-one name="consultant" 
        class="com.leadingside.core.common.pojo.Consultant" 
        not-null="false"
        insert="false"
        update="false">
        <column name="SUBMIT_USER_ID"/> 
        </many-to-one>
        <property name="submitUserId" type="java.lang.Integer" column="SUBMIT_USER_ID"/>
        <property name="creationDate" type="java.util.Date" column="CREATED_DATE"/>
        <property name="threadStatus" type="java.lang.Integer" column="THREAD_STATUS"/>                                              
        <property name="queryNo" type="java.lang.Integer" column="QUERY_REFERENCE_NO"/>
        <property name="queryStatus" type="java.lang.Integer" column="QUERY_STATUS"/>
        <property name="modifyDate" type="java.util.Date" column="LAST_MODIFY_DATE"/>
        <property name="resolutionMode" type="java.lang.Integer" column="RESOLUTION_MODE"/>         <property name="resolutionStatus" type="java.lang.String" column="RESOLUTION_STATUS"/>        
    </class>       
</hibernate-mapping>

[ May 10, 2007: Message edited by: lynn fann ]

[karthick swami]

To save changes to database:

A transaction has to be opened for the session.

Transaction txn = session.beginTransaction();

session.flush();
txn.commit();
session.close();

Only when transaction.commit is done it will reflect in the DB.

[lynn fann]

ok, i try that out. thanks