Derby Database Data Types

I used netbeans 5.5 to create a data base on Derby, I executed a sql script to create tables and populate them on my database connection. Mostly it worked fine except I couldn't create 1 table

create table Matched

(

applicant varchar(16),

job varchar(16),

customer varchar(16),

exact BOOLEAN,

CONSTRAINT FK_Matched_job FOREIGN KEY (job,customer) REFERENCES Job(ref,customer),

CONSTRAINT FK_Matched_applicant FOREIGN KEY (applicant) REFERENCES Applicant(login)

);

which gives the following error

Error code -1, SQL state 42X01: Syntax error: BOOLEAN.

Are Boolean data types not supported on Derby databases or is there another type I should use? Bit, Int, Char?

[740 byte] By [paul_chanceya] at [2007-11-27 6:03:34]