Skip to Content.
Sympa Menu

grouper-users - RE: [grouper-users] Oracle Incompatibility

Subject: Grouper Users - Open Discussion List

List archive

RE: [grouper-users] Oracle Incompatibility

Chronological Thread 
  • From: "Hyzer, Chris" <>
  • To: Oliver Trieu <>, Grouper-Users <>
  • Subject: RE: [grouper-users] Oracle Incompatibility
  • Date: Thu, 23 Apr 2020 09:33:31 +0000
  • Arc-authentication-results: i=1; 1; spf=pass; dmarc=pass action=none; dkim=pass; arc=none
  • Arc-message-signature: i=1; a=rsa-sha256; c=relaxed/relaxed;; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=KtydbWT1qRQy3PaktfsmO8OsCXdrJkQLW6il6LMDydE=; b=lkPrROZVASS5unJWwSrPAcVGHQGs2tcW0PGPq+WRvJEeyrMwrzjjkV7sBFdlChNWGYh7CO04vuZ2ZUHhdwBL7+dn4lcG9ZWI9iI6AQZbbwv/9yeNzTMX/b4Fp9Oi9w5pxKCZIJlBEnT49R9m9qah4msudEiwWmv266N14UQXPY72mqzeb1pNzgfbXVYgu7uVag/mgveUCbOWCiqzTicSWvAn4aEcMeLq/bymxOk7wnu4p3DjmmKKuZBccjDZs1BeX08SOLwnwu/b6yOHKNcRUFrFKKg9O2FkddN9aRYjAQxyHtg0WDHS7jgMc/qkZNLAgzZ9A4whoFl1zuAVXjZ+vA==
  • Arc-seal: i=1; a=rsa-sha256; s=arcselector9901;; cv=none; b=AB/OhlGzjkodqTCOUHlVpZANCFy9oddnM+nhnRk3UTdmc3cdgpI/+C87mivZ65IjuSMsTNawLm+5TQQO7k3iGddHC6NST0G5LgiN0j9eHk5SwD1Sz2qWPzrKNaJH7wxbjdIIVWDcyvxL+aBK0olRllaa26TeUQ5nGJ8RU8CKCvHOqebSx7A0sGJ+30oBqjmxaH+MXFib1gS2XwxrTPubufaiDQ+LJ8btW6QyOfax30rWC1aJLVYBPphjTMhQlrL8/cpexsbI87sueq37WkT2HWj9P39CSFtWzvwJFMUSHs9mkCBNIhcEjTl8nUJ4DAamAvgNkmrIo5C9tOz060sJhg==

Is this working for you now? It should be fixed as of 2.5.23 if not prior


-----Original Message-----
From: On Behalf Of Oliver Trieu
Sent: Wednesday, January 08, 2020 9:59 AM
To: Grouper-Users <>
Subject: [grouper-users] Oracle Incompatibility

Dear fellow Grouper Users,

We are using Oracle 11.2 to run grouper and the newest version is no
longer working.

The problem was introduced in this commit:

In the as seen here:

    sql = sql.replace("{inclause}", "1=1");
    sql = "select " + this.subjectIDAttributeName + " from ( " + sql +
" ) as subjects";

The "as subjects" is not correct oracle SQL syntax, removing the "as"
does the trick for oracle.

Kind Regards

Oliver Trieu

Oliver Trieu
Managed Services
Server and Data Management

Universität Wien
Zentraler Informatikdienst
Universitätsstrasse 7, 1010 Wien

T +43-1-4277-14161
M: +43-664-60277-14161

  • RE: [grouper-users] Oracle Incompatibility, Hyzer, Chris, 04/23/2020

Archive powered by MHonArc 2.6.19.

Top of Page