Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not execute query

[Gabriela Rios]

Hello all,

I have a question/problem. I have a class with my User object. If I only have the columns as variables, everything works as expected. If I add another variable that is not in the database, I get "Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not execute query". I thought I could add the other variables without mapping them to the table (cardNumber, balance). I was wrong How can I add them to my class? Thanks.

import static javax.persistence.GenerationType.IDENTITY;

import java.io.Serializable;
import javax.persistence.*;
/**
 * User Object
 * 
 */
@Entity
@Table(name="users")
public class User implements Serializable {
	
	private long id;
	private String firstName;
	private String middleName;
	private String lastName;
	private String userName;
	private String password;
	private String emailPrimary;
	private String address;
	private String city;
	private String state;
	private int zipcode;
	private Boolean emailMessages;
	private Boolean phoneMessages;
	private String mobilePhone;
	private String language;
	private long registrationDate;
	private String rewardsUser;
	private String rewardsPw;
	private String cardNumber;
	//private double balance;
	
	/**
	 * @return the id
	 */
	@Id
	@GeneratedValue(strategy = IDENTITY)
	@Column(name="USERID")
	public long getId() {
		return id;
	}
	/**
	 * @param id the id to set
	 */
	public void setId(long id) {
		this.id = id;
	}
	/**
	 * @return the firstName
	 */
	@Column(name="FIRSTNAME")
	public String getFirstName() {
		return firstName;
	}
	/**
	 * @param firstName the firstName to set
	 */
	public void setFirstName(String firstName) {
		this.firstName = firstName;
	}
	/**
	 * @return the middleName
	 */
	@Column(name="MIDDLENAME")
	public String getMiddleName() {
		return middleName;
	}
	/**
	 * @param middleName the middleName to set
	 */
	public void setMiddleName(String middleName) {
		this.middleName = middleName;
	}
	/**
	 * @return the lastName
	 */
	@Column(name="LASTNAME")
	public String getLastName() {
		return lastName;
	}
	/**
	 * @param lastName the lastName to set
	 */
	public void setLastName(String lastName) {
		this.lastName = lastName;
	}
	/**
	 * @return the userName
	 */
	@Column(name="USERNAME")
	public String getUserName() {
		return userName;
	}
	/**
	 * @param userName the userName to set
	 */
	public void setUserName(String userName) {
		this.userName = userName;
	}
	/**
	 * @return the password
	 */
	@Column(name="PASSWORD")
	public String getPassword() {
		return password;
	}
	/**
	 * @param password the password to set
	 */
	public void setPassword(String password) {
		this.password = password;
	}
	/**
	 * @return the emailPrimary
	 */
	@Column(name="EMAILPRIMARY")
	public String getEmailPrimary() {
		return emailPrimary;
	}
	/**
	 * @param emailPrimary the emailPrimary to set
	 */
	public void setEmailPrimary(String emailPrimary) {
		this.emailPrimary = emailPrimary;
	}
	/**
	 * @return the address
	 */
	@Column(name="ADDRESS")
	public String getAddress() {
		return address;
	}
	/**
	 * @param address the address to set
	 */
	public void setAddress(String address) {
		this.address = address;
	}
	/**
	 * @return the city
	 */
	@Column(name="CITY")
	public String getCity() {
		return city;
	}
	/**
	 * @param city the city to set
	 */
	public void setCity(String city) {
		this.city = city;
	}
	/**
	 * @return the state
	 */
	@Column(name="STATE")
	public String getState() {
		return state;
	}
	/**
	 * @param state the state to set
	 */
	public void setState(String state) {
		this.state = state;
	}
	/**
	 * @return the zipcode
	 */
	@Column(name="ZIPCODE")
	public int getZipcode() {
		return zipcode;
	}
	/**
	 * @param zipcode the zipcode to set
	 */
	public void setZipcode(int zipcode) {
		this.zipcode = zipcode;
	}
	/**
	 * @return the emailMessages
	 */
	@Column(name="EMAILMESSAGES")
	public Boolean isEmailMessages() {
		return emailMessages;
	}
	/**
	 * @param emailMessages the emailMessages to set
	 */
	public void setEmailMessages(Boolean emailMessages) {
		this.emailMessages = emailMessages;
	}
	/**
	 * @return the phoneMessages
	 */
	@Column(name="PHONEMESSAGES")
	public Boolean isPhoneMessages() {
		return phoneMessages;
	}
	/**
	 * @param phoneMessages the phoneMessages to set
	 */
	public void setPhoneMessages(Boolean phoneMessages) {
		this.phoneMessages = phoneMessages;
	}
	/**
	 * @return the mobilePhone
	 */
	@Column(name="MOBILEPHONE")
	public String getMobilePhone() {
		return mobilePhone;
	}
	/**
	 * @param mobilePhone the mobilePhone to set
	 */
	public void setMobilePhone(String mobilePhone) {
		this.mobilePhone = mobilePhone;
	}
	/**
	 * @return the language
	 */
	@Column(name="LANGUAGE")
	public String getLanguage() {
		return language;
	}
	/**
	 * @param language the language to set
	 */
	public void setLanguage(String language) {
		this.language = language;
	}
	/**
	 * @return the registrationDate
	 */
	@Column(name="REGISTRATIONDATE")
	public long getRegistrationDate() {
		return registrationDate;
	}
	/**
	 * @param registrationDate the registrationDate to set
	 */
	public void setRegistrationDate(long registrationDate) {
		this.registrationDate = registrationDate;
	}
	/**
	 * @return the rewardsUser
	 */
	@Column(name="REWARDSUSER")
	public String getRewardsUser() {
		return rewardsUser;
	}
	/**
	 * @param rewardsUser the rewardsUser to set
	 */
	public void setRewardsUser(String rewardsUser) {
		this.rewardsUser = rewardsUser;
	}
	/**
	 * @return the rewardsPw
	 */
	@Column(name="REWARDSPW")
	public String getRewardsPw() {
		return rewardsPw;
	}
	/**
	 * @param rewardsPw the rewardsPw to set
	 */
	public void setRewardsPw(String rewardsPw) {
		this.rewardsPw = rewardsPw;
	}
	/**
	 * @return the cardNumber
	 */
		public String getCardNumber() {
		return cardNumber;
	}
	
	/**
	 * @param cardNumber the cardNumber to set
	 */
	
	public void setCardNumber(String cardNumber) {
		this.cardNumber = cardNumber;
	}
	
	/**
	 * @return the balance
	 */
	/*
	public double getBalance() {
		return balance;
	}
	*/
	/**
	 * @param balance the balance to set
	 */
	/*
	public void setBalance(double balance) {
		this.balance = balance;
	}
	*/
	public String toString() {
		return "User [firstName=" + firstName + ", lastName=" + lastName
				+ ", userName=" + userName + ", password=" + password
				+ ", emailPrimary=" + emailPrimary + ", address=" + address
				+ ", city=" + city + ", state=" + state + ", zipcode="
				+ zipcode + ", registrationDate=" + registrationDate + "]";
	}
	
}

[Mark Spritzler]

By default all properties are mapped with Annotations. So if you have a property that is not in the database you have to annotate it with @Transient.

Moving this to the ORM forum. This is not Spring related.

Mark

[Gabriela Rios]

Thanks! My bad. I'll be more careful next time.