Re: Named query not working with parameters

From: Andrey Razumovsky (razumovsky.andre..mail.com)
Date: Wed Mar 03 2010 - 09:22:08 EST

  • Next message: Michael Gentry: "Re: Direct mapping between Named query and Pojo"

    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 <sudheer.tec..mail.com>

    >
    > 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

    This archive was generated by hypermail 2.0.0 : Wed Mar 03 2010 - 09:23:06 EST