shibboleth-dev - Re: Testing ODBC store
Subject: Shibboleth Developers
List archive
- 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:
- Testing ODBC store, giacomo tenaglia, 12/06/2007
- RE: Testing ODBC store, Scott Cantor, 12/06/2007
- Re: Testing ODBC store, giacomo tenaglia, 12/14/2007
- RE: Testing ODBC store, Scott Cantor, 12/14/2007
- <Possible follow-up(s)>
- Re: Testing ODBC store, giacomo tenaglia, 12/08/2007
- RE: Testing ODBC store, Scott Cantor, 12/08/2007
- Re: Testing ODBC store, giacomo tenaglia, 12/10/2007
- RE: Testing ODBC store, Scott Cantor, 12/10/2007
- RE: Testing ODBC store, Scott Cantor, 12/10/2007
- Re: Testing ODBC store, giacomo tenaglia, 12/18/2007
Archive powered by MHonArc 2.6.16.