Does Hibernate support Native SQL Queries?

1.	Does Hibernate support Native SQL Queries?
Answer» Yes, it does. HIBERNATE provides the createSQLQuery() METHOD to let a developer call the native SQL statement directly and returns a Query object. Consider the example where you want to get employee data with the full name “Hibernate”. We don’t want to use HQL-based features, instead, we want to write our own SQL QUERIES. In this case, the code would be: Query query = session.createSQLQuery( "select * from interviewbit_employee ibe where ibe.fullName = :fullName") .addEntity(InterviewBitEmployee.class) .setParameter("fullName", "Hibernate"); //named parametersList result = query.list(); Alternatively, native queries can also be supported when USING NamedQueries.

Answer»

Yes, it does. HIBERNATE provides the createSQLQuery() METHOD to let a developer call the native SQL statement directly and returns a Query object.

Consider the example where you want to get employee data with the full name “Hibernate”. We don’t want to use HQL-based features, instead, we want to write our own SQL QUERIES. In this case, the code would be:

Query query = session.createSQLQuery( "select * from interviewbit_employee ibe where ibe.fullName = :fullName") .addEntity(InterviewBitEmployee.class) .setParameter("fullName", "Hibernate"); //named parametersList result = query.list();

Alternatively, native queries can also be supported when USING NamedQueries.

Discussion

No Comment Found

Related InterviewSolutions

Does Hibernate support Native SQL Queries?
Can you tell the difference between setMaxResults() and setFetchSize() of Query?
Collection mapping can be done using One-to-One and Many-to-One Associations. What do you think?
When is merge() method of the hibernate session useful?
What is hibernate caching?
What does session.lock() method in hibernate do?
What are Many to Many associations?
Can you tell something about one to many associations and how can we use them in Hibernate?
What is HQL?
What is criteria API in hibernate?