时间戳

首页 > 解决方案 > HSQL 触发器：用户缺少权限或找不到对象：NEWROW.ID

scala - HSQL 触发器：用户缺少权限或找不到对象：NEWROW.ID

问题描述

我正在尝试在更新后在 hsql 中实现触发器，其中我有一个称为组件表的表，并且在该表中更新时我想使用插入触发器后将其记录到另一个表中，为此我正在做

CREATE TABLE IF NOT EXISTS "component"(
   "id" INTEGER IDENTITY,
   "name" VARCHAR(100),
   "configuration" LONGVARCHAR,
   "owner_id" INTEGER   );

CREATE TABLE IF NOT EXISTS "component_audit"(
   "id" INTEGER IDENTITY,
   "component_id" INTEGER ,
   "action" VARCHAR(20),
   "activity_time" BIGINT,
   "user_id" INTEGER,
   FOREIGN KEY ("component_id") REFERENCES "component"("id") ON UPDATE RESTRICT ON DELETE CASCADE
);

    CREATE TRIGGER trig AFTER INSERT ON "component"
       REFERENCING NEW ROW AS newrow
       FOR EACH ROW
       INSERT INTO "component_audit" ("id","component_id","action","activity_time","user_id")
       VALUES (DEFAULT, 1, newrow.id, 123, 1);

在运行 HSQL 时抛出错误

引起：org.hsqldb.HsqlException：用户缺少权限或找不到对象：NEWROW.ID

这是因为我的 id 列在“id”中，因为我需要它在小型大写字母中（默认 HSQLDB 是大写）我如何传递我的变量替换？

标签： scalatriggershsqldb

解决方案

只需使用与 CREATE TABLE 语句中相同的命名即可。

CREATE TRIGGER trig AFTER INSERT ON "component"
   REFERENCING NEW ROW AS newrow
   FOR EACH ROW
   INSERT INTO "component_audit" ("id","component_id","action","activity_time","user_id")
   VALUES (DEFAULT, 1, newrow."id", 123, 1);

推荐阅读