On Fri, 26 May 2000, Chetan Patil wrote:
> Hello,
> I have modified DBIStore.pm (in Apache-Session-1.03) to work with Oracle.
> I am attaching the diff at the end of this email for anyone who is
> interested.
Thanks for the effort!
>
> I just found out that there is new version of Apache-Session (1.51)
> available that shall work with Oracle out of the box.
>
> Oh well!! In case anyone cares, here is my setup
> Apache-Session-1.03
> DBD-Oracle-1.03
> DBI-1.13
> Digest-MD5-2.09
> Storable-0.6.11
>
> The "sessions" table setup is
>
> id char(16)
> length int(11)
> a_session BLOB
>
> Also, you would want to use
> LongReadLen => '2147483647'
> in the opts hash of example.perl (Apapche-Session-1.03).
Doing so gives DBD::Oracle free reign to malloc(2**31), which is likely to
be more memory than you really want to give to one process. Your sessions
are not likely to be that large, either, so you should use something more
sane like 2**16 or thereabouts.
Best,
Jeffrey
