Linux Certif

Toute la documentation sur la certification Linux LPI

DBIx::Class::Storage::DBI::SQLAnywhere.3pm

NAME

DBIx::Class::Storage::DBI::SQLAnywhere - Driver for Sybase SQL Anywhere

DESCRIPTION

This class implements autoincrements for Sybase SQL Anywhere, selects the RowNumberOver limit implementation and provides DBIx::Class::InflateColumn::DateTime support.

You need the "DBD::SQLAnywhere" driver that comes with the SQL Anywhere distribution, NOT the one on CPAN. It is usually under a path such as:

   /opt/sqlanywhere11/sdk/perl
 
 

Recommended connect_info settings:

   on_connect_call => 'datetime_setup'
 
 

METHODS

connect_call_datetime_setup

Used as:

     on_connect_call => 'datetime_setup'
 
 

In connect_info to set the date and timestamp formats (as temporary options for the session) for use with DBIx::Class::InflateColumn::DateTime.

The "TIMESTAMP" data type supports up to 6 digits after the decimal point for second precision. The full precision is used.

The "DATE" data type supposedly stores hours and minutes too, according to the documentation, but I could not get that to work. It seems to only store the date.

You will need the DateTime::Format::Strptime module for inflation to work.

MAXIMUM CURSORS

A DBIx::Class application can use a lot of cursors, due to the usage of prepare_cached.

The default cursor maximum is 50, which can be a bit too low. This limit can be turned off (or increased) by the DBA by executing:

   set option max_statement_count = 0
   set option max_cursor_count    = 0
 
 

Highly recommended.

AUTHOR

See ``AUTHOR'' in DBIx::Class and ``CONTRIBUTORS'' in DBIx::Class.

LICENSE

You may distribute this code under the same terms as Perl itself.