From torque-user-return-7969-apmail-db-torque-user-archive=db.apache.org@db.apache.org Sun Aug 24 12:24:11 2008 Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 36576 invoked from network); 24 Aug 2008 12:24:10 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 24 Aug 2008 12:24:10 -0000 Received: (qmail 20500 invoked by uid 500); 24 Aug 2008 12:24:08 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 20475 invoked by uid 500); 24 Aug 2008 12:24:08 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 20464 invoked by uid 99); 24 Aug 2008 12:24:08 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 24 Aug 2008 05:24:08 -0700 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [62.13.137.193] (HELO outmail137193.authsmtp.co.uk) (62.13.137.193) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 24 Aug 2008 12:23:09 +0000 Received: from mail-c189.authsmtp.com (mail-c189.authsmtp.com [62.13.128.71]) by punt6.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id m7OCNFVp075896 for ; Sun, 24 Aug 2008 13:23:15 +0100 (BST) Received: from [172.16.35.20] (p5B2B9498.dip0.t-ipconnect.de [91.43.148.152]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id m7OCNEkt053379 for ; Sun, 24 Aug 2008 12:23:14 GMT Message-ID: <48B152C0.5070208@apache.org> Date: Sun, 24 Aug 2008 14:23:28 +0200 From: Thomas Vandahl User-Agent: Thunderbird 2.0.0.16 (Macintosh/20080707) MIME-Version: 1.0 To: Apache Torque Users List Subject: Re: Does derby support still work? References: <48B024E1.701@sharp.fm> <48B02B81.1020505@apache.org> <48B0308C.2050407@sharp.fm> In-Reply-To: <48B0308C.2050407@sharp.fm> X-Enigmail-Version: 0.95.7 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Server-Quench: 6cd36c6e-71d7-11dd-bc7a-001f29070be2 X-AuthRoute: OCdyaAgQClZJUiwT EioPDCIGTh8qMAFL GwYeIE5HO1cTfQhb dE9CJ1FTPRsbX15P AWIUKhEDT19xWWtl aghbbwZXY04AVgR0 VEtXQ1ZaCgRtAwMD AwEeHER1CHY4DSU0 ZUNhXXdSEkV8cUQz RB0AFmtVYzJ9b2FL V11ZdlcAbVEZeU5Y alB+AnEEYWIHNC9i CTU+bXgdOjhEYChY WAscZUkPWV4MBCJ0 XAwDGTFnAkofRHJb X-Authentic-SMTP: 61633138303539.kestrel.dmpriest.net.uk:1186/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system! X-Virus-Checked: Checked by ClamAV on apache.org Graham Leggett wrote: > ij> CREATE TABLE active ( active_id INTEGER NOT NULL, serial VARCHAR NOT > NULL, name VARCHAR NOT NULL, description VARCHAR NOT NULL, signature_id > INTEGER NOT NULL, PRIMARY KEY(active_id), UNIQUE (serial)); > ERROR 42X01: Syntax error: Encountered "NOT" at line 1, column 66. I'm not exactly a Derby expert but in this case "serial" seems to be responsible. > ij> CREATE TABLE company ( company_id INTEGER NOT NULL, serial VARCHAR > NOT NULL, name VARCHAR NOT NULL, tradingas VARCHAR, registration_number > VARCHAR NOT NULL, vat_number VARCHAR, fsp_number VARCHAR, bank_account > VARCHAR, bank_sortcode VARCHAR, bank_name VARCHAR, bank_swift VARCHAR, > bank_reference VARCHAR, description VARCHAR, active_id INTEGER NOT NULL, > contact_id INTEGER NOT NULL, valid_from DATE, valid_to DATE, > signature_id INTEGER NOT NULL, PRIMARY KEY(company_id), UNIQUE (serial, > registration_number)); > ERROR 42X01: Syntax error: Encountered "NOT" at line 1, column 68. Same thing here. My guess: "serial" is a reserved word in Derby. Try to avoid reserved words as column names. Bye, Thomas. --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org