{"id":887,"date":"2020-01-07T10:31:15","date_gmt":"2020-01-07T10:31:15","guid":{"rendered":"https:\/\/codeinsightacademy.com\/blog\/?p=887"},"modified":"2020-01-07T12:13:17","modified_gmt":"2020-01-07T12:13:17","slug":"hibernate-5-4-configuration","status":"publish","type":"post","link":"https:\/\/codeinsightacademy.com\/blog\/java\/hibernate-5-4-configuration\/","title":{"rendered":"Hibernate 5.4 Configuration"},"content":{"rendered":"

 <\/p>\n

Core Hibernate 5.4 Configuration<\/p>\n

<project xmlns=\"http:\/\/maven.apache.org\/POM\/4.0.0\"\r\n  xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"\r\n  xsi:schemaLocation=\"http:\/\/maven.apache.org\/POM\/4.0.0 https:\/\/maven.apache.org\/xsd\/maven-4.0.0.xsd\">\r\n  <modelVersion>4.0.0<\/modelVersion>\r\n  <groupId>HibernateProj<\/groupId>\r\n  <artifactId>HibernateProj<\/artifactId>\r\n  <version>0.0.1-SNAPSHOT<\/version>\r\n  <build>\r\n    <sourceDirectory>src<\/sourceDirectory>\r\n    <plugins>\r\n      <plugin>\r\n        <artifactId>maven-compiler-plugin<\/artifactId>\r\n        <version>3.8.0<\/version>\r\n        <configuration>\r\n          <source>1.8<\/source>\r\n          <target>1.8<\/target>\r\n        <\/configuration>\r\n      <\/plugin>\r\n    <\/plugins>\r\n  <\/build>\r\n  <dependencies>\r\n    <!-- https:\/\/mvnrepository.com\/artifact\/org.hibernate\/hibernate-core -->\r\n    <dependency>\r\n      <groupId>org.hibernate<\/groupId>\r\n      <artifactId>hibernate-core<\/artifactId>\r\n      <version>5.4.10.Final<\/version>\r\n    <\/dependency>\r\n\r\n    <!-- https:\/\/mvnrepository.com\/artifact\/mysql\/mysql-connector-java -->\r\n    <dependency>\r\n      <groupId>mysql<\/groupId>\r\n      <artifactId>mysql-connector-java<\/artifactId>\r\n      <version>8.0.15<\/version>\r\n    <\/dependency>\r\n  <\/dependencies>\r\n<\/project><\/pre>\n
<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n\r\n<!DOCTYPE hibernate-configuration PUBLIC\r\n\"-\/\/Hibernate\/Hibernate Configuration DTD 3.0\/\/EN\"\r\n\"http:\/\/hibernate.sourceforge.net\/hibernate-configuration-3.0.dtd\">\r\n<hibernate-configuration>\r\n    <session-factory>\r\n    \t<!-- <property name=\"hibernate.current_session_context_class\">thread<\/property> -->\r\n    \t<property name=\"hibernate.current_session_context_class\">org.hibernate.context.internal.ThreadLocalSessionContext<\/property>\r\n        <property name=\"hibernate.bytecode.use_reflection_optimizer\">false<\/property>\r\n        <property name=\"hibernate.connection.driver_class\">com.mysql.jdbc.Driver<\/property>\r\n        <property name=\"hibernate.connection.password\"><\/property>\r\n        <property name=\"hibernate.connection.url\">jdbc:mysql:\/\/localhost:3306\/test<\/property>\r\n        <property name=\"hibernate.connection.username\">root<\/property>\r\n        <property name=\"hibernate.dialect\">org.hibernate.dialect.MySQLDialect<\/property>\r\n        <property name=\"show_sql\">true<\/property>\r\n    <\/session-factory>\r\n<\/hibernate-configuration>\r\n<\/pre>\n
package com;\r\n\r\nimport java.sql.Connection;\r\nimport java.sql.DriverManager;\r\nimport java.sql.ResultSet;\r\nimport java.sql.Statement;\r\nimport java.util.List;\r\n\r\nimport org.hibernate.Criteria;\r\nimport org.hibernate.Session;\r\nimport org.hibernate.cfg.Configuration;\r\nimport org.hibernate.query.Query;\r\n\r\npublic class MainClass {\r\n  @SuppressWarnings(\"deprecation\")\r\n  public static void main(String[] args) {\r\n\r\n    try{  \r\n      Class.forName(\"com.mysql.cj.jdbc.Driver\");  \r\n      Connection con=DriverManager.getConnection(  \r\n          \"jdbc:mysql:\/\/localhost:3306\/test\",\"root\",\"\");  \r\n      \/\/here sonoo is database name, root is username and password  \r\n      Statement stmt=con.createStatement();\r\n\/\/\t\t\tstmt.executeUpdate(\"insert into emp VALUES (null, 'shailesh', 31, 'Nagpur')\");\r\n      ResultSet rs=stmt.executeQuery(\"select * from emp\");  \r\n      while(rs.next())\r\n        System.out.println(rs.getString(1)+\"  \"+rs.getString(2)+\"  \"+rs.getString(3)+\"  \"+rs.getString(4));  \r\n      con.close();  \r\n    } catch(Exception e){ System.out.println(e);}  \r\n\r\n    System.out.println(\"Hibernate connection established successfully...\");\r\n\r\n    Session session = new Configuration().configure(\"hibernate.cfg.xml\").buildSessionFactory().openSession();\r\n    Query query = session.createNativeQuery(\"select * from emp\");\r\n    List<Student[]> list = query.list();\r\n    System.out.println(list);\r\n\r\n    for(Object[] obj : list) {\r\n      Student std = new Student((Integer)obj[0], (String)obj[1], (Integer)obj[2], (String)obj[3]);\r\n      System.out.println(std);\r\n    }\t\t\r\n    \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\r\n    Query query2 = session.createNativeQuery(\"Select id, name, age, city from emp\");\r\n    query2.setResultTransformer(Criteria.ALIAS_TO_ENTITY_MAP);\r\n    List<Student> students = query2.list();\r\n    System.out.println(students);\r\n    session.close();\r\n    \/\/==============================\/\/\r\n    Session session2 = new Configuration().configure(\"database.cfg.xml\").buildSessionFactory().openSession();\r\n    List list2 = session2.createNativeQuery(\"select * from testdmarc\").list();\r\n    System.out.println(list2);\r\n  }\r\n}\r\n<\/pre>\n
 <\/p>\n
Reference:<\/p>\n
https:\/\/docs.jboss.org\/hibernate\/orm\/5.4\/userguide\/html_single\/Hibernate_User_Guide.html#sql<\/p>\n
https:\/\/tools.jboss.org\/downloads\/jbosstools\/2019-09\/4.13.0.Final.html#update_site<\/p>\n
https:\/\/www.tutorialspoint.com\/hibernate\/hibernate_examples.htm<\/p>\n
Hibernate Native SQL Query Example<\/a><\/p><\/blockquote>\n