The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.
 / 
CGI-Session-ODBC-0.1
River stage zero No dependents
++
/ CGI::Session::ODBC

NAME

CGI::Session::ODBC - ODBC driver for CGI::Session

SYNOPSIS

    use CGI::Session;
    $session = new CGI::Session("driver:ODBC", undef, { Handle => $dbh });

For more examples, consult the CGI::Session manual.

DESCRIPTION

CGI::Session::ODBC is a CGI::Session driver to store session data in any ODBC-capable database. To write your own drivers for CGI::Session, please refer to the CGI::Session manual.

STORAGE

To store session data in the ODBC-compliant database, you must first create a suitable table for your session data to live. In many instances, the following SQL will accomplish this:

    CREATE TABLE sessions (
        id CHAR(32) NOT NULL,
        a_session TEXT NOT NULL
    );

You can add any number of additional columns to the table, but the columns "id" and "a_session" are required as defined above. If you want to store the session data in a table other than "sessions", you will also need to specify the TableName attribute as an argument:

    use CGI::Session;

    $session = new CGI::Session("driver:ODBC", undef,
        { Handle => $dbh, TableName => 'my_sessions' });

There are no special provisions made for row-level locking. ODBC is intended to be platform independent, and to the best of the author's knowledge at the time of this writing, there is no platform independent manner of implementing row locking. Please contact the author with your experiences with this module in that regard.

COPYRIGHT

Copyright (C) 2003 by Jason A. Crome. All rights reserved.

This library is free software and can be modified and distributed under the same terms as Perl itself.

AUTHOR

Jason A. Crome <cromedome@cpan.org>, heavily based on the CGI::Session::PostgreSQL by Cosimo Streppone, which was heavily based on the CGI::Session::MySQL driver by Sherzod Ruzmetov, original author of CGI::Session.

SEE ALSO