Hibernate Properties File Reading

Click here to download eclipse supported ZIP file

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <!-- <session-factory> <property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property> hibernate word is optional <property name="connection.url">jdbc:oracle:thin:@localhost:1521:ORCL</property> <property name="hibernate.connection.username">kcv</property> <property name="hibernate.connection.password">kcv</property> <property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property> <property name="show_sql">true</property> <mapping resource="Employee.hbm.xml"/> </session-factory> --> <session-factory> <property name="hibernate.current_session_context_class">thread</property> <property name="hbm2ddl.auto">create</property> <property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property> <property name="connection.url">jdbc:postgresql://localhost:5432/hibernate</property> <property name="connection.username">postgres</property> <property name="connection.password">password</property> <property name="connection.driver_class">org.postgresql.Driver</property> <property name="show_sql">true</property> <property name="format_sql">true</property> <property name="use_sql_comments">true</property> <mapping resource="EmployeeBean.hbm.xml" /> </session-factory> </hibernate-configuration>

<?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping> <class name="com.cv.hibernate.props.model.EmployeeBean" table="Employee_prop"> <id name="id" type="java.lang.Long"> <column name="EID" length="8" /> <generator class="assigned"></generator> </id> <property name="firstName" type="java.lang.String"> <column name="FIRSTNAME" length="29" not-null="true" /> </property> <property name="lastName" type="java.lang.String"> <column name="LASTNAME" length="29" not-null="true" /> </property> <property name="email" type="java.lang.String"> <column name="EMAIL" length="39" not-null="true" /> </property> </class> </hibernate-mapping>

package com.cv.hibernate.props.model; /**  * @author Chandra Vardhan  */ public class EmployeeBean {   private long id;   private String firstName;   private String lastName;   private String email;   public long getId() {     return id;   }   public void setId(long id) {     this.id = id;   }   public String getFirstName() {     return firstName;   }   public void setFirstName(String firstName) {     this.firstName = firstName;   }   public String getLastName() {     return lastName;   }   public void setLastName(String lastName) {     this.lastName = lastName;   }   public String getEmail() {     return email;   }   public void setEmail(String email) {     this.email = email;   } }

package com.cv.hibernate.props; import org.apache.log4j.Logger; import org.hibernate.Session; import org.hibernate.Transaction; import com.cv.hibernate.props.model.EmployeeBean; import com.cv.hibernate.props.util.HibernateUtil; /**  * @author Chandra Vardhan  */ public class SaveORUpdate {   private final static Logger logger = Logger.getLogger(SaveORUpdate.class);   public static void main(String[] args) throws Exception {     Session session = HibernateUtil.getSession();     EmployeeBean eb = new EmployeeBean();     eb.setId(new Long(101));     eb.setFirstName("chandra");     eb.setLastName("vardhan");     eb.setEmail("meetkodam@gmail.com");     session.beginTransaction();     session.saveOrUpdate(eb);     logger.info("saved successfully...");     session.getTransaction().commit();     HibernateUtil.closeSession();   } }

