Hibernate Insert Error

Hi,
Iam getting follwoing Error when i try to insert a recod using hibernate
" Cannot insert explicit value for identity column in table 'tbRoutingRules' when IDENTITY_INSERT is set to OFF."

Code i am using is as follows

Mapping File for Routing Rule is

java Class for the mapping

public class RoutingRules {
	
	private int routingRuleID;
	private int teamID;
	private int transactionEventType;
	private int ordinal;
	private String field;
	private String operator;
	private String compareValue;
	private int routeToTeamID;
	/**
	 * @return the routingRuleID
	 */
	
	
	public int getRoutingRuleID() {
		return routingRuleID;
	}
	/**
	 * @param routingRuleID the routingRuleID to set
	 */
	public void setRoutingRuleID(int routingRuleID) {
		this.routingRuleID = routingRuleID;
	}
	/**
	 * @return the teamID
	 */
	public int getTeamID() {
		return teamID;
	}
	/**
	 * @param teamID the teamID to set
	 */
	public void setTeamID(int teamID) {
		this.teamID = teamID;
	}
	/**
	 * @return the transactionEventType
	 */
	public int getTransactionEventType() {
		return transactionEventType;
	}
	/**
	 * @param transactionEventType the transactionEventType to set
	 */
	public void setTransactionEventType(int transactionEventType) {
		this.transactionEventType = transactionEventType;
	}
	/**
	 * @return the ordinal
	 */
	public int getOrdinal() {
		return ordinal;
	}
	/**
	 * @param ordinal the ordinal to set
	 */
	public void setOrdinal(int ordinal) {
		this.ordinal = ordinal;
	}
	/**
	 * @return the field
	 */
	public String getField() {
		return field;
	}
	/**
	 * @param field the field to set
	 */
	public void setField(String field) {
		this.field = field;
	}
	/**
	 * @return the operator
	 */
	public String getOperator() {
		return operator;
	}
	/**
	 * @param operator the operator to set
	 */
	public void setOperator(String operator) {
		this.operator = operator;
	}
	/**
	 * @return the compareValue
	 */
	public String getCompareValue() {
		return compareValue;
	}
	/**
	 * @param compareValue the compareValue to set
	 */
	public void setCompareValue(String compareValue) {
		this.compareValue = compareValue;
	}
	/**
	 * @return the routeToTeamID
	 */
	public int getRouteToTeamID() {
		return routeToTeamID;
	}
	/**
	 * @param routeToTeamID the routeToTeamID to set
	 */
	public void setRouteToTeamID(int routeToTeamID) {
		this.routeToTeamID = routeToTeamID;
	}

}

Here routingRuleID is PrimaryKey and Auto Increment in table defination.
Please suggest me where exactly i am doing wrong

You have used a primative for your primary key. This means you are always trying to set it to 0 since primatives can't be null. Use the wrapper class instead.

Still getting same error after using wrapper class instead of premitive.
It got printed null for RoutingRuleID in console.Here is the updated code.

public class RoutingRules {
	
	private Integer routingRuleID;
	private int teamID;
	private int transactionEventType;
	private int ordinal;
	private String field;
	private String operator;
	private String compareValue;
	private int routeToTeamID;
	/**
	 * @return the routingRuleID
	 */
	
	
	public Integer getRoutingRuleID() {
		return routingRuleID;
	}
	/**
	 * @param routingRuleID the routingRuleID to set
	 */
	public void setRoutingRuleID(Integer routingRuleID) {
		this.routingRuleID = routingRuleID;
	}
	/**
	 * @return the teamID
	 */
	public int getTeamID() {
		return teamID;
	}
	/**
	 * @param teamID the teamID to set
	 */
	public void setTeamID(int teamID) {
		this.teamID = teamID;
	}
	/**
	 * @return the transactionEventType
	 */
	public int getTransactionEventType() {
		return transactionEventType;
	}
	/**
	 * @param transactionEventType the transactionEventType to set
	 */
	public void setTransactionEventType(int transactionEventType) {
		this.transactionEventType = transactionEventType;
	}
	/**
	 * @return the ordinal
	 */
	public int getOrdinal() {
		return ordinal;
	}
	/**
	 * @param ordinal the ordinal to set
	 */
	public void setOrdinal(int ordinal) {
		this.ordinal = ordinal;
	}
	/**
	 * @return the field
	 */
	public String getField() {
		return field;
	}
	/**
	 * @param field the field to set
	 */
	public void setField(String field) {
		this.field = field;
	}
	/**
	 * @return the operator
	 */
	public String getOperator() {
		return operator;
	}
	/**
	 * @param operator the operator to set
	 */
	public void setOperator(String operator) {
		this.operator = operator;
	}
	/**
	 * @return the compareValue
	 */
	public String getCompareValue() {
		return compareValue;
	}
	/**
	 * @param compareValue the compareValue to set
	 */
	public void setCompareValue(String compareValue) {
		this.compareValue = compareValue;
	}
	/**
	 * @return the routeToTeamID
	 */
	public int getRouteToTeamID() {
		return routeToTeamID;
	}
	/**
	 * @param routeToTeamID the routeToTeamID to set
	 */
	public void setRouteToTeamID(int routeToTeamID) {
		this.routeToTeamID = routeToTeamID;
	}

}

You have not defined any other identity columns in there? Have a look at your table definition.

Only One Identity column defined in the tables, i.e, RoutingRuleID.Through backend i am able to insert with the generated query , but i could not insert from application.

Try turning on show_sql to see what Hibernate is actually using. The error is fairly uncategorical so something must be setting the identity field. Hiebrnate itself should not be doing this I don't think.

Here is my code..

Following it got printed in the console...

RoutingRUle ID: null

Hibernate: insert into tbRoutingRules (TeamID, TransactionEventType, Ordinal, Field, Operator, CompareValue, RouteToTeamID, RoutingRuleID) values (?, ?, ?, ?, ?, ?, ?, ?)Nov 2, 2009 6:47:59 PM org.hibernate.util.JDBCExceptionReporter logExceptions
WARNING: SQL Error: 544, SQLState: S0001
Nov 2, 2009 6:47:59 PM org.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: Cannot insert explicit value for identity column in table 'tbRoutingRules' when IDENTITY_INSERT is set to OFF.
Nov 2, 2009 6:47:59 PM org.hibernate.event.def.AbstractFlushingEventListener performExecutions
SEVERE: Could not synchronize database state with session
org.hibernate.exception.SQLGrammarException: could not insert: [com.conagrafoods.merchstore.mappings.RoutingRules]

D'oh! Sorry should have spotted this straight away. You are using an increment generation strategy, not an identity generation strategy. So you are asking for Hibernate to generate a value for the primary key. You should change this to identity if that is what you want to use.

Thanks a lot, it works now...