Column 'NEXT_HI' is either not in any table in the FROM list or appears

[silamala ramesh babu]

import java.sql.Timestamp;

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.OneToOne;
import javax.persistence.PrimaryKeyJoinColumn;
import javax.persistence.Table;

import org.hibernate.annotations.GenericGenerator;
import org.hibernate.annotations.Parameter;

@Entity
@Table(name="EMP_HDR",schema="APP")
public class Associate {

	private int empId;
	private String empName;
	private String password;
	private Integer createdBy;
	private Timestamp createdOn;
	private Integer modifiedBy;
	private Timestamp modifiedOn;
	private AssociateContacts associateContacts;
	
	
	/**
	 * @return the empId
	 */
	@Id
	@Column(name="Emp_Id")
	public int getEmpId() {
		return empId;
	}
	/**
	 * @param empId the empId to set
	 */
	public void setEmpId(int empId) {
		this.empId = empId;
	}
	
	
	@Column(name="Emp_Name")
	public String getEmpName() {
		return empName;
	}
	
	public void setEmpName(String empName) {
		this.empName = empName;
	}
	
	@Column(name="Password")
	public void setPassword(String password) {
		this.password = password;
	}
	public String getPassword() {
		return password;
	}
	/**
	 * @return the createdBy
	 */
	@Column(name="Created_By")
	public Integer getCreatedBy() {
		return createdBy;
	}
	/**
	 * @param createdBy the createdBy to set
	 */
	public void setCreatedBy(Integer createdBy) {
		this.createdBy = createdBy;
	}
	/**
	 * @return the createdOn
	 */
	@Column(name="Created_On")
	public Timestamp getCreatedOn() {
		return createdOn;
	}
	/**
	 * @param createdOn the createdOn to set
	 */
	public void setCreatedOn(Timestamp createdOn) {
		this.createdOn = createdOn;
	}
	/**
	 * @return the modifiedBy
	 */
	@Column(name="Modified_By")
	public Integer getModifiedBy() {
		return modifiedBy;
	}
	/**
	 * @param modifiedBy the modifiedBy to set
	 */
	public void setModifiedBy(Integer modifiedBy) {
		this.modifiedBy = modifiedBy;
	}
	/**
	 * @return the modifiedOn
	 */
	@Column(name="Modified_On")
	public Timestamp getModifiedOn() {
		return modifiedOn;
	}
	/**
	 * @param modifiedOn the modifiedOn to set
	 */
	public void setModifiedOn(Timestamp modifiedOn) {
		this.modifiedOn = modifiedOn;
	}
	
	
	
	
	@OneToOne(cascade = CascadeType.ALL, optional=false, orphanRemoval=true)
	@JoinColumn(name="Contact_Id")
	public AssociateContacts getAssociateContacts() {
		return associateContacts;
	}
	public void setAssociateContacts(AssociateContacts associateContacts) {
		this.associateContacts = associateContacts;
	}
	
	
}


/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

package com.tcs.rdt.associate.domain;

import java.sql.Timestamp;

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.OneToOne;
import javax.persistence.PrimaryKeyJoinColumn;
import javax.persistence.SequenceGenerator;
import javax.persistence.Table;

import org.hibernate.annotations.GenericGenerator;
import org.hibernate.annotations.Parameter;

@Entity
@Table(name="CONTACT_DTL",schema="APP")
public class AssociateContacts {

	private int contactId;
	private String team;
	private String location;
	private String tcsMail;
	private String jpmcMail;
	private Long mobileNumber;
	private Long extensionNumber;
	private String standardId;
	private String mainframeId;
	private Long vpnTokenId;
	private Timestamp vpnTokenExpiryDate;
	private Timestamp sidTerminateDate;
	private Integer tokenCustody;
	private String remarks;
	private Integer createdBy;
	private Timestamp createdOn;
	private Integer modifiedBy;
	private Timestamp modifiedOn;

	
	//private Associate associate;
	
