A lot of people ask me when i give sessions on IBatis.Which is better ?IBatis or Hibernate? IBatis maps the Java Objects to the SQL Query’s results. Hibernate, maps Java Objects to DB tables (Object-Relational Mapping). Hibernate automatically generates all the SQL for you. In IBatis you can directly write queried in SQL, thus if you are a good SQL programmer, you would find learning Ibatis very easy. Thus Ibatis allows you to do anything what could be done through SQL. Thus you can virtually know what the affect of a query would be.

• Hibernate is excellent for CRUD queries (Create, Read, Update, Delete) queries, and in applications where the object model is already ready.
• IBatis is much simpler to learn compared to Hibernate .
• On the other hand, Since you need to write all the queries by yourself, It has a much steeper development time and maintainability is comparatively difficult in Ibatis.
• Also if there is a change in object – model, one needs to go through all the queries and correct them, which isn’t much of a problem in hibernate.
• Hibernate does not support stored procedures. Ibatis does.
• IBatis is faster in terms of query processing time
• IBatis is better for batch inserts queries.
• IBatis is simpler.
• IBatis supports Dynamic Query which Hibernates doesn’t.
• Hibernate is close to Object Oriented development. Ibatis is close to relational DB.

Technorati : Hibernate, Ibatis

• Previous Entry: Hybrid ‘Air Car’ by 2010
• Next Entry: How to redirect a page to a subdomain ?