db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Craig L Russell <Craig.Russ...@Sun.COM>
Subject Re: ij problem?
Date Tue, 06 Dec 2005 18:31:57 GMT
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:Craig.Russell@sun.com
P.S. A good JDO? O, Gasp!


Mime
View raw message