Members are not poppulated?

[Timothy Sam]

Hi guys! I'm trying to select record from the database and map it into my class. I'm using JPA and Toplink. First of all, here is my query.

     Query query = em.createQuery("select i from InventoryUser i where i.username = ?1 and i.password = ?2");
     query.setParameter(1, inventoryUser.getUsername().trim() );
     query.setParameter(2, inventoryUser.getPassword().trim() );
     
             inventoryUser = (InventoryUser)query.getSingleResult();
     inventoryUser.setPassword("");

My entity class

/*
 * InventoryUser.java
 *
 * Created on May 2, 2007, 4:12 PM
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */
 
package com.wp.wpinventory.model;
 
import java.io.Serializable;
import java.util.Collection;
import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.OneToMany;
import javax.persistence.Table;
 
/**
 * Entity class InventoryUser
 * 
 * @author paul.timothy
 */
@Entity
@Table(name = "inventory_user")
@NamedQueries( {
@NamedQuery(name = "InventoryUser.findByUserId", query = "SELECT i FROM InventoryUser i WHERE i.userId = :userId"),
@NamedQuery(name = "InventoryUser.findByEmployeeId", query = "SELECT i FROM InventoryUser i WHERE i.employeeId = :employeeId"),
@NamedQuery(name = "InventoryUser.findByUsername", query = "SELECT i FROM InventoryUser i WHERE i.username = :username"),
@NamedQuery(name = "InventoryUser.findByPassword", query = "SELECT i FROM InventoryUser i WHERE i.password = :password")
})
public class InventoryUser implements Serializable {
 
@Id
@Column(name = "user_id", nullable = false)
private Integer userId;
 
@Column(name = "employee_id")
private Integer employeeId;
 
@Column(name = "username")
private String username;
 
@Column(name = "password")
private String password;
 
@JoinColumn(name = "user_type_id", referencedColumnName = "user_type_id")
@ManyToOne
private InventoryUserType userTypeId;
 
@OneToMany(cascade = CascadeType.ALL, mappedBy = "assignedBy")
private Collection<FixedItem> fixedItemCollection;
    
    /** Creates a new instance of InventoryUser */
    public InventoryUser() {
    }
 
/**
 * Creates a new instance of InventoryUser with the specified values.
 * @param userId the userId of the InventoryUser
 */
public InventoryUser(Integer userId) {
this.userId = userId;
}
 
/**
 * Gets the userId of this InventoryUser.
 * @return the userId
 */
public Integer getUserId() {
return this.userId;
}
 
/**
 * Sets the userId of this InventoryUser to the specified value.
 * @param userId the new userId
 */
public void setUserId(Integer userId) {
this.userId = userId;
}
 
/**
 * Gets the employeeId of this InventoryUser.
 * @return the employeeId
 */
public Integer getEmployeeId() {
return this.employeeId;
}
 
/**
 * Sets the employeeId of this InventoryUser to the specified value.
 * @param employeeId the new employeeId
 */
public void setEmployeeId(Integer employeeId) {
this.employeeId = employeeId;
}
 
/**
 * Gets the username of this InventoryUser.
 * @return the username
 */
public String getUsername() {
return this.username;
}
 
/**
 * Sets the username of this InventoryUser to the specified value.
 * @param username the new username
 */
public void setUsername(String username) {
this.username = username;
}
 
/**
 * Gets the password of this InventoryUser.
 * @return the password
 */
public String getPassword() {
return this.password;
}
 
/**
 * Sets the password of this InventoryUser to the specified value.
 * @param password the new password
 */
public void setPassword(String password) {
this.password = password;
}
 
/**
 * Gets the userTypeId of this InventoryUser.
 * @return the userTypeId
 */
public InventoryUserType getUserTypeId() {
return this.userTypeId;
}
 
/**
 * Sets the userTypeId of this InventoryUser to the specified value.
 * @param userTypeId the new userTypeId
 */
public void setUserTypeId(InventoryUserType userTypeId) {
this.userTypeId = userTypeId;
}
 
/**
 * Gets the fixedItemCollection of this InventoryUser.
 * @return the fixedItemCollection
 */
public Collection<FixedItem> getFixedItemCollection() {
return this.fixedItemCollection;
}
 
/**
 * Sets the fixedItemCollection of this InventoryUser to the specified value.
 * @param fixedItemCollection the new fixedItemCollection
 */
public void setFixedItemCollection(Collection<FixedItem> fixedItemCollection) {
this.fixedItemCollection = fixedItemCollection;
}

/**
 * Returns a hash code value for the object.  This implementation computes 
 * a hash code value based on the id fields in this object.
 * @return a hash code value for this object.
 */
@Override
public int hashCode() {
int hash = 0;
hash += (this.userId != null ? this.userId.hashCode() : 0);
return hash;
}
 
/**
 * Determines whether another object is equal to this InventoryUser.  The result is 
 * <code>true</code> if and only if the argument is not null and is a InventoryUser object that 
 * has the same id field values as this object.
 * @param object the reference object with which to compare
 * @return <code>true</code> if this object is the same as the argument;
 * <code>false</code> otherwise.
 */
@Override
public boolean equals(Object object) {
// TODO: Warning - this method won't work in the case the id fields are not set
if (!(object instanceof InventoryUser)) {
return false;
}
InventoryUser other = (InventoryUser)object;
if (this.userId != other.userId && (this.userId == null || !this.userId.equals(other.userId))) return false;
return true;
}
 
/**
 * Returns a string representation of the object.  This implementation constructs 
 * that representation based on the id fields.
 * @return a string representation of the object.
 */
@Override
public String toString() {
return "com.wp.wpinventory.model.InventoryUser[userId=" + userId + "]";
}
    
}
 

As you can see, I'm thinking that userId and all other fields would already be poppulated. But when I supply correct data for the username and password and the Object is retrieved, its members especially the userId is not filled. Why is that? Thanks!

[Mark Spritzler]

Probably because it assumes that youa re going to fill that in, because your mapping is

@Id
@Column(name = "user_id", nullable = false)
private Integer userId;

Where is the @GeneratedValue to tell it to generate the value?

Mark