Return-Path: 
 <ojb-dev-return-11019-apmail-db-ojb-dev-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-ojb-dev-archive@www.apache.org
Received: (qmail 25884 invoked from network); 12 Jan 2005 23:46:39 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur-2.apache.org with SMTP; 12 Jan 2005 23:46:39 -0000
Received: (qmail 31993 invoked by uid 500); 12 Jan 2005 23:46:38 -0000
Delivered-To: apmail-db-ojb-dev-archive@db.apache.org
Received: (qmail 31956 invoked by uid 500); 12 Jan 2005 23:46:38 -0000
Mailing-List: contact ojb-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:ojb-dev-unsubscribe@db.apache.org>
List-Subscribe: <mailto:ojb-dev-subscribe@db.apache.org>
List-Help: <mailto:ojb-dev-help@db.apache.org>
List-Post: <mailto:ojb-dev@db.apache.org>
List-Id: "OJB Developers List" <ojb-dev.db.apache.org>
Reply-To: "OJB Developers List" <ojb-dev@db.apache.org>
Delivered-To: mailing list ojb-dev@db.apache.org
Received: (qmail 31931 invoked by uid 99); 12 Jan 2005 23:46:37 -0000
X-ASF-Spam-Status: No, hits=0.1 required=10.0
	tests=FORGED_RCVD_HELO
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Received: from garuda-95.cablenet.com.ni (HELO ags01.agsoftware.dnsalias.com)
 (165.98.147.95)
  by apache.org (qpsmtpd/0.28) with ESMTP; Wed, 12 Jan 2005 15:46:36 -0800
Received: from ags01.agsoftware.dnsalias.com (localhost.localdomain
 [127.0.0.1])
	by ags01.agsoftware.dnsalias.com (8.12.11/8.12.10) with ESMTP id
 j0CNkSff002559
	for <ojb-dev@db.apache.org>; Wed, 12 Jan 2005 17:46:28 -0600
Received: (from apache@localhost)
	by ags01.agsoftware.dnsalias.com (8.12.11/8.12.11/Submit) id j0CNkOVh002558;
	Wed, 12 Jan 2005 17:46:24 -0600
X-Authentication-Warning: ags01.agsoftware.dnsalias.com: apache set sender to
 agallardo@agssa.net using -f
Received: from 10.0.0.5
        (SquirrelMail authenticated user agallardo);
        by www.agssa.net with HTTP;
        Wed, 12 Jan 2005 17:46:24 -0600 (CST)
Message-ID: <37452.10.0.0.5.1105573584.squirrel@www.agssa.net>
In-Reply-To: 
     <41625.10.0.0.1.1105489963.squirrel@ags01.agsoftware.dnsalias.com>
References: 
    <41625.10.0.0.1.1105489963.squirrel@ags01.agsoftware.dnsalias.com>
Date: Wed, 12 Jan 2005 17:46:24 -0600 (CST)
Subject: Re: SECUENCE of PostgreSQL increment value if use QueryByIdentity
     and  getObjectByQuery
From: "Antonio Gallardo" <agallardo@agssa.net>
To: ojb-dev@db.apache.org
User-Agent: SquirrelMail/1.4.3a-6.FC2
X-Mailer: SquirrelMail/1.4.3a-6.FC2
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Priority: 3 (Normal)
Importance: Normal
X-Virus-Checked: Checked
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

Hi:

We are trying to fix this problem:

Using QueryByIdentity is the key is set to null, then the sequence manager
is activated. Here is the snapshot of the code:

    Client c = new Client();
    c.setCli_id(null);         /* <--- Set the key to null */
    Query query = new QueryByIdentity(c);
    Client N = (Client) pb.getObjectByQuery(query);

Here is the repo.xml of the Client c:

<class-descriptor class="my.package.Cliente" table="CLIENTE">
  <field-descriptor name="cli_id"
                    primarykey="true"
                    nullable="false"
                    default-fetch="true"
                    autoincrement="true"
                    sequence-name="cliente_cli_id_seq"
                    column="CLI_ID"
                    jdbc-type="INTEGER"/>
  <field-descriptor name="cli_nombre"
                    nullable="false"
                    default-fetch="true"
                    column="CLI_NOMBRE"
                    jdbc-type="VARCHAR"/>
</class-descriptor>

Why this code retrieve a nextVal from the given sequence manager. Is this
a bug?

Please confirm id this is a bug and we will try to fix it. ;-)

BTW, we are using OBJ_1_0_RELEASE from the CVS (few minuts ago).

Best Regards,

Antonio Gallardo.


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org