GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  DBIX::CLASS::STORAGE::DBI::SQLANYWHERE (3)

.ds Aq ’

NAME

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

CONTENTS

DESCRIPTION

This class implements autoincrements for SQL Anywhere and provides DBIx::Class::InflateColumn::DateTime support and support for the uniqueidentifier type (via DBIx::Class::Storage::DBI::SQLAnywhere::Cursor.)

You need the DBD::SQLAnywhere driver that comes with the SQL Anywhere distribution, <B>NOTB> 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.

FURTHER QUESTIONS?

Check the list of additional DBIC resources.

COPYRIGHT AND LICENSE

This module is free software copyright by the DBIx::Class (DBIC) authors. You can redistribute it and/or modify it under the same terms as the DBIx::Class library.
Search for    or go to Top of page |  Section 3 |  Main Index


perl v5.20.3 DBIX::CLASS::STORAGE::DBI::SQLANYWHERE (3) 2016-02-11

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.