Hi Joe,

I think your problem is that VARCHAR needs a length, so the ")" in the "user_password VARCHAR)" (at position 161) was unexpected. It expected (20) before the closing ")".

Best,

Craig

On Dec 6, 2005, at 10:06 AM, Joe Siebenmann wrote:

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 


Craig Russell

Architect, Sun Java Enterprise System http://java.sun.com/products/jdo

408 276-5638 mailto:[EMAIL PROTECTED]

P.S. A good JDO? O, Gasp!


Attachment: smime.p7s
Description: S/MIME cryptographic signature

Reply via email to