- By Using Hibernate Native SQL we can write database dependent queries as part of hibernate.
- Hibernate Native Sql allows us to write create , update, delete and insert queries.
- We can also call Stored procedures using Hibernate Native Sql.
- When the query is too complex using HQL then we need to use hibernate sql query.
- Hibernate uses the org.hibernate.SQLQuery interface for native SQL
- SQLQuery is a sub interface of Query
- Use createSQLQuery() factory method on Session to create SQLQuery object.
- Hibernate SQLQuery must be associated with an existing Hibernate entity or scalar result.
Hibernate native sql insert query example
- Session session = sessionFactory.openSession();
- session.beginTransaction();
- SQLQuery insertsqlQuery = session.createSQLQuery("INSERT INTO
- Physician(firstname,lastname,fee,hospital)VALUES(?,?,?,?)");
- insertsqlQuery.setParameter(0, "Saidesh");
- insertsqlQuery.setParameter(1, "Kilaru");
- insertsqlQuery.setParameter(2, 50);
- insertsqlQuery.setParameter(3, "Yashoda");
- insertsqlQuery.executeUpdate();
Hibernate scalar query example
- Writing a Hibernate Sql query to get list of scalars or values from single or multiple tables.
- Lets see an example on Hibernate scalar query.
- String hibernate_sql = "SELECT first_name, fee FROM Physician";
- SQLQuery query = session.createSQLQuery(hibernate_sql);
- query.setResultTransformer(Criteria.ALIAS_TO_ENTITY_MAP);
- List results = query.list();
Hibernate named sql Queries
- Writing a Hibernate Sql query to get entity object by using addEntity() method.
- Lets see an example on Hibernate named sql query
No comments