problem in criteria api

[Singh Harmeet]

public static void retriveByLoginName(User user) {
	Example example = Example.create(user);
	session = HibernateUtil.beginTransaction();
	Criteria criteria = session.createCriteria(User.class);
	criteria.add(example);
	List<User> userList = criteria.list();
	System.out.println(userList.size());
	HibernateUtil.commitTransaction();
	
	for(User user1 : userList){
		System.out.println(user1);
	}
}

in this code i am trying to use criteria api to retrive the data from database and my citeria is :-

public static void main(String[] args) {
	User user = new User();
	user.setLoginName("harmeetsingh0013");
	//user.setVerified(true);
	CriteriaApiRunner.retriveByLoginName(user);
}

but the query generated by this code is

Hibernate: select this_.id as id0_0_, this_.email_address as email2_0_0_, this_.last_access as last3_0_0_,
  this_.login_name as login4_0_0_, this_.name as name0_0_, this_.password as password0_0_,
  this_.regestration_time as regestra7_0_0_, this_.verified as verified0_0_ from hibernate_test.user this_
  where (this_.login_name=? and this_.verified=?)
0

in my criteria i am try to use only login name but verfied is automatially include why?

[Paul Clapham]

I don't see any code there which says to use, or not to use, any of the fields of the User class in the generated query. So therefore I don't find it surprising that all of the fields are used.

But perhaps that code is hidden somewhere in that Example class, which I don't see?

At any rate here's a link to a relevant (I hope) tutorial: Chapter 15. Criteria Queries.

[Singh Harmeet]

sir if you need , i post my all code...

[Singh Harmeet]

sir in my user class the verfied property is boolean . this is my user class structure

package com.saveuserobject.domain;

import java.util.Calendar;
import java.util.Date;

import javax.persistence.Basic;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.NamedQuery;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;
import javax.persistence.Transient;



@Entity
@Table(name="user" , schema="hibernate_test" )
@NamedQuery(name="user.findByLoginName" , query="from User where login_name = 'harmeetsingh0013' ")
public class User {

	private int id;
	private String name;
	private String loginName;
	private String password;
	private String encPassword;
	private String emailAddress;
	private boolean verified;
	private Date lassAccess;
	private Calendar regestrationTime;
	
	
	
	@Id
	@GeneratedValue
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	
	@Column(name="login_name")
	public String getLoginName() {
		return loginName;
	}
	public void setLoginName(String loginName) {
		this.loginName = loginName;
	}
	
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	
	@Transient
	public String getEncPassword() {
		return encPassword;
	}
	public void setEncPassword(String encPassword) {
		this.encPassword = encPassword;
	}
	
	@Column(name="email_address")
	public String getEmailAddress() {
		return emailAddress;
	}
	public void setEmailAddress(String emailAddress) {
		this.emailAddress = emailAddress;
	}
	
	@Basic
	public boolean isVerified() {
		return verified;
	}
	public void setVerified(boolean verified) {
		this.verified = verified;
	}
	
	@Temporal(TemporalType.DATE)
	@Column(name="last_access")
	public Date getLassAccess() {
		return lassAccess;
	}
	public void setLassAccess(Date lassAccess) {
		this.lassAccess = lassAccess;
	}
	
	@Temporal(TemporalType.TIMESTAMP)
	@Column(name="regestration_time")
	public Calendar getRegestrationTime() {
		return regestrationTime;
	}
	public void setRegestrationTime(Calendar regestrationTime) {
		this.regestrationTime = regestrationTime;
	}
	
	@Override
	public String toString() {
		return "User [id=" + id + ", name=" + name + ", loginName=" + loginName
				+ ", password=" + password + ", encPassword=" + encPassword
				+ ", emailAddress=" + emailAddress + ", verified=" + verified
				+ ", lassAccess=" + lassAccess + ", regestrationTime="
				+ regestrationTime + "]";
	}
	
}

i think this problem is from default value of user classs? and if i create the criteria according to User id field , the query generate by hibernate not include id field in where clause .

[Bill Gorder]

What Paul asked to see was the Example class

[Paul Clapham]

Or any code at all which put any restrictions on the Criteria object. I don't see any, and what you post suggests that there aren't any. In other words, that's completely not surprising. And I'm not sure why you think the fact that an attribute is a boolean attribute should make a difference.

[Singh Harmeet]

then sir what i do ? i also try to use Example.excludeProperty(String) but this function does not perform any action.

[Paul Clapham]

Well, that at least would be a better question if you asked it.