Problem in Running Hibernate Sample application

[DhanunjayReddy Valluru]

Code tag is added. Could you please look into this. Sorry for inconvenience.

HI experts,

I am trying to run the sample hibernate application from www.roseindia.com, but the session.save(object) does not insert the object in the oracle DB.Am not getting any errors or exceptions here is a snippet of the code :



Example given in roseindia:
=================

package roseindia.tutorial.hibernate;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;


/**
 * @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
			SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
			 session =sessionFactory.openSession();
				//Create new instance of Contact and set values in it by reading them from form object
			 	System.out.println("Inserting Record");
				Contact contact = new Contact();
				contact.setId(6);
				contact.setFirstName("Deepak");
				contact.setLastName("Kumar");
				contact.setEmail("[e-mail]");
				session.save(contact);
				
				System.out.println("Done");
		}catch(Exception e){
			System.out.println(e.getMessage());
		}finally{
			// Actual contact insertion will happen at this step
			session.flush();			
			session.close();
			System.out.println("test");

			}
		
	}
}

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>
      <property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
      <property name="hibernate.connection.url">jdbc:oracle:thin:@localhost:1521:ORACLE</property>
      <property name="hibernate.connection.username">system</property>
      <property name="hibernate.connection.password">oracle</property>
      <property name="hibernate.connection.pool_size">10</property>
      <property name="show_sql">true</property>
 	  <property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
     
      <!-- Mapping files -->
      <mapping resource="contact.hbm.xml"/>
</session-factory>
</hibernate-configuration>

contact.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="roseindia.tutorial.hibernate.Contact" table="CONTACT">
	   <id name="id" type="long" column="ID" >
	   <generator class="assigned"/>
	  </id>

	  <property name="firstName">
		 <column name="FIRSTNAME" />
	  </property>
	  <property name="lastName">
		<column name="LASTNAME"/>
	  </property>
	  <property name="email">
		<column name="EMAIL"/>
	  </property>
   </class>
</hibernate-mapping>

Please help me out to run this application.
Database: oracle10g
JDBC driver version is 10.2.0.1.0


--Regards
Dhanunjay Reddy V

[David Newton]

Please UseCodeTags when posting code or configuration. Unformatted code and configuration is very difficult to read. You can edit your post to include them by using the button.

[DhanunjayReddy Valluru]

Hi All,

Sample hibernate example in roseIndia is running with out any errors but not saving into the database. Its because they are not starting the transaction. Transacton object you have to get it from session. Once you persist the object, please commit the transaction. That will solve the problem. See the modified code below.

package roseindia.tutorial.hibernate;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;


/**
 * @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
			SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
			 session =sessionFactory.openSession();
			// Added by Dhanunjay Reddy V	
			   Transaction tx = null;
			   tx =  session.beginTransaction();
			   
			 //Create new instance of Contact and set values in it by reading them from form object
			 	System.out.println("Inserting Record");
				Contact contact = new Contact();
				contact.setId(6);
				contact.setFirstName("Deepak");
				contact.setLastName("Kumar");
				contact.setEmail("[e-mail]");
				session.save(contact);
			  //Added by Dhanunjay Reddy V
				tx.commit();
				
				System.out.println("Done");
		}catch(Exception e){
			System.out.println(e.getMessage());
		}finally{
			// Actual contact insertion will happen at this step
			session.flush();			
			session.close();			

			}
		
	}
}

Thanks for all who has looked into this issue.

--Regards
Dhanunjay Reddy V