HSQLDB Trigger issue (newbie)

--===============0986227092440425604==
Content-Type: multipart/alternative; boundary="000000000000a0188f05deed9e69"

--000000000000a0188f05deed9e69
Content-Type: text/plain; charset="UTF-8"

 Hello
Using: HSQLDB 2.6.1
I am trying to create a trigger such that when a row is changed, regardless
of the client, the table "Modified" field to updated with current
timestamp.  I am a newbie in this area.
Below is the table definition and the trigger specification.  My test
results in the SQLTool session "hanging" for a short while (~30 seconds)
and then a General error is reported.
Can someone advise what I am doing wrong?  Might this be a row lock issue?
Thanks
Andrew Richardson

sql> \d PUBLIC."WaterfrontReservations"
NAME          DATATYPE   WIDTH  NO-NULLS  PRECISION  SCALE
------------  ---------  -----  --------  ---------  -----
ID            INTEGER       11  *                32
CustomerID    INTEGER       11  *                32
Notes         VARCHAR      128                  128
ResDate       DATE          10                   10
NumPeople     TINYINT        4                    8
NumKayaks     TINYINT        4                    8
NumDblKayaks  TINYINT        4                    8
NumCanoes     TINYINT        4                    8
NumSUPs       TINYINT        4                    8
NumTubes      TINYINT        4                    8
NumDblTubes   TINYINT        4                    8
NumCoolers    TINYINT        4                    8
NumDingys     TINYINT        4                    8
PutIn         VARCHAR      100                  100
TakeOut       VARCHAR      100                  100
LocalInfo     VARCHAR      100                  100
LocalPhone    VARCHAR      100                  100
TripDate      DATE          10  *                10
TripTime      TIME           8  *                 8
NumCChairs    TINYINT        4                    8
NumPaddles    TINYINT        4                    8
NumPFDs       TINYINT        4                    8
NumDays       TINYINT        4                    8
BookType      VARCHAR       12                   12
Cancelled     BOOLEAN        5
OfficeNotes   VARCHAR      128                  128
Modified      TIMESTAMP     26                   26      6

sql> CREATE TRIGGER "WaterResUpdMod" AFTER UPDATE ON
PUBLIC."WaterfrontReservations"
   REFERENCING NEW ROW AS newrow
   FOR EACH ROW
   UPDATE PUBLIC."WaterfrontReservations" SET "Modified" = NOW();

***TEST***
sql> UPDATE PUBLIC."WaterfrontReservations" SET "CustomerID" = 5289 where
ID = 4234;
SEVERE  SQL Error at '<stdin>' line 60:
"UPDATE PUBLIC."WaterfrontReservations" SET "CustomerID" = 5289 where ID =
4234"
General error

--000000000000a0188f05deed9e69
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: base64

