Error when inserting data in hibernate

[Maya Pillai]

When trying to save , I am getting the following exception.

org.hibernate.HibernateException: The database returned no natively generated identity value


Please help.

user.hbm.xml

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

<hibernate-mapping>
<class name="com.UserBean" table="user">
<id name="userId" column="user_id" type="int">
            <generator class="native"/>
        </id>
        <property name="userName" column="user_name"/>
        <property name="deptName" column="dept"/>
       

    
        
    </class>

</hibernate-mapping>

UserBean.


package com;

public class UserBean {
	int userId;
	String userName;
	String deptName;


	
	/**
	 * @return Returns the userName.
	 */
	public String getUserName() {
		return userName;
	}
	/**
	 * @param userName The userName to set.
	 */
	public void setUserName(String userName) {
		this.userName = userName;
	}
	
	/**
	 * @return Returns the deptName.
	 */
	public String getDeptName() {
		return deptName;
	}
	/**
	 * @param deptName The deptName to set.
	 */
	public void setDeptName(String deptName) {
		this.deptName = deptName;
	}
	
	public int getUserId() {
		return userId;
	}
	
	
	public void setUserId(int userId) {
		this.userId = userId;
	}
}

create table script

CREATE TABLE user ( 
    user_name	varchar(25) NOT NULL,
    dept     	varchar(25) NULL,
    user_id  	int(11) NOT NULL DEFAULT '0',
    PRIMARY KEY(user_id)
)
GO

[Christian Dillinger]

And we have to guess what database you use?

[Paul Sturrock]

I think what Christian is trying to suggest is you may be using a database that does not support a "native" key generation mechanism. From the Hibernate documentation:

selects identity, sequence or hilo depending upon the capabilities of the underlying database.

Either none of these mechanisms exist in the database you use or they are perhaps missconfigued?