On tir, 2005-12-06 at 22:33, Bernt M. Johnsen wrote:
Craig L Russell wrote (2005-12-06 10:31:57):
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 ).
For the
Lars Clausen wrote (2005-12-07 09:46:40):
On tir, 2005-12-06 at 22:33, Bernt M. Johnsen wrote:
Craig L Russell wrote (2005-12-06 10:31:57):
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
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
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-10.1.2.1-bin\data\NetMgt;create=true';
ij run 'c:\mgt\sql\tablex1
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,CraigOn Dec 6, 2005, at 10:06 AM, Joe Siebenmann wrote:Hi All,I'm trying to create my initial database tables using
Craig L Russell wrote (2005-12-06 10:31:57):
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 ).
For the record: VARCHAR without length is a non-standard feature