grouper-users - RE: [grouper-users] Oracle Incompatibility
Subject: Grouper Users - Open Discussion List
List archive
- 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; mx.microsoft.com 1; spf=pass smtp.mailfrom=isc.upenn.edu; dmarc=pass action=none header.from=isc.upenn.edu; dkim=pass header.d=isc.upenn.edu; arc=none
- Arc-message-signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; 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; d=microsoft.com; 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
Thanks
Chris
-----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:
https://github.com/Internet2/grouper/commit/1bbc27a8b0524473ab5a1c211bf4147c9c4f497d
In the JDBCSourceAdapter.java as seen here:
https://github.com/Internet2/grouper/commit/1bbc27a8b0524473ab5a1c211bf4147c9c4f497d#diff-dafaf671ae55a4efd775af240f00e06c
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
zid.univie.ac.at
- RE: [grouper-users] Oracle Incompatibility, Hyzer, Chris, 04/23/2020
Archive powered by MHonArc 2.6.19.