Re: SelectQuery and getting where clause

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Tue Oct 09 2007 - 09:49:46 EDT

  • Next message: Andrus Adamchik: "Re: Cayenne ActiveRecord like interface"

    Could you elaborate on what are you trying to do? Do you want to
    capture generated SQL without executing it?

    Note that Cayenne-generated SQL uses PreparedStatement syntax with
    "?" placeholders for most parameters, letting JDBC driver to bind
    them correctly.

    Andrus

    On Oct 9, 2007, at 2:11 PM, David Marko wrote:

    > Hello, I need to create a select query that have some parameters
    > and I need to
    > get SQL where statement from it containing replaced parameters.
    > (see snippet
    > below) . Is there any way how to accomplish this?
    >
    >
    > [Code snippet]
    > SelectQuery sq = new
    > SelectQuery(Role.class,Expression.fromString(this.whereClause));
    > return sq.queryWithParameters(params);
    >



    This archive was generated by hypermail 2.0.0 : Tue Oct 09 2007 - 09:50:20 EDT