SqlTemplate allows you to define different queries for different databases and chooses the correct one at runtime.
On Sat, Sep 12, 2015 at 7:51 AM Dipesh Jain <dip...@ivgroup.in> wrote: > @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 >