	/**
	 * @return the empId
	 */
	@Id	
	@GeneratedValue
	@Column(name="Contact_Id")	
	public int getContactId() {
		return contactId;
	}
	/**
	 * @param empId the empId to set
	 */
	public void setContactId(int contactId) {
		this.contactId = contactId;
	}
	
	    
	/**
	 * @return the team
	 */
	@Column(name="Team")
	public String getTeam() {
		return team;
	}
	/**
	 * @param team the team to set
	 */
	public void setTeam(String team) {
		this.team = team;
	}
	/**
	 * @return the location
	 */
	@Column(name="Location")
	public String getLocation() {
		return location;
	}
	/**
	 * @param location the location to set
	 */
	public void setLocation(String location) {
		this.location = location;
	}
	/**
	 * @return the tcsMail
	 */
	@Column(name="TCS_Mail")
	public String getTcsMail() {
		return tcsMail;
	}
	/**
	 * @param tcsMail the tcsMail to set
	 */
	public void setTcsMail(String tcsMail) {
		this.tcsMail = tcsMail;
	}
	/**
	 * @return the jpmcMail
	 */
	@Column(name="JPMC_Mail")
	public String getJpmcMail() {
		return jpmcMail;
	}
	/**
	 * @param jpmcMail the jpmcMail to set
	 */
	public void setJpmcMail(String jpmcMail) {
		this.jpmcMail = jpmcMail;
	}
	/**
	 * @return the mobileNumber
	 */
	@Column(name="Mobile_No")
	public Long getMobileNumber() {
		return mobileNumber;
	}
	/**
	 * @param mobileNumber the mobileNumber to set
	 */
	public void setMobileNumber(Long mobileNumber) {
		this.mobileNumber = mobileNumber;
	}
	/**
	 * @return the extensionNumber
	 */
	@Column(name="Ext_No")
	public Long getExtensionNumber() {
		return extensionNumber;
	}
	/**
	 * @param extensionNumber the extensionNumber to set
	 */
	public void setExtensionNumber(Long extensionNumber) {
		this.extensionNumber = extensionNumber;
	}
	/**
	 * @return the standardId
	 */
	@Column(name="Standard_Id")
	public String getStandardId() {
		return standardId;
	}
	/**
	 * @param standardId the standardId to set
	 */
	public void setStandardId(String standardId) {
		this.standardId = standardId;
	}
	/**
	 * @return the mainframeId
	 */
	@Column(name="Mainframe_Id")
	public String getMainframeId() {
		return mainframeId;
	}
	/**
	 * @param mainframeId the mainframeId to set
	 */
	public void setMainframeId(String mainframeId) {
		this.mainframeId = mainframeId;
	}
	/**
	 * @return the vpnTokenId
	 */
	@Column(name="VPN_Token_Id")
	public Long getVpnTokenId() {
		return vpnTokenId;
	}
	/**
	 * @param vpnTokenId the vpnTokenId to set
	 */
	public void setVpnTokenId(Long vpnTokenId) {
		this.vpnTokenId = vpnTokenId;
	}
	/**
	 * @return the vpnTokenExpiryDate
	 */
	@Column(name="VPN_Token_Expiry_Date")
	public Timestamp getVpnTokenExpiryDate() {
		return vpnTokenExpiryDate;
	}
	/**
	 * @param vpnTokenExpiryDate the vpnTokenExpiryDate to set
	 */
	public void setVpnTokenExpiryDate(Timestamp vpnTokenExpiryDate) {
		this.vpnTokenExpiryDate = vpnTokenExpiryDate;
	}
	/**
	 * @return the sidTerminateDate
	 */
	@Column(name="SID_Termination_Date")
	public Timestamp getSidTerminateDate() {
		return sidTerminateDate;
	}
	/**
	 * @param sidTerminateDate the sidTerminateDate to set
	 */
	public void setSidTerminateDate(Timestamp sidTerminateDate) {
		this.sidTerminateDate = sidTerminateDate;
	}
	/**
	 * @return the tokenCustody
	 */
	@Column(name="Token_Custody")
	public Integer getTokenCustody() {
		return tokenCustody;
	}
	/**
	 * @param tokenCustody the tokenCustody to set
	 */
	public void setTokenCustody(Integer tokenCustody) {
		this.tokenCustody = tokenCustody;
	}
	/**
	 * @return the remarks
	 */
	@Column(name="Remarks")
	public String getRemarks() {
		return remarks;
	}
	/**
	 * @param remarks the remarks to set
	 */
	public void setRemarks(String remarks) {
		this.remarks = remarks;
	}
	/**
	 * @return the createdBy
	 */
	@Column(name="Created_By")
	public Integer getCreatedBy() {
		return createdBy;
	}
	/**
	 * @param createdBy the createdBy to set
	 */
	public void setCreatedBy(Integer createdBy) {
		this.createdBy = createdBy;
	}
	/**
	 * @return the createdOn
	 */
	@Column(name="Created_On")
	public Timestamp getCreatedOn() {
		return createdOn;
	}
	/**
	 * @param createdOn the createdOn to set
	 */
	public void setCreatedOn(Timestamp createdOn) {
		this.createdOn = createdOn;
	}
	/**
	 * @return the modifiedBy
	 */
	@Column(name="Modified_By")
	public Integer getModifiedBy() {
		return modifiedBy;
	}
	/**
	 * @param modifiedBy the modifiedBy to set
	 */
	public void setModifiedBy(Integer modifiedBy) {
		this.modifiedBy = modifiedBy;
	}
	/**
	 * @return the modifiedOn
	 */
	@Column(name="Modified_On")
	public Timestamp getModifiedOn() {
		return modifiedOn;
	}
	/**
	 * @param modifiedOn the modifiedOn to set
	 */
	public void setModifiedOn(Timestamp modifiedOn) {
		this.modifiedOn = modifiedOn;
	}
	
	
	
	
	
}

