Problem with running my first Hibernate App

[Varun Nayudu]

Hi guys,

I m trying to run my first web application using Hibernate/Tomcat/Oracle10g

My web application structure is quite simple
index.jsp -> servlet -> insert data into the database(Oracle10g)

The webApp struture is showed in the attachment

I have my hibernate.cfg.xml ,hibernate.hbm.xml, HibernateUtil, hibenrateListener in my WEB-INF -> classes

hibernate.cfg.xml

<?xml version='1.0' encoding='utf-8'?>  
<!DOCTYPE hibernate-configuration PUBLIC 
    -//Hibernate/Hibernate Configuration DTD//EN
    http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd>

<hibernate-configuration>
    <session-factory>
    
        <!-- Settings for a local HSQL (testing) database. -->
        <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
        <property name="connection.url">jdbc:oracle:thin:@localhost:1521:XE</property>
        <property name="connection.username">system</property>
        <property name="connection.password">admin</property>
    
        <!-- Print SQL to stdout. -->
        <property name="show_sql">true</property>
		<property name="dialect">org.hibernate.dialect.OracleDialect</property>

		<!-- Hibernate XML mapping files -->
        <mapping resource="Employee.hbm.xml"/>
    
        
    </session-factory>

</hibernate-configuration>

hibernate.hbm.xml

<?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.model.Employee" table="EMPLOYEE">
	   <id name="empId" type="int" column="EMPID" >
		   <generator class="assigned"/>
	   </id>

	  <property name="empName">
		 <column name="EMPNAME" />
	  </property>

 </class>
</hibernate-mapping>

HibernateUtil

import org.hibernate.*;
import org.hibernate.cfg.*;

public class HibernateUtil 
{

	private static final SessionFactory sessionFactory;

	static 
	{
		try 
		{
			// Create the SessionFactory
			sessionFactory = new Configuration().configure().buildSessionFactory();
		} catch (Throwable ex) 
		{
			// Make sure you log the exception, as it might be swallowed
			System.out.println("Initial SessionFactory creation failed: " + ex.getMessage());
			throw new ExceptionInInitializerError(ex);
		}
	}

	public static final ThreadLocal hibernateSession = new ThreadLocal();

	public static Session currentSession() 
	{
		Session s = (Session) hibernateSession.get();
		// Open a new Session, if this Thread has none yet
		if (s == null) 
		{
			s = sessionFactory.openSession();
			hibernateSession.set(s);
		}

	  return s;
	}

	public static void closeSession() 
	{
		Session s = (Session) hibernateSession.get();
		if (s != null)
		s.close();
		hibernateSession.set(null);
	}

}

hibenrateListener

import javax.servlet.*;
import org.hibernate.*;
import org.hibernate.cfg.*;
import net.sf.hibernate.util.*;


public class HibernateListener implements ServletContextListener {
 

    public void contextInitialized(ServletContextEvent event) {
       // HibernateUtil.getSessionFactory(); // Just call the static initializer of that class    
	   HibernateUtil.currentSession();
    }
 
    public void contextDestroyed(ServletContextEvent event) {
        //HibernateUtil.getSessionFactory().close(); // Free all resources
	   HibernateUtil.closeSession();
    }
}

Through the net i also came across a java class file to insert data into the EMPLOYEE table

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import com.model.*;

/**
 * @author Deepak Kumar
 *
 * http://www.roseindia.net
 * Hibernate example to inset data into Contact table
 */
public class FirstExample {
  public static void main(String[] args) {
    Session session = null;

    try{
      // This step will read hibernate.cfg.xml and prepare hibernate for use
		System.out.println("Inserting Record*"+ new Configuration().configure());//.buildSessionFactory();
      SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
		System.out.println("Inserting Record*");
      session = sessionFactory.openSession();

      //Create new instance of Contact and set values in it by reading them from form object
        System.out.println("Inserting Record");
        Employee employee = new Employee();
        employee.setEmpId(3);
        employee.setEmpName("Deepak");
        
        session.save(employee);
        System.out.println("Done");

    }catch(Exception e){
      System.out.println(e.getMessage());
    }finally{
		if(session != null){
      // Actual contact insertion will happen at this step
      session.flush();
      session.close();
		}
      }
    
  }
} 
 

the code compiles fine but gives an error

---------- Run Java Class ----------
log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Could not parse configuration: /hibernate.cfg.xml

Output completed (1 sec consumed)

Please tell me what is the problem .
regards

[Jesus Angeles]

Could not parse configuration: /hibernate.cfg.xml  

This means that you have done something wrong in the hibernate.cfg.xml.

Parsing error can happen if your xml is invalid, or if it doesnt follow the format (allowed xml declarations) for hibernate.cfg.xml.

[Souvik Dasgupta]

Hi Varun,

Please refer to the given Hibernate Mapping:

   <?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
    <hibernate-configuration>
        <session-factory>

            <!-- Settings for a local HSQL (testing) database. -->
           <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
           <property name="connection.url">jdbc:oracle:thin:@localhost:1521:XE</property>
           <property name="connection.username">system</property>
           <property name="connection.password">admin</property>

           <!-- Print SQL to stdout. -->
           <property name="show_sql">true</property>
           <property name="dialect">org.hibernate.dialect.OracleDialect</property>

           <!-- Hibernate XML mapping files -->
           <mapping resource="Employee.hbm.xml"/>


       </session-factory>

   </hibernate-configuration>

  The DTD definition should go inside quote and also xml encoding is in CAPITAL letters.This should solve the problem.

  

[Varun Nayudu]

Souvik Dasgupta wrote:

The DTD definition should go inside quote and also xml encoding is in CAPITAL letters.This should solve the problem.

After changing the code in the cfg.xml file I am still getting the same exception.
My new hibernate.cfg.xml

<?xml version='1.0' encoding='UTF-8'?>  
<!DOCTYPE hibernate-configuration PUBLIC 
    "-//Hibernate/Hibernate Configuration DTD//EN
    http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
    <session-factory>
    
        <!-- Settings for a local HSQL (testing) database. -->
        <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
        <property name="connection.url">jdbc:oracle:thin:@localhost:1521:XE</property>
        <property name="connection.username">system</property>
        <property name="connection.password">admin</property>
    
        <!-- Print SQL to stdout. -->
        <property name="show_sql">true</property>
		<property name="dialect">org.hibernate.dialect.OracleDialect</property>

		<!-- Hibernate XML mapping files -->
        <mapping resource="Employee.hbm.xml"/>
    
        
    </session-factory>

</hibernate-configuration>

Error Code
---------- Run Java Class ---------- log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment). log4j:WARN Please initialize the log4j system properly. Could not parse configuration: /hibernate.cfg.xml Output completed (0 sec consumed)

[Vijitha Kumara]

Use the exact declaration for the hibernate configuration xml as in here.