package com.cv.hibernate.props.util; import java.sql.Connection; import java.util.Properties; import org.apache.log4j.Logger; import org.hibernate.HibernateException; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.boot.registry.StandardServiceRegistryBuilder; import org.hibernate.cfg.Configuration; import org.hibernate.internal.SessionImpl; /**  * Configures and provides access to Hibernate sessions, tied to the current  * thread of execution. Follows the Thread Local Session pattern, see  * {@link http://hibernate.org/42.html }.  */ public class HibernateUtil {   private final static Logger logger = Logger.getLogger(HibernateUtil.class);   /**    * Location of hibernate.cfg.xml file. Location should be on the classpath    * as Hibernate uses #resourceAsStream style lookup for its configuration    * file. The default classpath location of the hibernate config file is in    * the default package. Use #setConfigFile() to update the location of the    * configuration file for the current session.    */   private static String CONFIG_FILE_LOCATION = "/hibernate.cfg.xml";   private static final ThreadLocal<Session> threadLocal = new ThreadLocal<Session>();   private static Configuration configuration = new Configuration();   private static SessionFactory sessionFactory;   static {     try {       Properties dbConnectionProperties = new Properties();       try {         dbConnectionProperties             .load(ClassLoader.getSystemClassLoader().getResourceAsStream("hibernate.properties"));       } catch (Exception e) {         e.printStackTrace();       }       configuration = configuration.configure(CONFIG_FILE_LOCATION).addProperties(dbConnectionProperties);       StandardServiceRegistryBuilder builder = new StandardServiceRegistryBuilder()           .applySettings(configuration.getProperties());       sessionFactory = configuration.buildSessionFactory(builder.build());       logger.info("%%%% Connection successful %%%%");     } catch (Exception e) {       System.err.println("## Error Creating SessionFactory ##");       e.printStackTrace();     }   }   private HibernateUtil() {   }   /**    * Returns the ThreadLocal Session instance. Lazy initialize the    * <code>SessionFactory</code> if needed.    *    * @return Session    * @throws HibernateException    */   public static Session getSession() throws HibernateException {     Session session = (Session) threadLocal.get();     if (session == null || !session.isOpen()) {       if (sessionFactory == null) {         rebuildSessionFactory();       }       session = (sessionFactory != null) ? sessionFactory.openSession() : null;       threadLocal.set(session);     }     return session;   }   /**    * Rebuild hibernate session factory    *    */   public static void rebuildSessionFactory() {     try {       configuration = configuration.configure(CONFIG_FILE_LOCATION);       StandardServiceRegistryBuilder builder = new StandardServiceRegistryBuilder()           .applySettings(configuration.getProperties());       sessionFactory = configuration.buildSessionFactory(builder.build());       logger.info("%%%% Connection successful %%%%");     } catch (Exception e) {       System.err.println("Error Creating SessionFactory");       e.printStackTrace();     }   }   /**    * Close the single hibernate session instance.    *    * @throws HibernateException    */   public static void closeSession() throws HibernateException {     Session session = (Session) threadLocal.get();     threadLocal.set(null);     if (session != null) {       session.close();       System.exit(0);     }   }   /**    * return session factory    *    */   public static SessionFactory getSessionFactory() {     return sessionFactory;   }   /**    * return hibernate configuration    *    */   public static Configuration getConfiguration() {     return configuration;   }   public static Connection getConnection() {     Connection connection = null;     try {       Session session = getSession();       if (session != null) {         SessionImpl sessionimpl = (SessionImpl) session;         connection = sessionimpl.connection();       }     } catch (Exception e) {       e.printStackTrace();       System.err.println(e.getClass().getName() + ": " + e.getMessage());       System.exit(0);     }     return connection;   } }

