ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Clinton Begin" <clinton.be...@gmail.com>
Subject Re: Hibernate 3.2 Native SQL versus iBATIS
Date Wed, 06 Aug 2008 19:53:14 GMT
More pros:

  * arbitrary mapping to non-bean/rich classes.. you can request primitives
or maps
  * mapping the same tables to multiple classes and vice versa
  * no assumptions about primary keys

In many cases you'll find you *can* do a lot of these things with Hibernate,
but it's more of a question of "should" you do it with Hibernate.

If you want an ORM, use Hibernate.  If you want to write SQL and map the
inputs and outputs, use iBATIS.

Clinton

On Wed, Aug 6, 2008 at 1:45 PM, Sundar Sankar <fatboysuns@gmail.com> wrote:

> Hi ,
>     Hibernate and Ibatis comparison is like comparing apples and oranges.
> Bothe serve different purposes. This is what I told folks at my company b4
> we decided to go in with Ibatis instead of Hibernate.
>
> Pros of Ibatis
> ===========
> 1. Stored procedure support is out of the world.
> 2. Not pure ORM and query control is primarily in our hands. We dont have
> to assume that the query would be generated in a particular way.
> 3. Hibernate doesnt work great if the tables arent well normalized.
> 4. Hibernate 2, had tonnes of memory issues when dealing with enterprise
> databases. Am not sure if 3 has solved it.
> 5. If we just wanna fetch 2 columns from a table having 25 columns,
> Hibernate plays bad in those scenarios.
>
> Other people could have different views, but these are what made me win
> over using ibatis in our project a year back.
>
> -Sundar
>
>
>
>
> On Wed, Aug 6, 2008 at 12:30 PM, mule_user <sgho@aol.com> wrote:
>
>>
>> Will it be possible to provide some pros and cons for the questions below:
>> 1. If I were to use Hibernate 3.2 with Native SQL in several places of the
>> project (because the database is complex and I do not have control over it
>> as a Java developer), am I better off using iBATIS instead?
>> 2. Will it be possible to cpmpare and contrast (pros and cons) Hibernate
>> 3.2
>> with Native SQL versus iBATIS?
>> --
>> View this message in context:
>> http://www.nabble.com/Hibernate-3.2-Native-SQL-versus-iBATIS-tp18857922p18857922.html
>> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>>
>>
>

Mime
View raw message