db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Witold Szczerba <pljosh.m...@gmail.com>
Subject Re: Boolean in version 10.9
Date Sun, 16 Dec 2012 16:07:12 GMT
The error message suggest your database, I mean database files, were
created using 10.5 version. If you were using database engine version
10.5 right now, where would it know about the Boolean in 10.7 version
from?
Upgrade the database or drop and create it from scratch.

Regards,
Witold Szczerba

On 15 December 2012 23:18, James B. Millard <jbm@jbmballistics.com> wrote:
> I've been using derby on windows for a few weeks and decided to move my
> development to Linux (Fedora 14).
>
> I have database creation scripts that I'm trying to run but I'm getting the
> following error:
>
> ij> CREATE TABLE COMPONENT_PROPERTIES
>         ( ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1,
> INCREMENT BY 1),
>           COMPONENT_CLASS       VARCHAR(48),
>           PROPERTY_SHORT_NAME   VARCHAR(48),
>           PROPERTY_LONG_NAME    VARCHAR(64),
>           PROPERTY_CLASS        VARCHAR(48),
>           PROPERTY_FORMAT_CLASS VARCHAR(48),
>           PROPERTY_FORMAT_DATA  VARCHAR(48),
>           PROPERTY_READ_ONLY    BOOLEAN,
>           PROPERTY_EDIT_CREATE  BOOLEAN,
>           PROPERTY_PERIOD       BOOLEAN,
>           PROPERTY_TO_DATE      BOOLEAN,
>           PROPERTY_DISPLAY      BOOLEAN,
>           PROPERTY_CATEGORY     VARCHAR(16) );
> ERROR XCL47: Use of 'BOOLEAN' requires database to be upgraded from version
> 10.5 to version 10.7 or later.
>
> This seems odd since I'm running 10.9 and these same scripts worked under
> Windows with the same version of derby.
>
> Here's what I see when I start ij:
>
> [jbm@hk sql]$ ij
> ij version 10.9
> ij>
>
>
> Thanks!
>
> Brad
>
>
>
>
>
> --
> View this message in context: http://apache-database.10148.n7.nabble.com/Boolean-in-version-10-9-tp125847.html
> Sent from the Apache Derby Users mailing list archive at Nabble.com.

Mime
View raw message