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-10.1.2.1-bin\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.
ij>
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.
Thanks,
Joe Siebenmann
__________________________________________
Yahoo! DSL – Something to write home about.
Just $16.99/mo. or less.
dsl.yahoo.com