SQLTemplate is SQL enchanced with Velocity-like templates (standard and Cayenne-specific). Thus, any SQL can be performed. It will return you a map (DataRow) if it is SELECT query (use setFetchingDataRows(true)), for non-select queries use context.performGenericQuery()
2010/3/3 Sudheer <[email protected]> > > I think SQLTemplate is designed to work on DataObject that is linked to a > table. In my case, I am using query that is not mapped to DataObject or > having direct table in database. Do you think SQLTemplate is possible on > direct SQL query that is not DataObject or Table. > -- > View this message in context: > http://n3.nabble.com/Named-query-not-working-with-parameters-tp425935p426325.html > Sent from the Cayenne - User mailing list archive at Nabble.com. > -- Andrey
