db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brandon Dohman" <B-Doh...@gotcg.net>
Subject problem creating table
Date Wed, 30 Apr 2008 20:54:56 GMT
I'm trying to create a new table in my database from within netbeans, and I keep receiving
this error
 
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.

 
Here is my code
 
CREATE TABLE "HMADMIN"."FILES"
(
"PATRON" BIGINT,
"PDFNAME" VARCHAR,
"PDFLOCATION" VARCHAR
) 
 
 
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.
 
Thanks

Mime
View raw message