Hi,

When updating a Status column on a table, an update trigger is executed.

The problem is, I want Hibernate to generate the Update SQL statement even if the Status column value doesn't really change (DB value:"N", New value: "N").

It's a Legacy system and that how things were done... Is there a way to set the column's dirty flag or to tell Hibernate to generate the update statement no matter what?

Thanks


Hibernate version:
version 2.1.6, 9.8.2004

Sure. Apply a custom net.sf.hibernate.Interceptor; especially see the findDirty() method.

[url]
http://www.hibernate.org/hib_docs/api/n ... ang.Object[],java.lang.Object[],java.lang.String[],net.sf.hibernate.type.Type[])
[/url]

Thanks for your reply Steve.

I implemented an Interceptor as suggested. I turned Hibernate showsql ON and I can see that the Update sql is generated but, that's the last thing that gets executed... (it freezes on me)

Looks like my findDirty() method doesn't return the right value(s).


My hibernate.Form table has 12 columns (one identity column), so this is returning an array containing 11 indices. Do I need to do anything else for this to work?

Thanks

Here my Interceptor: (I took out the unnecessary code/methods)



public class FormStatusInterceptor implements Interceptor {

public int[] findDirty(Object entity, Serializable id, Object[] currentState, Object[] previousState,
String[] propertyNames, net.sf.hibernate.type.Type[] types) {

String className = entity.getClass().toString();

int[] results = null;
int count = 0;
if (className.equalsIgnoreCase("class hibernate.Form")) {
for (int i = 0; i < types.length; i++) {
if (results == null) {
results = new int[types.length];
}
results[count++] = i;
}
}

if (count == 0) {
return null;
} else {
int[] trimmed = new int[count];
System.arraycopy(results, 0, trimmed, 0, count);

System.out.println("FormStatusInterceptor - returning int[] : " + trimmed.length);

return trimmed;
}
}

...

}