Hibernate -org.hibernate.ObjectNotFoundException why?

[bikasit babu]

Hi All,

I am new to the Hibernate . I am trying some coding in it. Finally it ends up with exception which i am not able to resolve it so i need your help . i am pastin you with all the code please find out where i am making the mistake as i am unable to

The First thing in hibernate which i have make is a pojo class name Person.java file

Person.java

package com.bika;

public class Person
{
private int id;
private String firstName;
private String lastName;
private int age;
public int getId()
{
	return id;
}
public void setId(int 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 int getAge()
{
	return age;
}
public void setAge(int age)
{
	this.age = age;
} 

}

after that i have copied the hibernate.cfg.xml into my src folder
hibernate.cfg.xml

<?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> <!-- Database connection settings --> <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">root</property> <!-- JDBC connection pool (use the built-in) --> <property name="connection.pool_size">2</property> <!-- SQL dialect --> <property name="dialect">org.hibernate.dialect.OracleDialect</property> <!-- Enable Hibernate's current session context --> <property name="current_session_context_class">org.hibernate.context.ManagedSessionContext</property> <!-- Disable the second-level cache --> <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property> <!-- Echo all executed SQL to stdout --> <property name="show_sql">true</property> <!-- Drop and re-create the database schema on startup --> <property name="hbm2ddl.auto">create</property> <mapping resource="com/bika/Person.hbm.xml"/> </session-factory> </hibernate-configuration>
where i have changed all the necessary fields

then
i have copied the Person.hbm.xml file into my package com.bika
changes the necessary fields
Person.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 package="com.bika.Person"> <class name="com.bika.Person" table="PERSON"> <id name="id" column="PERSON_ID"> <generator class="native"/> </id> <property name="firstName"/> <property name="lastName"/> <property name="age"/> <!-- <set name="events" table="PERSON_EVENT"> <key column="PERSON_ID"/> <many-to-many column="EVENT_ID" class="Event"/> </set> <set name="emailAddresses" table="PERSON_EMAIL_ADDR"> <key column="PERSON_ID"/> <element type="string" column="EMAIL_ADDR"/> </set> --> </class> </hibernate-mapping>

afterdone it all i finally write the Manager.java class to insert or to do the ORM operation

color=red]Manager.java[ [/color]

package com.bika;

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

public class Manager
{

	public static void main(String[] args)
	{
		Person p1 = new Person();
		//Book b1 =new Book();
		p1.setId(1);
		p1.setFirstName("Bikasit");
		p1.setLastName("Babu");
		p1.setAge(22);
		/*b1.setAuthor("Bikas");
		b1.setTitle("bikas in bharath");
		b1.setPages(300);*/
		
		/*Book b2 = new Book();
		b2.setAuthor("RAmu");
		b2.setTitle("ramu ki chai");
		b2.setPages(450);
		
		Book b3 = new Book();
		b2.setAuthor("rahul");
		b2.setTitle("kid inside rahul");
		b2.setPages(450);*/
		
		Configuration c1 = new Configuration();
		c1.configure();
		
		SessionFactory sf = c1.buildSessionFactory();
		Session s1 = sf.openSession();
		s1.beginTransaction();
		/*s1.save(b1);
		s1.save(b2);
		s1.save(b3);*/
		s1.save(p1);
		
		s1.getTransaction().commit();
		s1.flush();
		s1.close();

	}

}

as it it is successfully inserted in db but while retrieving the data in console i have written another java class named Manager1.java but getting Exception
Manager1.java

package com.bika;

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

public class Manager1
{

	/**
	 * @param args
	 */
	public static void main(String[] args)
	{
	   Configuration c1 = new Configuration();
	   c1.configure();
	   SessionFactory se = c1.buildSessionFactory();
	   Session s1 = se.openSession();
	   Person b1 = (Person)s1.load(Person.class,1);
	    
	   System.out.println(".....Manager1...");
	   System.out.println( b1.getId());
	 System.out.println(b1.getFirstName());
	  System.out.println(b1.getLastName());
	  System.out.println(b1.getAge());
	  s1.flush();
	  s1.close();
	 //System.out.println(b1.getPages()); 
	}
}

and the exception as follows

SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
.....Manager1...
1
Hibernate: select person0_.PERSON_ID as PERSON1_0_0_, person0_.firstName as firstName0_0_, person0_.lastName as lastName0_0_, person0_.age as age0_0_ from PERSON person0_ where person0_.PERSON_ID=?
Exception in thread "main" org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.bika.Person#1]
at org.hibernate.impl.SessionFactoryImpl$2.handleEntityNotFound(SessionFactoryImpl.java:419)
at org.hibernate.proxy.AbstractLazyInitializer.checkTargetState(AbstractLazyInitializer.java:154)
at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:143)
at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:174)
at org.hibernate.proxy.pojo.javassist.JavassistLazyInitializer.invoke(JavassistLazyInitializer.java:190)
at com.bika.Person_$$_javassist_0.getFirstName(Person_$$_javassist_0.java)
at com.bika.Manager1.main(Manager1.java:23)



