Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: domain of msatoor@gmail.com designates
 209.85.198.239 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version
         :content-type:content-transfer-encoding:content-disposition
         :references;
        b=Bky/tltS94IaVtVsTXeeqYcZx5F6LMCwuhMbufa1x+bZOb/ba+hf4jl2PHZZCpCh5z
         gZ1EKsuTmAYW467xy2VXT5xdOqepoxTztbxmKL2T2yStMJ8sxraNo9spxRr1wIrtOWEq
         eUC740VmL4RAbVE6h3xRRRrZpyO6u1achNfRY=
Message-ID: <d9619e4a0806101119o27a71323j7a826919c255108e@mail.gmail.com>
Date: Tue, 10 Jun 2008 11:19:50 -0700
From: "Mamta Satoor" <msatoor@gmail.com>
To: "Derby Discussion" <derby-user@db.apache.org>
Subject: Re: Trigger function broken in 10.4.1.3?
In-Reply-To: <ae8fc1c0806100716l2d8b0434w4f3ef59df8fabf63@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <ae8fc1c0806100716l2d8b0434w4f3ef59df8fabf63@mail.gmail.com>

Thiyagu, can you post the null pointer exception trace that you get?

Mamta

On 6/10/08, Thiyagu P <thiyagu@gmail.com> wrote:
> Hi,
>
> Getting null pointer exception when a trigger gets invoked.
>
> Steps to recreate :
> 1. Created new db and execute the following stmts
> 2. CREATE TABLE TRADE(
>       ID INT PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (START WITH 1000),
>       BUYID INT NOT NULL,
>       QTY FLOAT(2) NOT NULL
>    );
>
>    CREATE TABLE TOTAL(BUYID INT NOT NULL, TOTALQTY FLOAT(2) NOT NULL);
>
>    CREATE TRIGGER TRADE_INSERT
>      AFTER INSERT ON TRADE
>      REFERENCING NEW AS NEWROW
>      FOR EACH ROW MODE DB2SQL
>      UPDATE TOTAL SET TOTALQTY = NEWROW.QTY WHERE BUYID = NEWROW.BUYID;
>
>    INSERT INTO TOTAL VALUES (1, 0);
>
>    INSERT INTO TRADE VALUES(1, 1, 1, 10);
>
> Same thing work fine in 10.3.3.0.
>
>
> Thanks,
> Thiyagu
>
>
>
>