#By default enabling Console appender # Root logger option log4j.rootLogger=INFO, stdout # Redirect log messages to console log4j.appender.stdout=org.apache.log4j.ConsoleAppender log4j.appender.stdout.Target=System.out log4j.appender.stdout.layout=org.apache.log4j.PatternLayout log4j.appender.stdout.layout.ConversionPattern=%-5p [%c]:%L -->> %m%n # Redirect log messages to a log file #log4j.appender.file=org.apache.log4j.RollingFileAppender #log4j.appender.file.File=C:\\servlet-application.log #log4j.appender.file.MaxFileSize=5MB #log4j.appender.file.MaxBackupIndex=10 #log4j.appender.file.layout=org.apache.log4j.PatternLayout #log4j.appender.file.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %-5p %c{1}:%L - %m%n

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.cv.hibernate.props</groupId> <artifactId>hibernatePropertiesFileRead</artifactId> <version>1.0</version> <dependencies> <dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-entitymanager</artifactId> <version>4.3.5.Final</version> </dependency> <dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-c3p0</artifactId> <version>4.3.5.Final</version> </dependency> <dependency> <artifactId>hibernate-core</artifactId> <groupId>org.hibernate</groupId> <version>4.3.5.Final</version> </dependency> <dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-validator</artifactId> <version>4.2.0.Final</version> </dependency> <dependency> <groupId>org.hibernate.common</groupId> <artifactId>hibernate-commons-annotations</artifactId> <version>4.0.4.Final</version> </dependency> <dependency> <groupId>org.hibernate.javax.persistence</groupId> <artifactId>hibernate-jpa-2.0-api</artifactId> <version>1.0.1.Final</version> </dependency> <dependency> <groupId>javax.validation</groupId> <artifactId>validation-api</artifactId> <version>1.0.0.GA</version> provided </dependency> <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-api</artifactId> <version>1.6.4</version> </dependency> <dependency> <groupId>org.jboss.logging</groupId> <artifactId>jboss-logging</artifactId> <version>3.1.0.CR2</version> </dependency> <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-log4j12</artifactId> <version>1.6.4</version> </dependency> <dependency> <groupId>postgresql</groupId> <artifactId>postgresql</artifactId> <version>9.1-901.jdbc4</version> </dependency> <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-simple</artifactId> <version>1.7.5</version> </dependency> </dependencies> <build> <plugins> <plugin> <artifactId>maven-compiler-plugin</artifactId> <version>3.3</version> <configuration> <source>1.8</source> <target>1.8</target> </configuration> </plugin> </plugins> </build> </project>

Non HQL

Click here to download eclipse supported ZIP file

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <!-- <session-factory> <property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property> hibernate word is optional <property name="connection.url">jdbc:oracle:thin:@localhost:1521:ORCL</property> <property name="hibernate.connection.username">kcv</property> <property name="hibernate.connection.password">kcv</property> <property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property> <property name="show_sql">true</property> <mapping resource="Employee.hbm.xml"/> </session-factory> --> <session-factory> <property name="hibernate.current_session_context_class">thread</property> <property name="hbm2ddl.auto">create</property> <property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property> <property name="connection.url">jdbc:postgresql://localhost:5432/hibernate</property> <property name="connection.username">postgres</property> <property name="connection.password">password</property> <property name="connection.driver_class">org.postgresql.Driver</property> <property name="show_sql">true</property> <property name="format_sql">true</property> <property name="use_sql_comments">true</property> <mapping resource="EmployeeBean2.hbm.xml"/> </session-factory> </hibernate-configuration>

<?xml version="1.0" encoding="utf-8"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping package="com.cv.hibernate.sql.model"> <class name="EmployeeBean2" table="Employee_SQL2"> <id name="id" type="long"> <column name="EID" precision="10" scale="0" /> <!-- <generator class="assigned" /> --> </id> <property name="firstName" type="string"> <column name="FIRSTNAME" length="29" /> </property> <property name="lastName" type="string"> <column name="LASTNAME" length="29" /> </property> <property name="email" type="string"> <column name="EMAIL" length="39" /> </property> </class> </hibernate-mapping>

package com.cv.hibernate.sql.model; /**  * @author Chandra Vardhan  */ public class EmployeeBean {   private long id;   private String firstName;   private String lastName;   private String email;   public long getId() {     return id;   }   public void setId(long id) {     this.id = id;   }   public String getFirstName() {     return firstName;   }   public void setFirstName(String firstName) {     this.firstName = firstName;   }   public String getLastName() {     return lastName;   }   public void setLastName(String lastName) {     this.lastName = lastName;   }   public String getEmail() {     return email;   }   public void setEmail(String email) {     this.email = email;   } }

package com.cv.hibernate.sql.model; /**  * @author Chandra Vardhan  */ public class EmployeeBean2 {   private long id;   private String firstName;   private String lastName;   private String email;   public long getId() {     return id;   }   public void setId(long id) {     this.id = id;   }   public String getFirstName() {     return firstName;   }   public void setFirstName(String firstName) {     this.firstName = firstName;   }   public String getLastName() {     return lastName;   }   public void setLastName(String lastName) {     this.lastName = lastName;   }   public String getEmail() {     return email;   }   public void setEmail(String email) {     this.email = email;   } }

