Help on Hibernate Mapping

lawale4me · **Posted:** Thu Feb 26, 2009 10:29 am

please i have an open source project i am working on and i need help as regards to limiting certain retrival from the database.
it goes like this.
i do not want to make money deposited in an account avaialble for withdrawal if the deposited amount is above more than 500,000.
i have a working table that uses hbm.xml mapping to reteive and insert
any ideas will be appreicated.
thanks

littypreethkr · **Posted:** Fri Feb 27, 2009 12:51 am

Ideally this should be done in the business layer. Or you can incorporate this logic into the setter of the withdrawal amount or use an Interceptor.onSave method to implement this.

lawale4me · **Posted:** Fri Feb 27, 2009 4:04 am

i understand the aspect of using setter to solve the problem which i am having problem comapring the money type with the threshold value.
i also need you to explain a little about the interceptor u mention how can that be achived?
thx

littypreethkr · **Posted:** Fri Feb 27, 2009 4:28 am

You can have something like this:

Code:

public class MyInterceptor extends EmptyInterceptor {

   public boolean onSave(Object entity, Serializable id, Object[] state,
         String[] propertyNames, Type[] types) throws CallbackException {
      if(entity instanceof Withdrawal) {
         Withdrawal itm = (Withdrawal) entity;
         if(itm.getAmount() > 500000) {
            throw new CallbackException("Withdrawal limit exceeded");
         }
      }
      return false;
   }
}

Now while opening a session you can use this interceptor like:

Code:

Session session = HibernateUtil.getSessionFactory().openSession(new MyInterceptor());
      session.beginTransaction();
.............
.............