[
https://issues.apache.org/jira/browse/DERBY-4404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Knut Anders Hatlen reopened DERBY-4404:
---------------------------------------
> Creating trigger throws error in embedded derby
> -----------------------------------------------
>
> Key: DERBY-4404
> URL: https://issues.apache.org/jira/browse/DERBY-4404
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.5.1.1
> Environment: Ubuntu 8.04 (GNU/Linux), IcedTea6
> Reporter: A Hunt
>
> Trying to create a trigger throws an error on embedded Derby, the same
> trigger can be created fine using ij. When trying to create the trigger, the
> error thrown states:
> Syntax error: Encountered "NEW" at line 1, column 69.
> The trigger statement used:
> CREATE TRIGGER trig_dGroup1 AFTER INSERT ON groups
> REFERENCING NEW AS mod
> FOR EACH ROW MODE DB2SQL
> UPDATE groups SET isDefault = 0 WHERE (isDefault = 1) AND ((NOT (id =
> mod.id)) AND (mod.isDefault = 1))
> I have created the database beforehand and set up the table groups using:
> connect 'jdbc:derby:MyDbTest;create=true';
> (con = DriverManager.getConnection(connectionURL) for the embedded program)
> Then I run the statement:
> CREATE TABLE groups (
> id INT NOT NULL GENERATED ALWAYS AS IDENTITY CONSTRAINT WISH_PK PRIMARY
> KEY,
> name VARCHAR(32) NOT NULL,
> description VARCHAR(64),
> colour INT NOT NULL,
> isDefault INT NOT NULL,
> isPermanent INT NOT NULL
> )
> In java the statements are run using s.execute(methodLoadingScriptFromFile());
> I have also tried setting up a new statement for the running of the trigger
> creation statement, which didn't help.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
