Hi :)

In Firebird you have to define a column as NOT NULL in order to use it
as a primary key. The statement should also look like:
CREATE TABLE md_global_field_contents (
CONTENT VARCHAR(255),
ID INTEGER NOT NULL,
JDOCLASS VARCHAR(255),
JDOVERSION INTEGER,
PRIMARY KEY (ID)
)

I have no idea how you can tell KODO to do it, though...

Ciao
Luca

> Does anyone uses Firebird and KODO (the JDO implementation from
> SolarMetric)?
>
> We are trying to use Firebird 1.5 (WI-V1.5.0.4290) and KODO 3.0.3.
> But unfortunately the mapping tool exits with:
>
> kodo.util.FatalException: com.solarmetric.jdbc.ReportingSQLException:
> GDS Exception. 335544351. unsuccessful metadata update
> Column: ID not defined as NOT NULL - cannot be used in PRIMARY KEY
> constraint definition {stmnt 24446859: CREATE TABLE
> md_global_field_contents (CONTENT VARCHAR(255), ID INTEGER, JDOCLASS
> VARCHAR(255), JDOVERSION INTEGER, PRIMARY KEY (ID))} [code=335544351,
> state=HY000]
>
> Does anyone knows help?
>
> Regards,