Hibernate version:3

Mapping documents:
<class name="com.westgateresorts.salescommissions.businessobjects.SecurityParams" table="SEC_FORMS_PARAMETERS">
<id name="id" column="ID" type="java.lang.String" length="50" unsaved-value="null">
<generator class="assigned"/>
</id>
<property name="returnUrl" column="RETURN_URL" type="java.lang.String" length="2000" not-null="false"/>
<property name="sessionActive" column="SESSION_ACTIVE" type="java.lang.String" length="1" not-null="false"/>
</class>

Code between sessionFactory.openSession() and session.close():
String hql = "delete from SEC_FORMS_PARAMETERS s where s.id = :id";
Query query = getSession().createSQLQuery(hql);
query.setString("id",securityParams.getId());
int rowCount = query.executeUpdate();
//getHibernateTemplate().delete(securityParams);


Full stack trace of any exception that occurs:
No errors, executes all code but there are no deletes on the database

Name and version of the database you are using:Oracle 9i

Has anyone had success deleting or updated on Oracle over a database link? My JUNIT makes it through successfully but no deletes or updates are made over the database link. I can fetch over the database link fine, just no DML. Thanx for any help on this.

Hi emo7874,

Plz.. check your transaction setting.If you are not using transaction interceptor.you will have to use session.beginTransaction().