Shared session with Oracle database

Knut Erik Helgesen knut.helgesen at bouvet.no
Wed Oct 14 06:52:46 EDT 2015


Hello,

We have a web application that uses Shibboleth for SSO. The application is running across two servers, with a load balancer in front.

We are planning to implement session sharing as described here: https://wiki.library.ucsf.edu/display/IAM/Configure+Shib+SP+on+a+Load+Balancing+Cluster

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?

Knut Erik Helgesen / 54° 26´41´´S 3° 22´51´´ E
Konsulent
Bouvet Norge AS, Solheimsgaten 15, NO-5058 Bergen
Mobil +47 958 43 609
http://www.bouvet.no<https://mail.bouvet.no/owa/redir.aspx?C=3f71f00c30ab41a9911256603bced326&URL=http%3a%2f%2fwww.bouvet.no%2f%3futm_source%3dSignatur%252Bno%26utm_medium%3dEpost%26utm_campaign%3dBouvet%252Bsignatur>    knut.helgesen at bouvet.no<mailto:knut.helgesen at bouvet.no>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shibboleth.net/pipermail/users/attachments/20151014/184506f3/attachment.html>


More information about the users mailing list