RE: PK generation problem: uniqueness constraint violated

2007-08-10 Thread Török Péter
ng it in the modeler doesn't have an effect (or am I totally misunderstanding something here about how Cayenne is supposed to work)? Thanks, Peter -Original Message----- From: Török Péter [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 07, 2007 4:56 PM To: user@cayenne.apache.org S

PK generation problem: uniqueness constraint violated

2007-08-07 Thread Török Péter
Hello, I have a small application with an Oracle DB schema containing a single sequence, to be used by all tables (there aren't many of them). The sequence is created with this code: CREATE SEQUENCE MY_SEQ INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 999 NOCYCLE

RE: Source code in jar?

2007-03-22 Thread Török Péter
Oops, sorry. I haven't noticed that it was there... Thanks, Péter -Original Message- From: Andrus Adamchik [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 21, 2007 5:46 PM To: user@cayenne.apache.org Subject: Re: Source code in jar? On Mar 21, 2007, at 6:35 PM, Török Péter

Source code in jar?

2007-03-21 Thread Török Péter
Hello, is the official source code of Cayenne 2.0.2 publicly available in a jar or zip somewhere? Thanks in advance, Péter

RE: Wanted: performance tuning hints

2007-03-12 Thread Török Péter
operations. I > guess you should choose which one to use depending on circumstances. Yes, you are right of course. I was considering only the current performance test where I update or delete a large number of objects based on a simple select. Cheers, Péter On Mar 12, 2007, at 4:40 PM, Török

Wanted: performance tuning hints

2007-03-12 Thread Török Péter
Sorry for the previous mail, I inadvertently sent it half-ready :-( Hello, I made a small performance test comparing different Cayenne solutions with JDBC solutions. What I found was that in Insert operations, it is best to use Cayenne data objects (as opposed to raw SQL queries), while for Updat

Wanted: performance tuning hints

2007-03-12 Thread Török Péter
Hello, I made a small performance test comparing different Cayenne solutions with JDBC solutions. What I found was that in Insert operations, it is best to use Cayenne data objects (as opposed to raw SQL queries), while for Update and Delete the case is the opposite. So for Insert, this worked b

Deleting a data row?

2007-03-08 Thread Török Péter
Hello, I have a related question. Is it possible to delete a record using a data row, without having to instantiate first a data object via context.objectFromDataRow() (as it is seen in the code example below)? If possible, how? Thanks in advance, Péter -Original Message- From: Andrus Ad

RE: java docs

2007-03-06 Thread Török Péter
For version 2, you may find them here: http://cayenne.apache.org/doc20/api/cayenne/index.html Péter -Original Message- From: Marcin Skladaniec [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 06, 2007 1:33 AM To: user@cayenne.apache.org Subject: java docs Hello I cant find a link to cayen

Must class qualifier be an entire field?

2007-02-27 Thread Török Péter
Hello, is it necessary to have a full column reserved for the class qualifier in case of single table inheritance? I.e. instead of qualifier personType = 'CUSTOMER' would something like personType like 'C%' work? Anyone tried such a thing yet? Thanx in advance, Péter

How to set default values or use triggers for a column?

2007-02-22 Thread Török Péter
I have an attribute in some of my tables which are supposed to store the date&time of the record's last modification. The idea (coming from our DB expert) is that we set the default value (SYSDATE) in the DB and update the value via a trigger whenever the record is modified. Is there a way to te