# Apache::Session::Store::Informix - Store persistent data in a Informix ... - perldoc - [phpMan]

## NAME
    [Apache::Session::Store::Informix](https://www.chedong.com/phpMan.php/perldoc/Apache%3A%3ASession%3A%3AStore%3A%3AInformix/markdown) - Store persistent data in a Informix database

## SYNOPSIS
     use [Apache::Session::Store::Informix](https://www.chedong.com/phpMan.php/perldoc/Apache%3A%3ASession%3A%3AStore%3A%3AInformix/markdown);

     my $store = new [Apache::Session::Store::Informix](https://www.chedong.com/phpMan.php/perldoc/Apache%3A%3ASession%3A%3AStore%3A%3AInformix/markdown);

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

## DESCRIPTION
    [Apache::Session::Store::Informix](https://www.chedong.com/phpMan.php/perldoc/Apache%3A%3ASession%3A%3AStore%3A%3AInformix/markdown) fulfills the storage interface of [Apache::Session](https://www.chedong.com/phpMan.php/perldoc/Apache%3A%3ASession/markdown). Session data
    is stored in a Informix database.

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

     id [char(32)](https://www.chedong.com/phpMan.php/man/char/32/markdown)     # or however long your session IDs are.
     a_session lvarchar

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

     CREATE TABLE sessions (
        id [char(32)](https://www.chedong.com/phpMan.php/man/char/32/markdown) not null primary key,
        a_session lvarchar
     );

    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](https://www.chedong.com/phpMan.php/perldoc/Apache%3A%3ASession/markdown) documentation).
    The options are DataSource, UserName, and Password.

    Example:

     tie %hash, '[Apache::Session::Informix](https://www.chedong.com/phpMan.php/perldoc/Apache%3A%3ASession%3A%3AInformix/markdown)', $id, {
         DataSource => 'dbi:Informix:database',
         UserName   => 'database_user',
         Password   => 'K00l'
     };

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

     tie %hash, '[Apache::Session::Informix](https://www.chedong.com/phpMan.php/perldoc/Apache%3A%3ASession%3A%3AInformix/markdown)', $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 Mike Langen <<mike.langen@tamedia.ch>>, based on the original for
    Oracle.

## SEE ALSO
    [Apache::Session](https://www.chedong.com/phpMan.php/perldoc/Apache%3A%3ASession/markdown), [Apache::Session::Store::DBI](https://www.chedong.com/phpMan.php/perldoc/Apache%3A%3ASession%3A%3AStore%3A%3ADBI/markdown)