info > Apache::Session::Store::Oracle

man perldoc info pydoc3 ri search

Apache::Session::Store::Oracle - Contributed Perl Documentation

PerlApache::Session::Store::Oracle(3pm)

📛 NAME

Apache::Session::Store::Oracle - Store persistent data in a Oracle database

🚀 Quick Reference

Use Case	Command	Description
🔧 Use the store module	use Apache::Session::Store::Oracle;	Load the Oracle session store module
🗄️ Create sessions table	CREATE TABLE sessions ( id varchar2(32) not null primary key, a_session long );	Schema required for session storage
🔑 Configure with credentials	tie %hash, 'Apache::Session::Oracle', $id, { DataSource => 'dbi:Oracle:database', UserName => 'user', Password => 'pass' };	Connect using datasource, username, password
🔗 Configure with DBI handle	tie %hash, 'Apache::Session::Oracle', $id, { Handle => $dbh };	Use an already-open database handle

📋 SYNOPSIS

use Apache::Session::Store::Oracle;

my $store = new Apache::Session::Store::Oracle;

$store->insert($ref);
$store->update($ref);
$store->materialize($ref);
$store->remove($ref);

📝 DESCRIPTION

Apache::Session::Store::Oracle fulfills the storage interface of Apache::Session. Session data is stored in a Oracle database.

🗄️ SCHEMA

To use this module, you will need at least these columns in a table called 'sessions':

• id varchar2(32) — or however long your session IDs are.
• a_session long

To create this schema, you can execute this command using the sqlplus program:

CREATE TABLE sessions (
   id varchar2(32) not null primary key,
   a_session long
);

If you use some other command, ensure that there is a unique index on the table's id column.

⚙️ CONFIGURATION

The module must know what datasource, username, and password to use when connecting to the database. These values can be set using the options hash (see Apache::Session documentation). The options are:

• 📦 DataSource — the DBI datasource string
• 👤 UserName — database username
• 🔑 Password — database password
• 🔗 Handle — an already-opened DBI database handle
• 📏 LongReadLen — maximum size of session object (default 8 KB)

Example with credentials:

tie %hash, 'Apache::Session::Oracle', $id, {
    DataSource => 'dbi:Oracle:database',
    UserName   => 'database_user',
    Password   => 'K00l'
};

Example with DBI handle:

tie %hash, 'Apache::Session::Oracle', $id, {
    Handle => $dbh
};

The last option is LongReadLen, which specifies the maximum size of the session object. If not supplied, the default maximum size is 8 KB.

👤 AUTHOR

This module was written by Jeffrey William Baker <jwbaker AT acm.org>

A fix for the commit policy was contributed by Michael Schout <mschout AT gkg.net>

🔗 SEE ALSO

Apache::Session, Apache::Session::Store::DBI

perl v5.30.3 2020-09-2Apache::Session::Store::Oracle(3pm)

📛 NAME 🚀 Quick Reference 📋 SYNOPSIS 📝 DESCRIPTION 🗄️ SCHEMA ⚙️ CONFIGURATION 👤 AUTHOR 🔗 SEE ALSO