package com.cv.hibernate.sql; import org.apache.log4j.Logger; import org.hibernate.Query; import org.hibernate.Session; import com.cv.hibernate.sql.util.HibernateUtil; /**  * @author Chandra Vardhan  */ public class NativeSQLInsert {   private final static Logger logger = Logger       .getLogger(NativeSQLInsert.class);   public static void main(String[] args) {     Session session = HibernateUtil.getSession();     session.beginTransaction();     Query q1 = session         .createSQLQuery("insert into EmployeeBean_SQL values (?,?,?,?)");     q1.setInteger(0, 103);     q1.setString(1, "chote");     q1.setString(2, "vardhan");     q1.setString(3, "meetkodam@gmail.com");     int res = q1.executeUpdate();     logger.info("no.of records effected is : " + res);     session.getTransaction().commit();     session.close();   } }

package com.cv.hibernate.sql; import org.apache.log4j.Logger; import org.hibernate.Query; import org.hibernate.Session; import com.cv.hibernate.sql.util.HibernateUtil; /**  * @author Chandra Vardhan  */ public class NativeSQLInsertBySelect {   private final static Logger logger = Logger.getLogger(NativeSQLInsertBySelect.class);   public static void main(String[] args) {     HibernateUtil.saveOrUpdate();     Session session = HibernateUtil.getSession();     session.beginTransaction();     Query q1 = session.createSQLQuery(         "insert into employee_sql2(eid,firstname,lastname,email) select eb.eid,eb.firstname,eb.lastname,eb.email from employee_sql as eb where eb.eid=:p1");     q1.setInteger("p1", 101);     int res = q1.executeUpdate();     logger.info("No.of records effected is : " + res);     session.getTransaction().commit();     HibernateUtil.closeSession();   } }

package com.cv.hibernate.sql.util; import org.apache.log4j.Logger; import org.hibernate.HibernateException; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.boot.registry.StandardServiceRegistryBuilder; import org.hibernate.cfg.Configuration; import com.cv.hibernate.sql.model.EmployeeBean; import com.cv.hibernate.sql.model.EmployeeBean2; /**  * @author Chandra Vardhan  */ /**  * Configures and provides access to Hibernate sessions, tied to the current  * thread of execution. Follows the Thread Local Session pattern, see  * {@link http://hibernate.org/42.html }.  */ public class HibernateUtil {   private final static Logger logger = Logger.getLogger(HibernateUtil.class);   /**    * Location of hibernate.cfg.xml file. Location should be on the classpath    * as Hibernate uses #resourceAsStream style lookup for its configuration    * file. The default classpath location of the hibernate config file is in    * the default package. Use #setConfigFile() to update the location of the    * configuration file for the current session.    */   private static String CONFIG_FILE_LOCATION = "hibernate.cfg.xml";   private static final ThreadLocal<Session> threadLocal = new ThreadLocal<Session>();   private static Configuration configuration = new Configuration();   private static SessionFactory sessionFactory;   static {     try {       configuration = configuration.configure(CONFIG_FILE_LOCATION);       StandardServiceRegistryBuilder builder = new StandardServiceRegistryBuilder()           .applySettings(configuration.getProperties());       sessionFactory = configuration.buildSessionFactory(builder.build());       logger.info("%%%% Connection successful %%%%");     } catch (Exception e) {       logger.error("%%%% Error Creating SessionFactory %%%%");       e.printStackTrace();     }   }   private HibernateUtil() {   }   /**    * Returns the ThreadLocal Session instance. Lazy initialize the    * <code>SessionFactory</code> if needed.    *     * @return Session    * @throws HibernateException    */   public static Session getSession() throws HibernateException {     Session session = (Session) threadLocal.get();     if (session == null || !session.isOpen()) {       if (sessionFactory == null) {         rebuildSessionFactory();       }       session = (sessionFactory != null) ? sessionFactory.openSession()           : null;       threadLocal.set(session);     }     return session;   }   /**    * Rebuild hibernate session factory    *     */   public static void rebuildSessionFactory() {     try {       configuration = configuration.configure(CONFIG_FILE_LOCATION);       StandardServiceRegistryBuilder builder = new StandardServiceRegistryBuilder()           .applySettings(configuration.getProperties());       sessionFactory = configuration.buildSessionFactory(builder.build());       logger.info("%%%% Connection successful %%%%");     } catch (Exception e) {       logger.error("%%%% Error Creating SessionFactory %%%%");       e.printStackTrace();     }   }   /**    * Close the single hibernate session instance.    *     * @throws HibernateException    */   public static void closeSession() throws HibernateException {     Session session = (Session) threadLocal.get();     threadLocal.set(null);     if (session != null) {       session.close();       System.exit(0);     }   }   /**    * return session factory    *     */   public static SessionFactory getSessionFactory() {     return sessionFactory;   }   /**    * return hibernate configuration    *     */   public static Configuration getConfiguration() {     return configuration;   }   public static void saveOrUpdate() {     Session session = getSession();     for (int i = 100; i <= 102; i++) {       EmployeeBean eb = new EmployeeBean();       eb.setId(new Long(i));       eb.setFirstName("chandra");       eb.setLastName("vardhan");       eb.setEmail("meetkodam@gmail.com");       session.beginTransaction();       session.saveOrUpdate(eb);       session.getTransaction().commit();     }     logger.info("Saved successful...");     session.close();   } }

