Question about example in Hibernate Made Easy book - CrudRunner.retrieve()

[Cassy Thomas]

Never Mind!!! I had copied a hibernate.cfg.xml from the Hibernate distribution and the configuration file had the property hibernate.hbm2dll.auto set to create-drop. I commented out this property and it worked.

***************************************************

Hello, I'm working through the examples in the book, "Hibernate Made Easy". I'm having some odd behavior with the example.

Essentially, I have two simple classes outlined below. One is an Annotated Entity class and the other is a simply example that will allow you to create a User record and retrieve it. The create works, however the retrieve is deleting all the records from the corresponding table. I know the code in the book uses Hibernate 3.5, but I didn't think it would be this much of a difference. Can anyone help me understand why? I commented the line that is causing the problem in the second class below. I used debug through Eclipse to find out which statement was deleting all the records.

Many thanks,

This is my persisted object.

package com.examscam.model;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;

import org.hibernate.cfg.Configuration;//note AnnotationConfiguration has been deprecated
import org.hibernate.tool.hbm2ddl.SchemaExport;
import org.hibernate.SessionFactory;
import org.hibernate.Session;


@Entity
public class User implements java.io.Serializable {

	
	
	private Long id;
	private String password;
	
	@Id
	@GeneratedValue
	public Long getId() {
		return id;
	}
	
	public void setId(Long _id) {
		this.id = _id;
		
	}
	
	public String getPassword() {
		return password;
	}
	
	public void setPassword(String _password) {
		
		this.password = _password;
	}
	
	public static void main ( String[] args ) {
		
		
		Configuration cfg = new Configuration();
		cfg.addAnnotatedClass(User.class);
		cfg.configure();
		SessionFactory factory = cfg.buildSessionFactory();
		Session session = factory.getCurrentSession();
		session.beginTransaction();
		
		User u = new User();
		u.setPassword("addam");
		
		session.saveOrUpdate(u);
		session.getTransaction().commit();
		
		
		
		//new SchemaExport(cfg).create(true, true); drops table and recreates it
	}
}

This is the example class that executes attempts to create a copy of my object in the MySql database and retrieve it for display.

package com.examscam.model;

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

import com.examscam.model.User;

import java.util.*;

public class CrudRunner {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		CrudRunner.create();
		

		CrudRunner.retrieve();

	}

	public static void create() {

		Configuration config = new Configuration();

		config.addAnnotatedClass(User.class);

		SessionFactory factory = config.configure().buildSessionFactory();
		Session session = factory.getCurrentSession();
		session.beginTransaction();

		User user = new User();
		user.setPassword("abc1echo823");
		session.save(user);
		// session.saveOrUpdate(user);
		session.getTransaction().commit();

	}

	public static void retrieve() {

		List allUsers;

		Configuration config = new Configuration(); //Annotation Configuration is deprecated; this is the preferred configuration 
		config.addAnnotatedClass(User.class);
		SessionFactory factory;
		factory = config.configure().buildSessionFactory();// this line deletes all records in the user table

		Session session = factory.getCurrentSession();
		session.beginTransaction();

		Query queryResult = session.createQuery("from User");
		allUsers = queryResult.list();

		System.out.println("all users size: " + allUsers.size());

		for (int i = 0; i < allUsers.size(); i++) {

			User u = (User) allUsers.get(i);
			System.out.println(u.getPassword());
		}

		session.getTransaction().commit();
	}

}

I am using Hibernate 3.6.Final