PGRpdiBkaXI9Imx0ciI+DQo8ZGl2PjxkaXY+PGRpdj48ZGl2IGlkPSJtXzcwMzExOTUyMDcyNTc0
NjYxODBnbWFpbC06MXBoIj48ZGl2IGlkPSJtXzcwMzExOTUyMDcyNTc0NjYxODBnbWFpbC06MXBn
Ij48ZGl2IGRpcj0ibHRyIj48ZGl2PkhlbGxvPC9kaXY+PGRpdj5Vc2luZzogSFNRTERCIDIuNi4x
PGJyPjwvZGl2PjxkaXY+SQ0KIGFtIHRyeWluZyB0byBjcmVhdGUgYSB0cmlnZ2VyIHN1Y2ggdGhh
dCB3aGVuIGEgcm93IGlzIGNoYW5nZWQsIA0KcmVnYXJkbGVzcyBvZiB0aGUgY2xpZW50LCB0aGUg
dGFibGUgJnF1b3Q7TW9kaWZpZWQmcXVvdDsgZmllbGQgdG8gdXBkYXRlZCB3aXRoIA0KY3VycmVu
dCB0aW1lc3RhbXAuwqAgSSBhbSBhIG5ld2JpZSBpbiB0aGlzIGFyZWEuPGJyPjwvZGl2PjxkaXY+
QmVsb3cgaXMgDQp0aGUgdGFibGUgZGVmaW5pdGlvbiBhbmQgdGhlIHRyaWdnZXIgc3BlY2lmaWNh
dGlvbi7CoCBNeSB0ZXN0IHJlc3VsdHMgaW4gDQp0aGUgU1FMVG9vbCBzZXNzaW9uICZxdW90O2hh
bmdpbmcmcXVvdDsgZm9yIGEgc2hvcnQgd2hpbGUgKH4zMCBzZWNvbmRzKSBhbmQgdGhlbiBhDQog
R2VuZXJhbCBlcnJvciBpcyByZXBvcnRlZC48L2Rpdj48ZGl2PkNhbiBzb21lb25lIGFkdmlzZSB3
aGF0IEkgYW0gZG9pbmcgd3Jvbmc/wqAgTWlnaHQgdGhpcyBiZSBhIHJvdyBsb2NrIGlzc3VlPzwv
ZGl2PjxkaXY+VGhhbmtzPC9kaXY+PGRpdj5BbmRyZXcgUmljaGFyZHNvbjxicj48L2Rpdj48ZGl2
Pjxicj48L2Rpdj48ZGl2PjxzcGFuIHN0eWxlPSJmb250LWZhbWlseTptb25vc3BhY2UiPnNxbCZn
dDsgXGQgUFVCTElDLiZxdW90O1dhdGVyZnJvbnRSZXNlcnZhdGlvbnMmcXVvdDs8YnI+TkFNRSDC
oCDCoCDCoCDCoCDCoERBVEFUWVBFIMKgIFdJRFRIIMKgTk8tTlVMTFMgwqBQUkVDSVNJT04gwqBT
Q0FMRTxicj4tLS0tLS0tLS0tLS0gwqAtLS0tLS0tLS0gwqAtLS0tLSDCoC0tLS0tLS0tIMKgLS0t
LS0tLS0tIMKgLS0tLS08YnI+SUQgwqAgwqAgwqAgwqAgwqAgwqBJTlRFR0VSIMKgIMKgIMKgIDEx
IMKgKiDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoDMyPGJyPkN1c3RvbWVySUQgwqAgwqBJTlRFR0VS
IMKgIMKgIMKgIDExIMKgKiDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoDMyPGJyPk5vdGVzIMKgIMKg
IMKgIMKgIFZBUkNIQVIgwqAgwqAgwqAxMjggwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAxMjg8
YnI+UmVzRGF0ZSDCoCDCoCDCoCBEQVRFIMKgIMKgIMKgIMKgIMKgMTAgwqAgwqAgwqAgwqAgwqAg
wqAgwqAgwqAgwqAgMTA8YnI+TnVtUGVvcGxlIMKgIMKgIFRJTllJTlQgwqAgwqAgwqAgwqA0IMKg
IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgODxicj5OdW1LYXlha3MgwqAgwqAgVElOWUlOVCDC
oCDCoCDCoCDCoDQgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqA4PGJyPk51bURibEtheWFr
cyDCoFRJTllJTlQgwqAgwqAgwqAgwqA0IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgODxi
cj5OdW1DYW5vZXMgwqAgwqAgVElOWUlOVCDCoCDCoCDCoCDCoDQgwqAgwqAgwqAgwqAgwqAgwqAg
wqAgwqAgwqAgwqA4PGJyPk51bVNVUHMgwqAgwqAgwqAgVElOWUlOVCDCoCDCoCDCoCDCoDQgwqAg
wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqA4PGJyPk51bVR1YmVzIMKgIMKgIMKgVElOWUlOVCDC
oCDCoCDCoCDCoDQgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqA4PGJyPk51bURibFR1YmVz
IMKgIFRJTllJTlQgwqAgwqAgwqAgwqA0IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgODxi
cj5OdW1Db29sZXJzIMKgIMKgVElOWUlOVCDCoCDCoCDCoCDCoDQgwqAgwqAgwqAgwqAgwqAgwqAg
wqAgwqAgwqAgwqA4PGJyPk51bURpbmd5cyDCoCDCoCBUSU5ZSU5UIMKgIMKgIMKgIMKgNCDCoCDC
oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoDg8YnI+UHV0SW4gwqAgwqAgwqAgwqAgVkFSQ0hBUiDC
oCDCoCDCoDEwMCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoDEwMDxicj5UYWtlT3V0IMKgIMKg
IMKgIFZBUkNIQVIgwqAgwqAgwqAxMDAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAxMDA8YnI+
TG9jYWxJbmZvIMKgIMKgIFZBUkNIQVIgwqAgwqAgwqAxMDAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg
wqAgwqAxMDA8YnI+TG9jYWxQaG9uZSDCoCDCoFZBUkNIQVIgwqAgwqAgwqAxMDAgwqAgwqAgwqAg
wqAgwqAgwqAgwqAgwqAgwqAxMDA8YnI+VHJpcERhdGUgwqAgwqAgwqBEQVRFIMKgIMKgIMKgIMKg
IMKgMTAgwqAqIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgMTA8YnI+VHJpcFRpbWUgwqAgwqAgwqBU
SU1FIMKgIMKgIMKgIMKgIMKgIDggwqAqIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIDg8YnI+TnVt
Q0NoYWlycyDCoCDCoFRJTllJTlQgwqAgwqAgwqAgwqA0IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg
IMKgIMKgODxicj5OdW1QYWRkbGVzIMKgIMKgVElOWUlOVCDCoCDCoCDCoCDCoDQgwqAgwqAgwqAg
wqAgwqAgwqAgwqAgwqAgwqAgwqA4PGJyPk51bVBGRHMgwqAgwqAgwqAgVElOWUlOVCDCoCDCoCDC
oCDCoDQgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqA4PGJyPk51bURheXMgwqAgwqAgwqAg
VElOWUlOVCDCoCDCoCDCoCDCoDQgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqA4PGJyPkJv
b2tUeXBlIMKgIMKgIMKgVkFSQ0hBUiDCoCDCoCDCoCAxMiDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC
oCDCoCAxMjxicj5DYW5jZWxsZWQgwqAgwqAgQk9PTEVBTiDCoCDCoCDCoCDCoDU8YnI+T2ZmaWNl
Tm90ZXMgwqAgVkFSQ0hBUiDCoCDCoCDCoDEyOCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoDEy
ODxicj5Nb2RpZmllZCDCoCDCoCDCoFRJTUVTVEFNUCDCoCDCoCAyNiDCoCDCoCDCoCDCoCDCoCDC
oCDCoCDCoCDCoCAyNiDCoCDCoCDCoDY8L3NwYW4+PC9kaXY+PGRpdj48c3BhbiBzdHlsZT0iZm9u
dC1mYW1pbHk6bW9ub3NwYWNlIj48YnI+PC9zcGFuPjwvZGl2PjxkaXY+PHNwYW4gc3R5bGU9ImZv
bnQtZmFtaWx5Om1vbm9zcGFjZSI+c3FsJmd0OyBDUkVBVEUgVFJJR0dFUiAmcXVvdDtXYXRlclJl
c1VwZE1vZCZxdW90OyBBRlRFUiBVUERBVEUgT04gUFVCTElDLiZxdW90O1dhdGVyZnJvbnRSZXNl
cnZhdGlvbnMmcXVvdDs8YnI+wqAgwqBSRUZFUkVOQ0lORyBORVcgUk9XIEFTIG5ld3Jvdzxicj7C
oCDCoEZPUiBFQUNIIFJPVzxicj7CoCDCoFVQREFURSBQVUJMSUMuJnF1b3Q7V2F0ZXJmcm9udFJl
c2VydmF0aW9ucyZxdW90OyBTRVQgJnF1b3Q7TW9kaWZpZWQmcXVvdDsgPSBOT1coKTs8YnI+PC9z
cGFuPjwvZGl2PjxkaXY+PHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5Om1vbm9zcGFjZSI+PGJyPjwv
c3Bhbj48L2Rpdj48ZGl2PjxzcGFuIHN0eWxlPSJmb250LWZhbWlseTptb25vc3BhY2UiPioqKlRF
U1QqKio8YnI+PC9zcGFuPjwvZGl2PjxkaXY+PHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5Om1vbm9z
cGFjZSI+c3FsJmd0OyBVUERBVEUgUFVCTElDLiZxdW90O1dhdGVyZnJvbnRSZXNlcnZhdGlvbnMm
cXVvdDsgU0VUICZxdW90O0N1c3RvbWVySUQmcXVvdDsgPSA1Mjg5IHdoZXJlIElEID0gNDIzNDs8
YnI+U0VWRVJFIMKgU1FMIEVycm9yIGF0ICYjMzk7Jmx0O3N0ZGluJmd0OyYjMzk7IGxpbmUgNjA6
PGJyPiZxdW90O1VQREFURSBQVUJMSUMuJnF1b3Q7V2F0ZXJmcm9udFJlc2VydmF0aW9ucyZxdW90
OyBTRVQgJnF1b3Q7Q3VzdG9tZXJJRCZxdW90OyA9IDUyODkgd2hlcmUgSUQgPSA0MjM0JnF1b3Q7
PGJyPkdlbmVyYWwgZXJyb3I8ZGl2PjwvZGl2Pjwvc3Bhbj48YnI+PC9kaXY+PC9kaXY+PC9kaXY+
PC9kaXY+PC9kaXY+PC9kaXY+PC9kaXY+PC9kaXY+DQo=
--000000000000a0188f05deed9e69--


--===============0986227092440425604==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline


--===============0986227092440425604==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

--===============0986227092440425604==--