db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Joe Siebenmann <joes...@yahoo.com>
Subject ij problem?
Date Tue, 06 Dec 2005 18:06:56 GMT
Hi All,

I'm trying to create my initial database tables using ij.
here's what I get:

C:\>java -Dij.protocol=jdbc:derby: org.apache.derby.tools.ij
ij version 10.1
ij> connect 'c:\db-derby-\data\NetMgt;create=true';
ij> run 'c:\mgt\sql\tablex1.sql';
ij> CREATE TABLE users (user_id INTEGER PRIMARY KEY, first_name
VARCHAR(20), last_name VARCHAR(20), user_level INTEGER, user_name
VARCHAR(20), user_password VARCHAR);
ERROR 42X01: Syntax error: Encountered ")" at line 1, column 161.

Come on!  I can't find anything wrong with that, and I can't
find any more info on the error message in the docs.  In fact
it never mentions 'ERROR 42X01'..

No matter how I try to modify the SQL statement, it doesn't
like it.  I did find that if I manually type it in, and leave off
the last column, it doesn't complain..

I'm using:

C:\>java -version
java version "1.5.0"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0-b64)
Java HotSpot(TM) Client VM (build 1.5.0-b64, mixed mode)

And Windows XP.


Joe Siebenmann

Yahoo! DSL – Something to write home about. 
Just $16.99/mo. or less. 

View raw message