INSERT with raw_sql_query returns error

From: Nikos Paraschou (niparas..mail.com)
Date: Tue Aug 24 2010 - 20:59:32 UTC

  • Next message: Aristedes Maniatis: "Re: Queries against to-many relationships with 'NOT' subexpressions"

      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 : Tue Aug 24 2010 - 21:00:27 UTC