DBD::SQLRelay - perl DBI driver for SQL Relay use DBD::SQLRelay; my $dbh = DBI -> connect ('dbi:SQLRelay:$dsn', $login, $password); This module is a pure-Perl DBI binding to SQL Relay's native API. Connection string consists of following parts: Once connected, DB handler works as usual (see DBI). Don't ever try to share one SQLRelay connect by multiple scripts, for example, if you use Apache mod_perl. Every $dbh holds one of server connections, so call disconnect() directly at the end of every script and don't use Apache::DBI or SQLRelay will be deadlocked.
Note for HTML::Mason Users If you use HTML::Mason, your handler.pl sould look like this:
...{package HTML::Mason::Commands;use DBI;use vars qw($db);}...sub handler {$HTML::Mason::Commands::dbh = DBI -> connect (...);my $status = $ah -> handle_request (...);$HTML::Mason::Commands::dbh -> disconnect;return $status;}
D. E. Ovsyanko, [email protected] Contributions by: Erik Hollensbe <[email protected]> Tony Fleisher <[email protected]> http://www.firstworks.com Hey! The above document had some coding errors, which are explained below: '=item' outside of any '=over' You forgot a '=back' before '=head1'