Shared session with Oracle database

Peter Schober peter.schober at univie.ac.at
Wed Oct 14 09:09:16 EDT 2015


* Knut Erik Helgesen <knut.helgesen at bouvet.no> [2015-10-14 12:53]:
> The guide includes SQL for MySQL, however, we are only able to use
> Oracle 11G databases. The table "texts" contains a column of type
> text, and this data type does not exist in Oracle. Suggested
> replacement is varchar2 or clob, and I assume clob will not work
> here? I found that MySQL text fields can store 64k of data, while
> varchar2 can be max 4k big.
> 
> Will the session sharing store so much data that the 4k limit on
> Oracle varchar2 fields will become a problem?

It't not clear to me from the official documentation (nor any of the
examples provided there) either:
https://wiki.shibboleth.net/confluence/display/SHIB2/NativeSPODBCStorageService
So either you figure it out based on the code or wait until Scott has
an authoritative answer for you.
-peter


More information about the users mailing list