Antwort: INSERT with raw_sql_query returns error

From: patrick.maywe..i-de.com
Date: Wed Aug 25 2010 - 04:46:21 UTC

  • Next message: Andrus Adamchik: "Re: Antwort: INSERT with raw_sql_query returns error"

    Hi Nikos,
    the #bind variables are replaced by PreparedStatement parameters and DB2
    does not allow parameter for column names.
    Regards,
    Patrick

    Nikos Paraschou <niparas..mail.com>
    24.08.2010 23:00
    Bitte antworten an
    use..ayenne.apache.org

    An
    use..ayenne.apache.org
    Kopie

    Thema
    INSERT with raw_sql_query returns error

      Hello,

    I have created the following raw sql query inside Cayenne Modeler:

    insert into $schema.$table (#bind($columns)) values(#bind($values))

    To run it from a java application I use this code:

    String[] keys = new String[] {"schema", "table", "columns", "values"};
    Object[] values = new Object[] {schema, table, columnNames, columnValues};
    NamedQuery query = new NamedQuery("myQuary", keys, values);
    context.performQuery(query);

    columnNames and columnValues are both ArrayLists. The binding of the
    values to their keys seems to work fine (according to the log messages
    when the query is run). Unfortunately, I keep getting a
    CayenneRuntimeException caused by:

    com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-727,
    SQLSTATE=56098, SQLERRMC=2;-104;42601;(?,?,?,?,?,?,?,?,?,?,?,?,?)
    values|AL_STATS_WITH_ID_WCT|<, DRIVER=3.57.82

    Am I doing something wrong? I am using Cayenne version 3.

    Thank you,
    Nikos

    This archive was generated by hypermail 2.0.0 : Wed Aug 25 2010 - 04:47:13 UTC