Hibernate Insert Error

[Gopi Kiran Manusani]

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

tx = session_hibernate.beginTransaction();
RoutingRules rules = new RoutingRules();
rules.setTeamID(Integer.parseInt(teamID));
rules.setTransactionEventType(1);
rules.setOrdinal(maxOrdinal+1);
rules.setField("-");
rules.setOperator("In");
rules.setCompareValue("");
rules.setRouteToTeamID(1);
session_hibernate.save(rules);
tx.commit();
session_hibernate.flush();

Mapping File for Routing Rule is

<id name="routingRuleID" type="java.lang.Integer" column="RoutingRuleID">
        	<generator class="increment"/>
    	</id>
    	
	    <property
	        name="teamID"
	        type="java.lang.Integer"
	        column="TeamID"
	    />
	    <property
	        name="transactionEventType"
	        type="java.lang.Integer"
	        column="TransactionEventType"
	    />
	    <property
	        name="ordinal"
	        type="java.lang.Integer"
	        column="Ordinal"
	    />
	    <property
	        name="field"
	        type="java.lang.String"
	        column="Field"
	    />
	    <property
	        name="operator"
	        type="java.lang.String"
	        column="Operator"
	    />
	    <property
	        name="compareValue"
	        type="java.lang.String"
	        column="CompareValue"
	    />
	    <property
	        name="routeToTeamID"
	        type="java.lang.Integer"
	        column="RouteToTeamID"
	    />
    </class>

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

[Paul Sturrock]

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.

[Gopi Kiran Manusani]

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;
	}
	
	

}

[Paul Sturrock]

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

[Gopi Kiran Manusani]

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.

[Paul Sturrock]

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.

[Gopi Kiran Manusani]

Here is my code..

tx = session_hibernate.beginTransaction();
RoutingRules rules = new RoutingRules();
rules.setTeamID(Integer.parseInt(teamID));
rules.setTransactionEventType(1);
rules.setOrdinal(maxOrdinal+1);
rules.setField("-");
rules.setOperator("In");
rules.setCompareValue("");
rules.setRouteToTeamID(1);
session_hibernate.save(rules);

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]

[Paul Sturrock]

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.

[Gopi Kiran Manusani]

Thanks a lot, it works now...