Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 85028 invoked from network); 30 Apr 2008 20:56:01 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 30 Apr 2008 20:56:01 -0000 Received: (qmail 28708 invoked by uid 500); 30 Apr 2008 20:56:00 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 28689 invoked by uid 500); 30 Apr 2008 20:56:00 -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 28678 invoked by uid 99); 30 Apr 2008 20:56:00 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 30 Apr 2008 13:56:00 -0700 X-ASF-Spam-Status: No, hits=3.8 required=10.0 tests=HTML_MESSAGE,MIME_QP_LONG_LINE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [64.78.20.147] (HELO exsmtp012-1.exch012.intermedia.net) (64.78.20.147) by apache.org (qpsmtpd/0.29) with SMTP; Wed, 30 Apr 2008 20:55:07 +0000 Received: from EXVBE012-4.exch012.intermedia.net ([64.78.20.19]) by exsmtp012-1.exch012.intermedia.net with Microsoft SMTPSVC(6.0.3790.3959); Wed, 30 Apr 2008 13:55:27 -0700 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C8AB04.727F8F66" Subject: problem creating table Date: Wed, 30 Apr 2008 13:54:56 -0700 Message-ID: <00BB008AA995A046824528C48825FCF30906D563@EXVBE012-4.exch012.intermedia.net> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: problem creating table Thread-Index: AcirBHJPjyZHHqK1RQqSzPNl1JVI4Q== From: "Brandon Dohman" To: X-OriginalArrivalTime: 30 Apr 2008 20:55:27.0126 (UTC) FILETIME=[84800360:01C8AB04] X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. ------_=_NextPart_001_01C8AB04.727F8F66 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I'm trying to create a new table in my database from within netbeans, = and I keep receiving this error =20 Error code -1, SQL state 42X01: Syntax error: Encountered "," at line 4, = column 18. Line 1, column 1 Execution finished after 0 s, 1 error(s) occurred. =20 Here is my code =20 CREATE TABLE "HMADMIN"."FILES" ( "PATRON" BIGINT, "PDFNAME" VARCHAR, "PDFLOCATION" VARCHAR )=20 =20 =20 I'm using the netbeans gui table creation to create this table. I = haven't had problems with it before, and I'm not sure what is happening = with this. =20 Thanks ------_=_NextPart_001_01C8AB04.727F8F66 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable =0A= =0A= =0A= =0A=

I'm trying to create a = new table in my database from within netbeans, and I keep receiving this = error

=0A=

Error code -1, SQL state 42X01: Syntax error: Encountered "," at = line 4, column 18.
Line 1, column 1

=0A=

Execution finished after 0 s, 1 error(s) occurred.

=0A=

Here is my code

=0A=

CREATE TABLE "HMADMIN"."FILES"
(
"PATRON" = BIGINT,
"PDFNAME" VARCHAR,
"PDFLOCATION" VARCHAR
)=0A=

=0A=

I'm using the netbeans gui table creation to create this = table. I haven't had problems with it before, and I'm not sure = what is happening with this.

=0A=

Thanks

------_=_NextPart_001_01C8AB04.727F8F66--