db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Samer Kanjo" <sa...@kanjo.net>
Subject RE: ij problem?
Date Tue, 06 Dec 2005 18:29:59 GMT
Perhaps you made a typo when you posted this but from what I see you did not
specify the length of the user_password field you simply indicated the
datatype VARCHAR.


-----Original Message-----
From: Joe Siebenmann [mailto:joes131@yahoo.com] 
Sent: Tuesday, December 06, 2005 12:07 PM
To: derby-user@db.apache.org
Subject: ij problem?

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