From: hauke.luckow at gmail.com (Hauke Luckow)
Date: Thu, 8 May 2008 09:05:18 -0400
Subject: [Pljava-dev] Error during Adempiere data base import using PL/Java
Message-ID: <d5711a020805080605q67c923cbp97c1a7bcff410de5@mail.gmail.com>

Dear forum members,
I install Adempiere_340s.tar on the following system:

OpenSUSE 10.2 (32bit)
PostgreSQL 8.1.11 i586
Java-1-6-0-sun 1.6.0 i586
PL/Java package: pljava-i686-pc-linux-gnu-pg8.1-1.4.0

During import process of the Database dump I get the error messages below:

...
SET
psql:/usr/Adempiere/data/Adempiere_pg.dmp:6: ERROR:  Parameter
?standard_conforming_strings? cannot be changed
SET
SET
SET
CREATE SCHEMA
ALTER SCHEMA
COMMENT
CREATE SCHEMA
...
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
psql:/usr/Adempiere/data/Adempiere_pg.dmp:20648: ERROR:  Error
?Syntaxerror? by ?OWNED? at character 38
psql:/usr/Adempiere/data/Adempiere_pg.dmp:20648: LINE 1: ALTER
SEQUENCE jar_entry_entryid_seq OWNED BY jar_entry.entr...
psql:/usr/Adempiere/data/Adempiere_pg.dmp:20648:
                       ^
 setval
--------
     10
(1 row)

CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
psql:/usr/Adempiere/data/Adempiere_pg.dmp:20691: ERROR:  Error
?Syntaxerror? by ?OWNED? at character 41
psql:/usr/Adempiere/data/Adempiere_pg.dmp:20691: LINE 1: ALTER
SEQUENCE jar_repository_jarid_seq OWNED BY jar_reposit...
psql:/usr/Adempiere/data/Adempiere_pg.dmp:20691:
                          ^
 setval
--------
      1
(1 row)

CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
psql:/usr/Adempiere/data/Adempiere_pg.dmp:20732: ERROR:  Error
?Syntaxerror? by ?OWNED? at character 40
psql:/usr/Adempiere/data/Adempiere_pg.dmp:20732: LINE 1: ALTER
SEQUENCE typemap_entry_mapid_seq OWNED BY typemap_entr...
psql:/usr/Adempiere/data/Adempiere_pg.dmp:20732:
                         ^
 setval
--------
      1
(1 row)

ALTER TABLE
ALTER TABLE
...

Regarding the first error I have found inside the PostgreSQL 8.2.7
documentation the description below. Can anybody tell me where I can
make this parameter

changeable? I did'nt find it in the postgresql.conf.
Chapter 17. Server Configuration
17.12. Version and Platform Compatibility
17.12.1. Previous PostgreSQL Versions
standard_conforming_strings (boolean)
This controls whether ordinary string literals ('...') treat
backslashes literally, as specified in the SQL standard. The default
is currently off, causing

PostgreSQL to have its historical behavior of treating backslashes as
escape characters. The default will change to on in a future release
to improve

compatibility with the standard. Applications may check this parameter
to determine how string literals will be processed. The presence of
this parameter can

also be taken as an indication that the escape string syntax (E'...')
is supported. Escape string syntax should be used if an application
desires backslashes

to be treated as escape characters.


Regarding the other three errors I would appreciate if anybody can
tell me if its a problem either with my PL/Java installation or an
issue of Adempiere. Maybe somebody has also an idea how I can fix it
;o)
Thanks in advance,
Hawky