Aren't stored procedures always faster than dynamic SQL?

No! Hibernate always executes SQL statements using a JDBC PreparedStatement, which allows the database to cache the query plan. There is no reason to avoid the use of generated SQL in modern applicati

Can you tell us difference between Hibernate HQL over SQL?

HQL (Hibernate Query Language) is fully object oriented, with support for object inheritence, polymorphism and association, but SQL (Structure Query Language) is more of Relational with structured for

Define HibernateTemplate?

The org.springframework.orm.hibernate.HibernateTemplate is a helper class which provides different methods for querying/retrieving data from the database. It also converts checked HibernateExceptions 

Describe the various isolation levels defined by ANSI SQL standart?

The standart isolation levels are defined by the ANSI SQL standard but aren't particular to SQL databases:
  * Read uncommitted :- Permits dirty read but not lost updates. One transaction may not wri

Difference between getCurrentSession() and openSession() in Hibernate ?

A Session is opened when getCurrentSession() is called for the first time and closed when the transaction ends. It is also flushed automatically before the transaction commits. You can call getCurrent

Difference between session.update() and session.lock() in Hibernate ?

Both the session.update() and session.lock() are intended for re-attaching a detached object. The session.lock() method simply reattaches the object to the session without checking or updating the dat

Does Hibernate fully support polymorphism?

Hibernate supports polymorphic queries and associations in all three inheritance mapping strategies (and even allows mixing of the two most important strategies).

Does Hibernate implement its functionality using a minimal number of database queries?

Hibernate can make certain optimizations implement its functionality using a minimal number of database queries:
  * Caching objects
  * Executing SQL statement when needed.
  * Never updating unmo

Explain about HibernateTemplate?

The org.springframework.orm.hibernate.HibernateTemplate class simplifies Hibernate data access code, and converts checked HibernateExceptions into unchecked DataAccessExceptions, following the org.spr

Explain about mapping description file?

Hibernate can be configured with two types of files out of which hibernate.cfg.xml is the mapping description file in which Hibernate uses to configure its functions. This mapping file has an extensio