man > 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
Create sessions table	CREATE TABLE sessions (id CHAR(32) not null primary key, a_session TEXT) go	Minimum schema for session storage
Tie a session hash	tie %hash, 'Apache::Session::Sybase', $id, { DataSource => 'dbi:Sybase:database=db;server=server', UserName => 'user', Password => 'pass', Commit => 1 };	Connect to Sybase and create/restore a session
Pass an existing DBI handle	tie %hash, 'Apache::Session::Sybase', $id, { Handle => $dbh };	Use an already‑opened database connection
Enable auto‑commit	Commit => 1	Must be set when the module opens the handle itself; otherwise changes won’t be saved
Increase TEXT column size limit	textsize => 65536	Override the default max size (32K) for the IMAGE/TEXT column
Insert session data	$store->insert( $ref );	Create a new session record
Update session data	$store->update( $ref );	Modify an existing session record
Retrieve session data	$store->materialize( $ref );	Load the session hash from the database
Delete session data	$store->remove( $ref );	Remove the session record

📋 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-20 Apache::Session::Store::Sybase(3pm)

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