Skip to Content.
Sympa Menu

shibboleth-dev - Re: Testing ODBC store

Subject: Shibboleth Developers

List archive

Re: Testing ODBC store


Chronological Thread 
  • From: giacomo tenaglia <>
  • To:
  • Subject: Re: Testing ODBC store
  • Date: Tue, 18 Dec 2007 10:52:30 +0100

On Fri, Dec 14, 2007 at 10:35:22AM -0500, Scott Cantor wrote:
> > - some data type adjustement to the storage creation sql:
> > datetime -> date, text -> clob (this because I dont't know what can be
> > the maximum size of the field "value" in table "texts", otherwise I'd
> > used varchar);
>
> The text type is used because those operations don't impose any size limits
> (beyond what's practical to store). Usually there's a "long text" type of
> some sort that isn't exactly a blob, but I'm not familiar with Oracle.
>
> Did you have to change code at all?

No, only the sql related to the table creation.

> > - tell shibd to use the environment vars needed by Oracle Instant Client
> > (ORACLE_HOME and TNS_ADMIN).
>
> Are there any other mechanisms for supplying that information? If it could
> be done programmatically somehow, we could work out some kind of secondary
> plugin model.

As far as I know this is the only method. Anyway no problem, it's only a
matter of modify the init script.

giacomo

--
giacomo tenaglia
Technical Student at CERN IT/DES-SIS
CNR Biblioteca d'Area di Bologna - http://biblio.bo.cnr.it
Phone +41 76 5003376 -
sip:



Archive powered by MHonArc 2.6.16.

Top of Page