When an update is issued to the database I don't see the update in the database. Hibernate prints the SQL statement. When i run that in the SQL editor the statement excutes fine with no errors. Can anyone let me know what are the points to be noted.

1. I load the data
2. set the new date
3. saveorupdate the data

Thanks

Do you do a session.flush() or Transaction.commit() after your saveOrUpdate?

Yes. I do.

well, you will at least probebly have to post the code here.

<?xml version="1.0"?>

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

<hibernate-mapping>
<class
name="com.trulogica.truaccess.request.model.EmailVerificationData"
table="EmailVerification"
dynamic-update="false"
dynamic-insert="false"
>

<id
name="emailVerificationId"
column="emailVerificationId"
type="int"
unsaved-value="0"
>
<generator class="com.trulogica.truaccess.idgen.util.HibernateIdGenerator">
<param name="TableName">EmailVerification</param>
</generator>
</id>

<property
name="creationTime"
type="date"
update="true"
insert="true"
column="creationTime"
/>

<property
name="EMail"
type="string"
update="true"
insert="true"
column="eMail"
/>

<property
name="GUID"
type="string"
update="true"
insert="true"
column="GUID"
/>

<property
name="instActivityId"
type="int"
update="true"
insert="true"
column="activityId"
/>

<property
name="keyField"
type="string"
update="true"
insert="true"
column="keyField"
/>

<property
name="status"
type="string"
update="true"
insert="true"
column="status"
/>

<property
name="verificationTime"
type="date"
update="true"
insert="true"
column="verificationTime"
/>

<!--
To add non XDoclet property mappings, create a file named
hibernate-properties-EmailVerificationData.xml
containing the additional properties and place it in your merge dir.
-->

</class>

</hibernate-mapping>







public void updateEmailVerificationData (EmailVerificationData emailVerificationData)
throws EmailVerificationException
{
Session session = null;
mLogger.finer("Entering the emailVerification table with " + emailVerificationData.toString());
try
{
session = PersistenceManager.getSession();
EmailVerificationData data =
(EmailVerificationData) session.load(
EmailVerificationData.class,
new Integer(emailVerificationData.getEmailVerificationId()));
mLogger.finer("Data loaded from the database is " +data.toString());
data.setStatus(emailVerificationData.getStatus());
data.setVerificationTime(emailVerificationData.getVerificationTime());
session.saveOrUpdate(data);
session.flush();
}
catch (Exception e)
{
mLogger.log(
Level.WARNING,
"[Exception] when updating the email verification data with verification data " + emailVerificationData.toString(),
e);
throw new EmailVerificationException(e);
}
finally
{
try
{
PersistenceManager.closeSession(session);
}
catch (HibernateException e)
{
throw new EmailVerificationException(e);
}
}
}

If i do a insert and then read it and print it, the record is printable. But its not in the data base ? Any clues ?

Use a transaction

Ya, you say you do use a transaction but where are you calling "session.beginTransaction()" in your code? You're not. So you're not really using a transaction.

Try this:



Cheers,
Rob