Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: pass (athena.apache.org: domain of niparasc@gmail.com designates
 74.125.82.47 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:user-agent:mime-version:to:subject:references
         :in-reply-to:content-type:content-transfer-encoding;
        b=Jqzd/SwF3eRbL4CWyJtBk0WaIlBB1EWADmsvMpbPR4sETTzGO/mq9IHeHNgXnZYW4f
         Rw0qWG8IAWswCVAozzG8m8je0q59o4zgP2hzb8mXfr2/gyIYZcA5QSC1/Gdgrwrzkpx/
         5HZ153/rugdoJEKw04M2KTv+sP+SqxxQl3zrg=
Message-ID: <4C74C67D.4050706@gmail.com>
Date: Wed, 25 Aug 2010 10:30:05 +0300
From: Nikos Paraschou <niparasc@gmail.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US;
 rv:1.9.2.8) Gecko/20100802 Thunderbird/3.1.2
MIME-Version: 1.0
To: user@cayenne.apache.org
Subject: Re: Antwort: INSERT with raw_sql_query returns error
References: 
 <OFD89067F3.ADF4E0A7-ONC125778A.001A0530-C125778A.001A37DE@gi-de.com>
In-Reply-To: 
 <OFD89067F3.ADF4E0A7-ONC125778A.001A0530-C125778A.001A37DE@gi-de.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

  Thank you Patrick.

I thought that if I change the query by removing the #bind from the 
column names, like this:

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

there would be more chances for it to work, but still it doesn't. The 
problem this time is that when the variable $columns is replaced by the 
ArrayList columnNames, these two symbols ("[" and "]") are also added to 
the query causing the error. It becomes like this:

insert into mySchema.myTable ([column1, column2, ..., columnn]) values 
(?, ?, ..., ?)

Any idea how I could remove these two symbols ("[" and "]")?

Thank you,
Nikos


On 25/8/2010 7:46 πμ, 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
>
>