How do you update a record with apache cayenne without using select clause

Question

I am using apache cayenne 3.1. I know of one way to update records in the database is to first use select query to find record and then update it, but I don't want to use a select query for updating. How can I directly update the record?

Answer 1

EJBQLQuery allows to do direct DB updates. Also SQLTemplate, though in that case you are completely breaking with the object model, and will be writing DB-specific SQL.