Re: swapping between hsqldb and Oracle: schema

From: Cris Daniluk (cris.danilu..mail.com)
Date: Wed Apr 13 2005 - 13:02:32 EDT

  • Next message: Fredrik Liden: "Performance Tuning in a Web App"

    If you're asking what I think you're asking - does hsqldb support
    namespace-style schemas, the answer is no.

    I never had a problem switching back and forth between Oracle and
    HSQLDB for generation though. I don't know that we explicitly list our
    schemas in the modeler, but the SQL that Cayenne executes for queries
    does include a schema reference...

    Cris

    On 4/13/05, Mike Kienenberger <mkienen..laska.net> wrote:
    > 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 - 13:02:36 EDT