data not persisted using hibernate spring integration

[Vikram Kohli]

Hi All,

I am trying to integrate vaadin with hibernate and spring. Data is getting persisted for the first time when I run my application. But second time when I run the application, data gets deleted from DB(mysql) table. Please help me to solve the issue.

Following is all related code:-

Domain class user

@Entity
@Table(name = "user")
public class User implements Serializable {
	/**
	 *
	 */
	private static final long serialVersionUID = 8496087166198616020L;
	private String userId;
	private String userName;
	private Integer age;
	private Boolean registered;

	@Id
	@GeneratedValue(generator = "system-uuid")
	@GenericGenerator(name = "system-uuid", strategy = "uuid")
	@Column(name = "userId")
	public String getUserId() {
		return userId;
	}

	public void setUserId(String userId) {
		this.userId = userId;
	}
	@Column(name = "userName", nullable=false)
	public String getUserName() {
		return userName;
	}

	public void setUserName(String userName) {
		this.userName = userName;
	}
	@Column(name = "age")
	public Integer getAge() {
		return age;
	}

	public void setAge(Integer age) {
		this.age = age;
	}
	@Column(name = "registered", nullable=false)
	public Boolean getRegistered() {
		return registered;
	}

	public void setRegistered(Boolean registered) {
		this.registered = registered;
	}
}

DaoImpl class

@Repository("userDao")
@Transactional
public class UserDaoImpl implements UserDao {
	private HibernateTemplate hibernateTemplate;

	@Autowired
	public void setSessionFactory(SessionFactory sessionFactory) {		
		hibernateTemplate = new HibernateTemplate(sessionFactory);
	}

	@Transactional
	public void saveUser(User user) {
		hibernateTemplate.saveOrUpdate(user);		
	}

	//@Transactional
	public void deleteUser(User user) {
		System.out.println("delete is called********************");
		hibernateTemplate.delete(user);

	}

	@SuppressWarnings("unchecked")
	public List<User> getAllUser(User user) {
		return (List<User>) hibernateTemplate.find("from "
				+ User.class.getName());
	}

	public User selectUserById(String userId) {
		return hibernateTemplate.get(User.class, userId);
	}

}

Spring config. file(applicationContext class)

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
	xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
	http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
	http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd
	">
	<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
		destroy-method="close">
		<property name="driverClass">
			<value>org.gjt.mm.mysql.Driver</value>
		</property>
		<property name="jdbcUrl">
			<value>jdbc:mysql://localhost:3306/HR</value>
		</property>
		<property name="user">
			<value>root</value>
		</property>
		<property name="password">
			<value>mysql123</value>
		</property>		
	</bean>
	 <context:component-scan base-package="com.example.vaadinspring" /> 
	<bean id="sessionFactory"
		class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
		<property name="dataSource">
			<ref bean="dataSource" />
		</property>
		<property name="packagesToScan" value="com.example.vaadinspring" />
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</prop>
				<prop key="hibernate.hbm2ddl.auto">create</prop>
				<prop key="hibernate.show_sql">true</prop>
			</props>
		</property>
	</bean>
	<bean id="transactionManager"
		class="org.springframework.orm.hibernate3.HibernateTransactionManager">
		<property name="sessionFactory">
			<ref bean="sessionFactory" />
		</property>
	</bean>
	<bean id="myUserDao" class="com.example.vaadinspring.UserDaoImpl" lazy-init="true"/>
	<!--  <bean id="VaadinspringApplication" class="com.example.vaadinspring.VaadinspringApplication">
   		<property name="bean" ref="myUserDao" />
	</bean>
	<bean id="UserTable" class="com.example.vaadinspring.UserTable" >
   		<property name="myUserListBean" ref="myUserDao" />
	</bean>-->
	<tx:annotation-driven />
</beans>

Vaadin main class

@Override
	public void init() {
		Window mainWindow = new Window("Vaadinspring Application");
		Label label = new Label("Hello Vaadin user");
		mainWindow.addComponent(label);
	    SpringContextHelper helper = new SpringContextHelper();
		UserDao bean = (UserDao) helper.getBean("myUserDao");
		User user = new User();  
		user.setAge(28);  
		user.setUserName("Vikram");  
		user.setRegistered(true);
		bean.saveUser(user); 
                               setMainWindow(mainWindow);
}

Please provide some input to solve this issue.I am using hibernate version 3.6.0 and Spring version 3.0.4 and MySQL as Database.

Regards,
Vikram

[Vikram Kohli]

hurray........I have found it..........

commenting out <prop key="hibernate.hbm2ddl.auto">create</prop> in spring config. have done the thing for me.

Vikram