Re: ij problem?

[Craig L Russell]

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!

smime.p7s
Description: S/MIME cryptographic signature