Re: Antwort: INSERT with raw_sql_query returns error

2010-08-25 Thread Nikos Paraschou
for column names. Regards, Patrick Nikos Paraschou 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 $sche

Re: Antwort: INSERT with raw_sql_query returns error

2010-08-25 Thread Nikos Paraschou
hese two symbols ("[" and "]")? Thank you, Nikos On 25/8/2010 7:46 πμ, patrick.may...@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 24.08.2010 23:

INSERT with raw_sql_query returns error

2010-08-24 Thread Nikos Paraschou
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[

Re: Question about Caching.

2009-04-21 Thread Nikos Paraschou
g. Nikos > > Andrus > > > On Apr 21, 2009, at 1:50 PM, Nikos Paraschou wrote: > > Στις 21-04-2009, ημέρα Τρι, και ώρα 13:21 +0300, ο/ > > η Andrus Adamchik > > έγραψε: > >>> Shouldn't it first look in cache? > >> > >> >

Re: Question about Caching.

2009-04-21 Thread Nikos Paraschou
d call doesn't retrieve the requested vehicle from the cache but instead, it sends a query to the DB. Why is this happening? Is it normal? > And also which version of Cayenne is this? I am using Cayenne 2.0.4. > > Andrus > > > On Apr 21, 2009, at 12:28 PM, Nikos Para

Question about Caching.

2009-04-21 Thread Nikos Paraschou
rieved Vehicle Objects in cache. But the second call, instead of getting the specific vehicle from cache it sends a query to the database. Why is this happening? Shouldn't it first look in cache? Thank you, Nikos Paraschou

Re: How to create Meaningful Primary Keys?

2009-02-02 Thread Nikos Paraschou
The point about saying "no to meaningful pointers" is very clear. Thank you for your replies and advice. I will perform some tests as soon as I can and come back with feedback, if I encounter any problems. Regards, Nikos Στις 02-02-2009, ημέρα Δευ, και ώρα 14:21 +0100, ο/η Pierre Lavignotte έγρ