perldoc > Apache::Session::Store::Oracle

man perldoc info pydoc3 ri search

📛 NAME

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

🚀 Quick Reference

Use Case	Command	Description
Create a new store object	my $store = new Apache::Session::Store::Oracle;	Instantiate a new Oracle session store
Insert session data	$store->insert($ref);	Store a new session record
Update session data	$store->update($ref);	Update an existing session record
Materialize session data	$store->materialize($ref);	Read session data from the database
Remove session data	$store->remove($ref);	Delete a session record
Connect with DBI handle	tie %hash, 'Apache::Session::Oracle', $id, { Handle => $dbh };	Use an already-opened database handle
Set custom LongReadLen	tie %hash, 'Apache::Session::Oracle', $id, { LongReadLen => 65536 };	Override the default 8 KB session object size

🛠️ 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, UserName, and Password.

Example:

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

Instead, you may pass in an already-opened DBI handle to your database.

 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

📛 NAME 🚀 Quick Reference 🛠️ SYNOPSIS 📝 DESCRIPTION 🗄️ SCHEMA ⚙️ CONFIGURATION ✍️ AUTHOR 📚 SEE ALSO