I am using spring an hibernate annotations. for jsp page i am asking the user to enter details and i am trying to save the details in db.
>And i am giving the @generated value for the ContactId

but ia m getting the error saying like this .


/////////////////
Jan 31, 2012 11:11:15 AM com.tcs.rdt.associate.web.AssociateController associateDoAdd
INFO: isAdminRole=null
Jan 31, 2012 11:11:15 AM com.tcs.rdt.associate.web.AssociateController associateDoAdd
INFO: associate emp id=1
Jan 31, 2012 11:11:15 AM com.tcs.rdt.associate.web.AssociateController associateDoAdd
INFO: associate emp name=s
Jan 31, 2012 11:11:15 AM com.tcs.rdt.associate.web.AssociateController associateDoAdd
INFO: associate created by =0
Jan 31, 2012 11:11:15 AM com.tcs.rdt.associate.web.AssociateController associateDoAdd
INFO: associate created on = 2012-01-31 11:11:15.562
Jan 31, 2012 11:11:15 AM com.tcs.rdt.associate.web.AssociateController associateDoAdd
INFO: associate modified by = 0
Jan 31, 2012 11:11:15 AM com.tcs.rdt.associate.web.AssociateController associateDoAdd
INFO: associate modified on = 2012-01-31 11:11:15.562
Jan 31, 2012 11:11:15 AM com.tcs.rdt.associate.web.AssociateController associateDoAdd
INFO: associate password = 1
Jan 31, 2012 11:11:15 AM com.tcs.rdt.associate.web.AssociateController associateDoAdd
INFO: associatecontact contact id=0
Jan 31, 2012 11:11:15 AM com.tcs.rdt.associate.web.AssociateController associateDoAdd
INFO: associatecontact emp team=s
Jan 31, 2012 11:11:15 AM com.tcs.rdt.associate.web.AssociateController associateDoAdd
INFO: associatecontact emp tcs mail=s
Jan 31, 2012 11:11:15 AM com.tcs.rdt.associate.web.AssociateController associateDoAdd
INFO: associatecontact emp created by =0
Jan 31, 2012 11:11:15 AM com.tcs.rdt.associate.web.AssociateController associateDoAdd
INFO: associatecontact emp created on = 2012-01-31 11:11:15.562
5639324 [http-8080-1] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: -1, SQLState: 42X04
5639324 [http-8080-1] ERROR org.hibernate.util.JDBCExceptionReporter - Column 'NEXT_HI' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'NEXT_HI' is not a column in the target table.
Jan 31, 2012 11:11:15 AM com.tcs.rdt.associate.web.AssociateController associateDoAdd
INFO: org.springframework.dao.InvalidDataAccessResourceUsageException: could not get or update next value; SQL [null]; nested exception is org.hibernate.exception.SQLGrammarException: could not get or update next value

[Mark Spritzler]

OK, this is a Hibernate issue and you mapping of the Primary Key and its Generation mechanism. In your case you configured it to use a HILO type algorithm, and probably not what your database uses.

Moving this to the ORM forum for better answers.

Oh, and we have a CODE button when posting that adds CODE tags to you post wher eyou post your code between those tags and the code keeps its nice to read format.

So I added CODE tags for you, but please use them in the future for us. Thanks

Good Luck

Mark