info > Apache::Session::Store::Sybase

man perldoc info pydoc3 ri search

📝 NAME

Apache::Session::Store::Sybase — Store persistent data in a Sybase database

🚀 Quick Reference

Use Case	Command	Description
Tie session hash with datasource	tie %hash, 'Apache::Session::Sybase', $id, { DataSource => '...', UserName => '...', Password => '...', Commit => 1 };	Create session storage with explicit database connection
Tie session hash with existing DBI handle	tie %hash, 'Apache::Session::Sybase', $id, { Handle => $dbh };	Use an already-opened database handle
Insert session data	$store->insert( $ref );	Store a new session record
Update session data	$store->update( $ref );	Modify an existing session
Retrieve session data	$store->materialize( $ref );	Load session from database
Delete session data	$store->remove( $ref );	Remove a session from database

🔧 SYNOPSIS

use Apache::Session::Store::Sybase;

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

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

📖 DESCRIPTION

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

🗄️ SCHEMA

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

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

To create this schema, you can execute this command using the isql or sqsh programs:

CREATE TABLE sessions (
   id         CHAR(32) not null primary key,
   a_session  TEXT
)
go

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

⚙️ 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
• Password

Example:

tie %hash, 'Apache::Session::Sybase', $id, {
    DataSource => 'dbi:Sybase:database=db;server=server',
    UserName   => 'database_user',
    Password   => 'K00l',
    Commit     => 1,
};

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

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

Additional arguments you can pass to the backing store are:

• Commit — whether we should commit any changes; if you pass in an already-open database handle that has AutoCommit set to a true value, you do not need to set this. If you let Apache::Session::Store::Sybase create your database handle, you must set this to a true value, otherwise your changes will not be saved.
• textsize — the value we should pass to the set textsize command that sets the max size of the IMAGE field. Default is 32K (at least in Sybase ASE 11.9.2).

👤 AUTHOR

This module was based on Apache::Session::Store::Oracle which was written by Jeffrey William Baker <jwbaker AT acm.org>; it was modified by Chris Winters <chris AT cwinters.com> to work with Apache::Session 1.5+ with changes from earlier version of Apache::Session::DBI::Sybase from Mark Landry <mdlandry AT lincoln.com>.

📚 SEE ALSO

Apache::Session

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

📝 NAME 🚀 Quick Reference 🔧 SYNOPSIS 📖 DESCRIPTION 🗄️ SCHEMA ⚙️ CONFIGURATION 👤 AUTHOR 📚 SEE ALSO