swapping between hsqldb and Oracle: schema

From: Mike Kienenberger (mkienen..laska.net)
Date: Wed Apr 13 2005 - 12:33:55 EDT

  • Next message: Cris Daniluk: "Re: swapping between hsqldb and Oracle: schema"

    I've set up a new project that I need to swap back and forth between Oracle
    and hsqldb.

    My problem is that I need to specify the "Db schema" (ENG_WORK_MGMT) for my
    map for Oracle.

    However, that seems to break my modeler schema generation for hsqldb.

    Is db schema unsupported by the hsqldb engine? It seems like a problem just
    with generating a schema from the modeler, but I can't seem to find any
    documentation on schemas and hsqldb, and my own knowledge of "schema" in the
    oracle sense is weak.

    Thanks.

    -Mike

    [SQL: CREATE CACHED TABLE ENG_WORK_MGMT.ACTIVITY_TYPE_CATEGORY
    (ACTIVITY_TYPE_CATEGORY_ID NUMERIC NOT NULL, CATEGORY_NAME VARCHAR(64) NULL,
    PRIMARY KEY (ACTIVITY_TYPE_CATEGORY_ID))] - Unexpected token:
    ACTIVITY_TYPE_CATEGORY in statement [CREATE CACHED TABLE
    ENG_WORK_MGMT.ACTIVITY_TYPE_CATEGORY]

    This archive was generated by hypermail 2.0.0 : Wed Apr 13 2005 - 12:32:24 EDT