Derby and 'public'

From: Marcel (emmpeege..mail.com)
Date: Thu Aug 03 2006 - 21:44:53 EDT

  • Next message: Andrus Adamchik: "Re: Derby and 'public'"

    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 : Thu Aug 03 2006 - 21:45:26 EDT