jpa - org.hibernate.QueryException: Not all named parameters have been set -

As a provider, I'm dealing with Hibernate 3.5.1-Finally JPA 2.0 Criteria API.

I am trying to create a dynamic query that looks like this in JPQL:

  Choose from the employee and less (E.fst_name) less (like: employee name) Or less (e.lastName) less (e.g., employee name)  

but retaining the error

  java.lang.IllegalArgumentException: org.hibernate.QueryException: Not all named parameters have been set: [param0] [Generate from com.company.model.Employee. Alaaas prepared in the form of an employee (where the lower (generated alias0.firstname) is less like (: param0)) or (less generated aliases: Param1). Allah firstname ASC]  

If I remove the path for lastname then it works fine, is anything wrong with me? Below are sections and queries included Thanks!

Summary. Java:

  @MappedSuperclass @SuppressWarnings ("serial") The essence of the public abstract class is & lt; ID serializable & gt; AbstractBaseEntity implies Serializable {@Id @GeneratedValue (strategy = GenerationType.AUTO) @Basic (Optional = Incorrect) @ Column (False = Wrong) Protected ID ID; / ** * gets the identifier of the unit * * @since 0.0.1 * @ Recognize identifier * / public id getId () {return.id; } / ** * sets the entity's identifier * * @since 0.0.1 * @ Param id identifier * / Public Zero Set ID (id id) {this.id = id; } / ** * Determines that if ID is tap * * @since 0.0.1 * @ back then if ID == faucet * / public boolean is new () {return id == tap; } @ Override Public Ent Hashod () {Inti hash = 0; Hash + = (id! = Tap? Id.hashCode (): 0); Return hashes; } @ Override public string toasting () {this.getClass return () ToString () + "[id =" + id + "]"; }  

}

Employees. Java:

@Entity public class employee {@basic (optional = false) @column (tapable = false, length = 50) Private string first name; @basic (optional = false) @ column (null = false, length = 50) personal string last name; Public employee () {} public employee (integer ID) {this.id = id; } Public employee (integer ID, string first name, string last name) {this.id = id; This.firstName = firstName; This.lastName = lastName; } Public Employee (string first name, string last name) {this.firstName = firstName; This.lastName = lastName; } Public string getFirstName () {return firstName; } Public Zero SetFirst-name (string first name) {this.firstName = firstName; } Public string getLastName () {lastName; } Public Zero setLlastName (string last name) {this.lastName = lastName; } @ Override Public Boolean Equivalent {// TODO: Warning - In this method the id field will not work if not set (! (Object Institution employee)) {return false; } Employee other = (employee) object; If ((this.id == faucet and other; id! = Null) || (this. Id! = Null & this.id.equals (other.id))) {return false; } Back true; }

}

EmployeeService.java Method:

Public listing & lt; Employee & gt; FindByCriteria (String Employee Name, String Offname, Int page number, Int page size) {CriteriaBuilder cb = entityManager.getCriteriaBuilder (); CriteriaQuery & LT; Employee & gt; C = cb.createQuery (employee class); The root of the & lt; Employee & gt; Emp = c.from (employee class); C.select (EMP); C.orderBy (cb.asc (emp.get ("firstName"))); & Lt; Predicate & gt; Criteria = New Arrestist & lt; Predicate & gt; (); ParameterExpression & LT; String & gt; ParamEmployeeName = CB Parameter (string class); // Create criteria with parameters (! StringUtils.isEmpty (employee name)) {criteria.add (cb.or (cb.like (cb.lower (emp. & Lt; string & gt; mill ("first name") , CB (ParamApureFireName), CB (CB.Lower (AMP., Lt; String & gt; Mill ("Last Name"), CB.Lover (Parampearian Names))}} // Add criteria to the criteria Give c.where (CriteriaTorra (new launch [0]); TypedQuery & lt; employee & gt; query = entityManager.createQuery (c); if (! StringUtils.isEmpty (employee name)) {query.setParameter (Paramijiya Rookie name, "%" + employee name + "%");} page (query, page number, page size); return query.getResultList ();}

< Div class = "post-text" itemprop = "text">

This can work instead using the static criteria. If you change : employee name in both cases and then Use:

  query.setParameter (0, "name"); Query.setParameter (1, "name");