Getting Query syntax error when trying to use inner join

Question

Im getting a org.hibernate.hql.internal.ast.QuerySyntaxException in my query

Query query = session.createQuery("update Room as r "
            + "inner join Booking as b "
            + "on r.roomId = b.room.roomId "
            + "set r.roomAvailable = true "
            + "where b.checkOutDate < NOW()");

full error:

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: expecting "set", found 'inner' near line 1, column 55 [update com.websystique.springsecurity.model.Room as r inner join com.websystique.springsecurity.model.Booking as b on r.roomId = b.room.roomId set r.roomAvailable = true where b.checkOutDate < NOW()]

the query is working fine in mysql workbench... so is this possible in anyway here in code or not?

Any help greatly appreciated.

the query is working fine in mysql workbench: mysql workbench executes SQL queries. session.createQuery expects an HQL query. Those are two different languages. — JB Nizet
– JB Nizet, Commented Feb 15, 2017 at 19:45

Erik B from B · Accepted Answer · 2017-02-15 19:50:11Z

1

You have to use a query with a subselect instead of a join. Rewrite your query and it will work.

answered Feb 15, 2017 at 19:50

Erik B from B

625 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Getting Query syntax error when trying to use inner join

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related