[ROL-1248] Execution of /build/webapp/WEB-INF/dbscripts/derby/createdb.sql was failed.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0
• Database: db-derby-10.1.3.1
• Assignee: David Johnson
• Reporter: Tomohito Nakayama
• Created: 27/Sep/06 14:15
• Updated: 05/Jan/13 20:46
• Resolved: 03/Oct/06 20:19

Description

I found next error was happend ...

ij> create table webpage (a
id varchar(48) not null primary key,
name varchar(255) not null,
description varchar(255),
link varchar(255),
websiteid varchar(48) not null,
template clob(102400) not null,
updatetime timestamp not null,
hidden smallint default 0 not null,
navbar smallint default 0 not null,
templatelang varchar(20) not null,
decorator varchar(255) null
);
ERROR 42X01: Syntax error: Encountered "null" at line 12, column 34.
ij> create index wp_name_idx on webpage( name );
ERROR 42Y55: 'CREATE INDEX' cannot be performed on 'WEBPAGE' because it does not exist.
ij> create index wp_link_idx on webpage( link );
ERROR 42Y55: 'CREATE INDEX' cannot be performed on 'WEBPAGE' because it does not exist.
ij> create index wp_id_idx on webpage( websiteid );
ERROR 42Y55: 'CREATE INDEX' cannot be performed on 'WEBPAGE' because it does not exist.

I'm not sure correct definition of webpage.decorator ....
At least , grammer of SQL in derby supports "not null" but does'nt "null" as Column-level-constraint ...
http://db.apache.org/derby/docs/10.1/ref/rrefsqlj16095.html#rrefsqlj16095