Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 42889 invoked from network); 1 Feb 2010 09:21:40 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 1 Feb 2010 09:21:40 -0000 Received: (qmail 5339 invoked by uid 500); 1 Feb 2010 09:21:39 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 5272 invoked by uid 500); 1 Feb 2010 09:21:38 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 5264 invoked by uid 99); 1 Feb 2010 09:21:38 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 01 Feb 2010 09:21:38 +0000 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=SPF_NEUTRAL,UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [69.147.102.67] (HELO smtp104.plus.mail.re1.yahoo.com) (69.147.102.67) by apache.org (qpsmtpd/0.29) with SMTP; Mon, 01 Feb 2010 09:21:29 +0000 Received: (qmail 16623 invoked from network); 1 Feb 2010 09:21:08 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.de; h=Received:X-Yahoo-SMTP:X-YMail-OSG:X-Yahoo-Newman-Property:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:Content-Type:Content-Transfer-Encoding; b=10hlt/GyiK5SqKc4IirwoB5FivmMzS9cEBEGRlhwLk5smYfkR10tAZYsLQ79UrF8dI1LUb1Rx6Irmygyqmk5CcQey5aFfP1Hz8xA56KffTOVe8tvFZxZ5c7aMr+UVtyX7xp0ZI1u7H3MUwk8KX8CWZRPE2FIJbPMXTEbj+nl8a8= ; Received: from mail2.novastor.com (fischauto333@217.110.73.186 with plain) by smtp104.plus.mail.re1.yahoo.com with SMTP; 01 Feb 2010 01:21:08 -0800 PST X-Yahoo-SMTP: ywe.z8GswBA1Y6P66WQH0I4wOLLZZQ1RpQ-- X-YMail-OSG: Z0_VaLIVM1m8ye5cgv.kVntC5EzjaB8PWnUhQmFNX76Frvzgn38v6Gv5f6sJ0zR4ZvpffLf4QRlGJoR4_0DuT.kvOkCJDUAakm8fIcCk7VhGTdvGEIbHi.ZRlDAQtForBDf5mjBY2kCgq1t5iTLmUSrLLi9XxktSQKrk4Mb1Cc.R90P6124xizYOqHtn5W2kyLpAZJQUkDEbzUdD17nzrYDOt3sI4z78yl3ZENCSh4phI2Lts8egn4byVKNcWfhxfxrftYcsVBAMuV6ffK7MXCtHJRw0sq4Bwx_2Qn59Rz9WBlnaxu0jbSZzVCs9qIOEUSCbsL4kZBKh5mUoyFlvCGTQ9lPts5ps5XI- X-Yahoo-Newman-Property: ymail-3 Message-ID: <4B669D03.5070202@yahoo.de> Date: Mon, 01 Feb 2010 10:21:07 +0100 From: joe User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; de; rv:1.9.1.7) Gecko/20100111 Thunderbird/3.0.1 MIME-Version: 1.0 To: derby-user@db.apache.org Subject: self referencing column Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit Hi, i have to persist a simple state machine. my problem is how to insert the first state which should reference itself. CREATE TABLE state ( ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1) constraint STATE_ID_PK primary key, NEXT_STATE_ID integer not null constraint STATE_NEYT_STATE_ID REFERENCES STATE ) insert into state values (default, default) doesn't work: "Column 'NEXT_STATE_ID' cannot accept a NULL value."