I have read in many places about hibernate. It acts a layer between application and database.
sometimes you have to switch your database and at that time , it can be very helpful
I have tried hibernate in one of my project. I actually found it little slower than regular sql call.
I wasnt that much experienced at that time,Not sure may be I was doing something wrong.