can any body please help whats the flaws i am going through
I will really greatful to you all

Thanks in advance

[Jaikiran Pai]

<id name="id" column="PERSON_ID"> <generator class="native"/> </id>

This configuration states that the id will auto generated. So I'm guessing that whatever Person object got inserted into the database has a different id than what you are querying it with via the session.load method. Have you looked into the DB to see what the row contents are?

[bikasit babu]

Hi jaikiran,

thanks for replying . Yeah i checked into db .so no row was there . But i tried it once again by inserting a row by commenting (p1.setId(1)) Id .as the row is inserted

In db it is showing as

EDIT PERSON_ID FIRSTNAME LASTNAME AGE
Edit 1 Bikasit Babu 22

but while retrieving again the same problem

same exception

[Jaikiran Pai]

Are you sure you are running that load program against the same database and table which contains those newly added rows? Can you also post the most recent stacktrace?

[bikasit babu]

Hi jaikiran,
Ya i am checking that one on Oracle db.
after one more run on insertion i got in console this

SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: insert into PERSON (firstName, lastName, age, PERSON_ID) values (?, ?, ?, ?)

and data has been reinserted

upon saving one more person object

i got the console as

SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: insert into PERSON (firstName, lastName, age, PERSON_ID) values (?, ?, ?, ?)
Hibernate: insert into PERSON (firstName, lastName, age, PERSON_ID) values (?, ?, ?, ?)

on retrieving(by running Manager1.java)

i got same output on consol

SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
.....Manager1...
1
Hibernate: select person0_.PERSON_ID as PERSON1_0_0_, person0_.firstName as firstName0_0_, person0_.lastName as lastName0_0_, person0_.age as age0_0_ from PERSON person0_ where person0_.PERSON_ID=?
Exception in thread "main" org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.bika.Person#1]
at org.hibernate.impl.SessionFactoryImpl$2.handleEntityNotFound(SessionFactoryImpl.java:419)
at org.hibernate.proxy.AbstractLazyInitializer.checkTargetState(AbstractLazyInitializer.java:154)
at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:143)
at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:174)
at org.hibernate.proxy.pojo.javassist.JavassistLazyInitializer.invoke(JavassistLazyInitializer.java:190)
at com.bika.Person_$$_javassist_0.getFirstName(Person_$$_javassist_0.java)
at com.bika.Manager1.main(Manager1.java:23)

One thing i didnt understand .while inserting the data is showing in database all the inserted data but upon running Manage1.java which is for retrieval if you recheck on db it shows no data on Person table
in db it shows as no record found on retrieval. whats going on actually

[bikasit babu]

Hi Jaikiran,
well on the reply what i have written. I don't know why the table has been drop or deleted from db while running Manager1.java .Please give me answer for that.

Finally i got the output on console by changing hibernate.hbm.cfg file
hibernate.cfg.xml
<!-- Drop and re-create the database schema on startup --> <property name="hbm2ddl.auto">update</property>


by changing itg ffrom create to update why ? can you explain

[Bill Gorder]

This property executes files containing SQL DML statements executed during the SessionFactory creation (So when the application starts in most cases, assuming a Singleton SessionFactory)

This property is not meant for production. It is a developer tool.

Validate: validate the schema, makes no changes to the database.
update: update the schema.
create: creates the schema, destroying previous data.
create-drop: drop the schema at the end of the session.