CODEWITHSUNDEEP
javahibernate-criteria
Anirudh Lou
Anirudh Lou

Reputation: 831

How to include concatenation in Hibernate?

I am trying to migrate from native mysql query into hibernate but i am wondering how can i do this following query into hibernate? This is my code:

 sql = "SELECT s.* FROM student s WHERE concat_ws(', ',s.last_name,concat_ws(' ',concat_ws(' ',s.first_name,s.suffix),s.middle_name)) like ?"
 pstmt = con.prepareStatement(sql);
 pstmt.setString(1, fullName);
 ...

My point here is the concatenation of my fields: last_name, first_name, suffix, and middle_name. I used concat_ws so to ignore the NULL value from one of my field.

EDIT

So I try my code something like this:

String sql = "SELECT s.* FROM student s WHERE concat_ws(', ',s.last_name,concat_ws(' ',concat_ws(' ',s.first_name,s.suffix),s.middle_name)) like :name";
SQLQuery query = session.createSQLQuery(sql);
query.addEntity(Student.class);
query.setParameter("name", fullName);
student = (Student) query.list().get(0);

but why it gives me null?

Upvotes: 0

Views: 89

Answers (1)

kyiu
kyiu

Reputation: 1976

JPQL provides a function named CONCAT...

Upvotes: 1

Related Questions