grouper-users - [grouper-users] Oracle Incompatibility
Subject: Grouper Users - Open Discussion List
List archive
- From: Oliver Trieu <>
- To: Grouper-Users <>
- Subject: [grouper-users] Oracle Incompatibility
- Date: Wed, 8 Jan 2020 15:59:06 +0100
- Organization: University of Vienna
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
- [grouper-users] Oracle Incompatibility, Oliver Trieu, 01/08/2020
Archive powered by MHonArc 2.6.19.