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.