#By default enabling Console appender # Root logger option log4j.rootLogger=INFO, stdout # Redirect log messages to console log4j.appender.stdout=org.apache.log4j.ConsoleAppender log4j.appender.stdout.Target=System.out log4j.appender.stdout.layout=org.apache.log4j.PatternLayout log4j.appender.stdout.layout.ConversionPattern=%-5p [%c]:%L -->> %m%n # Redirect log messages to a log file #log4j.appender.file=org.apache.log4j.RollingFileAppender #log4j.appender.file.File=C:\\servlet-application.log #log4j.appender.file.MaxFileSize=5MB #log4j.appender.file.MaxBackupIndex=10 #log4j.appender.file.layout=org.apache.log4j.PatternLayout #log4j.appender.file.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %-5p %c{1}:%L - %m%n

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.cv.sql</groupId> <artifactId>NON_HQL</artifactId> <version>1.0</version> <dependencies> <dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-entitymanager</artifactId> <version>4.3.5.Final</version> </dependency> <dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-c3p0</artifactId> <version>4.3.5.Final</version> </dependency> <dependency> <artifactId>hibernate-core</artifactId> <groupId>org.hibernate</groupId> <version>4.3.5.Final</version> </dependency> <dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-validator</artifactId> <version>4.2.0.Final</version> </dependency> <dependency> <groupId>org.hibernate.common</groupId> <artifactId>hibernate-commons-annotations</artifactId> <version>4.0.4.Final</version> </dependency> <dependency> <groupId>org.hibernate.javax.persistence</groupId> <artifactId>hibernate-jpa-2.0-api</artifactId> <version>1.0.1.Final</version> </dependency> <dependency> <groupId>javax.validation</groupId> <artifactId>validation-api</artifactId> <version>1.0.0.GA</version> provided </dependency> <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-api</artifactId> <version>1.6.4</version> </dependency> <dependency> <groupId>org.jboss.logging</groupId> <artifactId>jboss-logging</artifactId> <version>3.1.0.CR2</version> </dependency> <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-log4j12</artifactId> <version>1.6.4</version> </dependency> <dependency> <groupId>postgresql</groupId> <artifactId>postgresql</artifactId> <version>9.1-901.jdbc4</version> </dependency> <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-simple</artifactId> <version>1.7.5</version> </dependency> </dependencies> <build> <plugins> <plugin> <artifactId>maven-compiler-plugin</artifactId> <version>3.3</version> <configuration> <source>1.8</source> <target>1.8</target> </configuration> </plugin> </plugins> </build> </project>