Sunitha,
While Hibernate is definitely a good option to research,
you should know that it is not the only one. iBATIS for instance is another widely supported framework framework for Java and .NET. iBATIS couples objects with stored procedures or SQL statements using a XML descriptor. What it brings on the table is simplicity. Now, arguably Hibernate is also based on simplicity. So, do the research, run two small prototypes and see for yourself.
On the features side, with iBATIS Data Mapper, you rely on your own objects, XML, and SQL. So, it claims to give you greater power of both SQL and stored procedures for your business logic. Whether you want to put business logic on the data layer is another question that only you can answer.
Sincerely,