instanceof java
instanceof java is a java related one.
Hibernate Native sql query with example
Posted: Nov 7, 2016 9:46 AM
This post originated from an RSS feed registered with Java Buzz
by instanceof java.
Original Post: Hibernate Native sql query with example
Latest Java Buzz Posts
instanceof java
Instance Of Java
Advertisement
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 SQLSQLQuery 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
Read: Hibernate Native sql query with example
Previous Topic
