Mailing-List: contact ddlutils-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ddlutils-dev@db.apache.org
Received-SPF: pass (asf.osuosl.org: domain of jta@bristowhill.com designates
 66.75.162.135 as permitted sender)
Message-ID: <4388C9D6.7040408@bristowhill.com>
Date: Sat, 26 Nov 2005 12:47:18 -0800
From: "Jean T. Anderson" <jta@bristowhill.com>
Reply-To: jta@bristowhill.com
User-Agent: Mozilla Thunderbird 1.0.2-1.3.2 (X11/20050324)
MIME-Version: 1.0
To: ddlutils-dev@db.apache.org
Subject: Suggestions for Derby description on DdlUtils web site
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Greetings, all,

Here are a couple corrections/suggestions for the Derby info on this page:

http://db.apache.org/ddlutils/database-support.html#Cloudscape%2FDerby

(1) A picky comment regarding this (feel free to ignore):

  "The Apache Derby project is based upon Cloudscape."

Actually, Cloudscape is based on Apache Derby.

Longer explanation: Apache Derby started off with a copy of the 
Cloudscape source code; but, moving forward, Cloudscape is based on the 
Apache Derby codeline.

(2) "The SQL syntax and datatypes supported by Derby are described in 
the Datatypes section in the Reference Manual". The link for the 
Reference Manual is broken:

http://incubator.apache.org/derby/manuals/reference/sqlj02.html#Reference+Manual

Either of these will get you to the Reference Manual (the first would 
allow accessing the Reference Manual for any release):

    http://db.apache.org/derby/manuals/index.html
    http://db.apache.org/derby/docs/dev/ref/

(3) "NULL is explicitly specified as default value" -- currently set to 
"no".

Maybe I'm misunderstanding what is meant.  You can explicitly specify a 
default of NULL:

ij> create table foo (bar int default NULL);
0 rows inserted/updated/deleted


(4) "Foreign key definitions embedded in table definition" -- currently 
set to "no", but Derby does support this. Here's an example from 
http://db.apache.org/derby/docs/dev/ref/rrefsqlj13590.html :

CREATE TABLE FLTAVAIL
	(
	FLIGHT_ID CHAR(6) NOT NULL,
	SEGMENT_NUMBER INT NOT NULL,
	FLIGHT_DATE DATE NOT NULL,
	ECONOMY_SEATS_TAKEN INT,
	BUSINESS_SEATS_TAKEN INT,
	FIRSTCLASS_SEATS_TAKEN INT,
	CONSTRAINT FLTAVAIL_PK PRIMARY KEY (FLIGHT_ID, SEGMENT_NUMBER),
	CONSTRAINT FLTS_FK
	FOREIGN KEY (FLIGHT_ID, SEGMENT_NUMBER)
	REFERENCES Flights (FLIGHT_ID, SEGMENT_NUMBER);

cheers,

  -jean