I have a custom UserType to convert mysql timestamps in the '0000-00-00 00:00:00' format to null. The problem with using the custom UserType is it makes the entity dirty. Since it is dirty it does update statements unnecessarily.

I have tried using interceptors but they don't always work. It is trying to update the record in the table when i try to get the result from the query.

I have also evicted the entity but that doesn't stop the initial update.

I am using hibernate inside a ejb by using an EntityManager.

I am using ejb 3.

hibernate version: 3.3.1
mysql version 5.1

Does anyone know how to get it to not try to run update statements when trying to load the entity?