@Ari I do not want to write SQL query in SQL TEMPLETE or EJBQLQuery, because I have two databases MS SQL server and PostgreSQL and both of them have syntactical difference. I want to use predefined manipulation and updation methods in cayenne, so that if I change database I do not have to write SQL queries again.
@Andrus my concern is first select a record and then updating it does not take more time then direct updation. Because I already have id which I want to update, so why would I use select query ?. I am dealing with more then 25 lakhs record. On Fri, Sep 11, 2015 at 9:02 PM, Dipesh Jain <dip...@ivgroup.in> wrote: > 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? I do not want to use EJBQLQuery or SQL TEMPLETE. > > -- > Thanks and Regards > Deepesh Jain > -- Thanks and Regards Deepesh Jain