db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendleton.de...@gmail.com>
Subject Re: [jira] [Commented] (DERBY-6783) WHEN clause in CREATE TRIGGER for UPDATE is not working for the sql script below
Date Sat, 06 Jun 2015 18:08:05 GMT
> Though I noticed when I clean and apply the correct patch, the build fails while running
build_toursdb.sql
> I'm trying to fix it and I'm attaching this patch as well.

Hi Abhinav,

No need to be sorry!

Thanks for the updated patch. I am able to apply it, and I see the
same problem you do; the build fails while building toursdb.

The place to look for more information about this is:

	derby\trunk\generated\toursdb\toursdb.out

When I look in that file, I see that it is trying to create triggers,
and failing:

CREATE TRIGGER TRIG1 AFTER UPDATE ON FLIGHTS REFERENCING OLD AS UPDATEDROW FOR E
ACH ROW INSERT INTO FLIGHTS_HISTORY VALUES (UPDATEDROW.FLIGHT_ID, UPDATEDROW.SEG
MENT_NUMBER, UPDATEDROW.ORIG_AIRPORT,UPDATEDROW.DEPART_TIME, UPDATEDROW.DEST_AIR
PORT,UPDATEDROW.ARRIVE_TIME,UPDATEDROW.MEAL, UPDATEDROW.FLYING_TIME, UPDATEDROW.
MILES, UPDATEDROW.AIRCRAFT,'INSERTED FROM TRIG1');
ERROR XJ001: Java exception: '10: java.lang.ArrayIndexOutOfBoundsException'.

Hopefully the information in toursdb.out is enough for you to set up a
simple standalone test case in 'ij' that can reproduce the ArrayIndexOutOfBoundsException
and then you can learn where your code is having a problem.

thanks,

bryan



Mime
View raw message