Introduction
Native Hibernate SQL Query is also one of the technique to perform an operation like Selection operations and non selection operations, Native SQL Query meanwhile selecting the data from the database, the execution will be done with Hibernate.
Hibernate application creates a Native Hibernate SQL Query uses the create SQLQuery () method. To execute the Native Hibernate SQL Query, object of SQLQuert needs to be created. Tables and columns will be directly given while executing the queries. Following are the mandatory points in Native SQL Query.
Following is the syntax to create an SQL Query object by calling the createSQLQuery () of Session interface.
- By using Hibernate SQL Query, Programmer converts an existing JDBC application to Hibernate application which is very easy.
- The disadvantage of Native SQL is, it makes Hibernate application as database dependent.
- With Native SQL, select commands and Non-select commands can be performed.
- To run the SQL commands in a database, create SQL Query object.
SQLQuery query = session.createSQLQuery(" SQL command ");
Description
While reading a full entity from Database by using Native SQL, Hibernate internally converts each row of ResultSet objects into objects [] and returns the list of objects. In SQL, there will be no POJO class name.
[java] SQLQuery query = session.createSQLQuery(" select * from IToolsInfo ");
List list=query.list();[/java]
To convert each row as POJO class object, then addEntity() has to be called. In addEntity() parameter is passed to the Pojo class object of the class.
[java] SQLQuery query=session.createSQLQuery(" select * from IToolsInfo ");
query.addEntity("IToolsInfo.class");
List list=query.list();[/java]
addEntity() present in query object.
To read the partial entity or more entities from a database, Hibernate internally stores a ResultSetMetaData.
[java] SQLQuery query=session.createSQLQuery("select employeeName,employeeSalary from IToolsInfo ");
query.addEntity("IToolsInfo.class");
List list=query.list();[/java]
This list object contains object[] array of ResultSetMetaData. Convert the specified columns of type, by calling the addScalar().
[java] SQLQuery query=session.createSQLQuery("select employeeName,employeeSalary from IToolsInfo ");
query.addSclar("employeeName", HIBERNATE.STRING);
query.addSclar("employeeSalary", HIBERNATE.STRING);
List list=query.list();[/java]
Description
When executing a non-select Queries(curd operations) on a database, transaction object has to begin.
[java] SQLQuery query = session.createSQLQuery("update IToolsInfo set salary=8000 where deptno=1");
Transaction transaction=session.beginTransaction();
int i=query.executeUpadate();
transaction.commit();[/java]
Key Points
- Native SQL Query makes Hibernate as database dependent.
- addEntity() method is used to build the query as entityQuery.
- To get the instance of SQLQuery, createSQLQuert() method will be used.