Re: Derby and 'public'

From: Marcel (emmpeege..mail.com)
Date: Sat Aug 05 2006 - 02:54:13 EDT

  • Next message: Jean T. Anderson: "Re: Derby and 'public'"

    Thanks.

    Is Derby platform independent in its data storage? If I check in the
    database with the server, will it function properly on other platforms?

    Marcel

    Andrus Adamchik wrote:
    > 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 : Sat Aug 05 2006 - 02:54:47 EDT