cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: Antwort: INSERT with raw_sql_query returns error
Date Wed, 25 Aug 2010 07:29:23 GMT
Exactly. However something like that may work ("columns" will have to be a comma-separated
String) :

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

Andrus

On Aug 25, 2010, at 7:46 AM, patrick.mayweg@gi-de.com wrote:

> Hi Nikos,
> the #bind variables are replaced by PreparedStatement parameters and DB2 
> does not allow parameter for column names.
> Regards,
> Patrick
> 
> 
> 
> 
> Nikos Paraschou <niparasc@gmail.com> 
> 24.08.2010 23:00
> Bitte antworten an
> user@cayenne.apache.org
> 
> 
> An
> user@cayenne.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
> 


Mime
View raw message