Re: Derby and 'public'

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Fri Aug 04 2006 - 09:29:28 EDT

  • Next message: Andrus Adamchik: "Re: m2 conversion"

    Hi Marcel,

    you should remove "public" schema from DataMap and all DbEntities in
    the model. I guess you ended up with it after reverse engineering
    from Postgres.

    Andrus

    On Aug 3, 2006, at 9:44 PM, Marcel wrote:

    >
    > Folks,
    >
    > I am finding that Derby is haemorrhaging because of the schema
    > designation of public in every line of SQL. Is there a way to work
    > around this?
    >
    > I am using Derby 10.1.3.1.
    >
    > Marcel
    >
    > -- from the modeler --
    > [SQL: DROP TABLE public.Painting] - Syntax error: Encountered
    > "public" at line 1, column 12.
    > [SQL: DROP TABLE public.Artist] - Syntax error: Encountered
    > "public" at line 1, column 12.
    > [SQL: DROP TABLE public.Gallery] - Syntax error: Encountered
    > "public" at line 1, column 12.
    > [SQL: DROP TABLE AUTO_PK_SUPPORT] - 'DROP TABLE' cannot be
    > performed on 'AUTO_PK_SUPPORT' because it does not exist.
    >
    > -- from ROP --
    > 4/08/2006 11:26:44 com.caucho.hessian.server.HessianSkeleton invoke
    > WARNING: SQL Exception: Syntax error: Encountered "public" at line
    > 1, column 70.
    > ERROR 42X01: Syntax error: Encountered "public" at line 1, column 70.
    >



    This archive was generated by hypermail 2.0.0 : Fri Aug 04 2006 - 09:29:52 EDT