What do you mean by Named - SQL query?
Submitted by: AdministratorNamed SQL queries are defined in the mapping xml document and called wherever required.
Example:
<sql-query name = “empdetails”>
<return alias=”emp” class=”com.test.Employee”/>
SELECT emp.EMP_ID AS {emp.empid},
emp.EMP_ADDRESS AS {emp.address},
emp.EMP_NAME AS {emp.name}
FROM Employee EMP WHERE emp.NAME LIKE :name
</sql-query>
Invoke Named Query :
List people = session.getNamedQuery(”empdetails”)
.setString(”TomBrady”, name)
.setMaxResults(50)
.list();
Submitted by: Administrator
Example:
<sql-query name = “empdetails”>
<return alias=”emp” class=”com.test.Employee”/>
SELECT emp.EMP_ID AS {emp.empid},
emp.EMP_ADDRESS AS {emp.address},
emp.EMP_NAME AS {emp.name}
FROM Employee EMP WHERE emp.NAME LIKE :name
</sql-query>
Invoke Named Query :
List people = session.getNamedQuery(”empdetails”)
.setString(”TomBrady”, name)
.setMaxResults(50)
.list();
Submitted by: Administrator
Read Online Hibernate Job Interview Questions And Answers
Top Hibernate Questions
| ☺ | How does Hibernate distinguish between transient (i.e. newly instantiated) and detached objects? |
| ☺ | What is HQL? |
| ☺ | Why do you need ORM tools like hibernate? |
| ☺ | What does ORM consists of? |
| ☺ | What are the general considerations or best practices for defining your Hibernate persistent classes? |
Top Java Programming Language Categories
| ☺ | Core Java Interview Questions. |
| ☺ | Hibernate Interview Questions. |
| ☺ | Advanced Java Interview Questions. |
| ☺ | IBM WebSphere Interview Questions. |
| ☺ | Spring Framework Interview Questions. |
