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

Author

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

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).

Description

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

Name

       Apache::Session::Store::Sybase - Store persistent data 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

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 );