"{ OJ " group outer joins in queries from OpenOffice.org?

From: Palle Girgensohn <girgen(at)pingpong(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: "{ OJ " group outer joins in queries from OpenOffice.org?
Date: 2003-11-13 03:50:46
Message-ID: 60510000.1068695446@palle.girgensohn.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-jdbc


This was discussed on the pgsql-sql list. Tom Lane asked if someone knows
about this, no answer at that list, so I guess I'll ask here:

OpeoOffice adds "{ OJ " .., "}" around outer joins. Apparently, as Tom
recalls, the ODBC standard expects this, since ODBC rephrases the query to
be compatible with different db servers. I don't think this construct
exists in JDBC? Anyone knows?

Two bug reports on OO.org with the same matter, only seem to involve
postgresql jdbc driver?


See (parts of) my original mail below:

>> Palle Girgensohn <girgen(at)pingpong(dot)net> writes:
>>> Here's their code snippet (from
>>> oo_1.1_src/dbaccess/source/ui/querydesign/QueryDesignView.cxx):
>>> if(aJoin.getLength())
>>> {
>>> ::rtl::OUString aStr = ::rtl::OUString::createFromAscii("{ OJ ");
>>> aStr += aJoin;
>>> aStr += ::rtl::OUString::createFromAscii(" },");
>>> aTableListStr += aStr;
>>> }
>> Now that I look at it, I bet that they are expecting the ODBC driver to
>> translate "{ OJ ... }" into the appropriate syntax for the database
>> (either SQL standard or not, depending on the DB :-().
>> There are a number of ODBC brace-constructs that our driver knows how to
>> translate, but I don't think that's one of them. You should bug the
>> ODBC guys about it.
>> regards, tom lane

Palle Girgensohn <girgen(at)pingpong(dot)net> writes:
> Hi!
> I just tried using openoffice to create a SQL query, but it failed when I
> tried using left outer joins. The contructed query from OO contains curly
> braces to group things. I've never seen this construct before. Is it OO
> doing bad things, or does postgresql not understand it? It's on pg-7.3.4.
> Perhaps 7.4 behaves differently?
> SELECT "personer"."foretag", "personer"."fnamn", "personer"."enamn",
> "befattningnamn"."namn" FROM { OJ "public"."befattning" "befattning"
> LEFT OUTER JOIN "public"."personer" "personer" ON
> "befattning"."personid" = "personer"."personid" }, "public"."kommentar"
> "kommentar", "public"."personer" "personer", "public"."befattning"
> "befattning", "public"."befattningnamn" "befattningnamn" WHERE 0 = 1
> ERROR: parser: parse error at or near "{" at character 100
> (The WHERE 0 = 1 seems to be OO's way of checking the query syntax.)
> Thanks
> Palle


Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2003-11-13 13:21:31 Re: "{ OJ " group outer joins in queries from
Previous Message Thomas Kellerer 2003-11-11 22:38:13 Re: JDBC for PostgreSQL 7.4