NAME

DBD::Solid - DBD driver to access Solid database

SYNOPSIS

  require DBI;

  $dbh = DBI->connect('DBI:Solid:' . $database, $user, $pass);
  $dbh = DBI->connect($database, $user, $pass, 'Solid');

DESCRIPTION

This module is the low level driver to access the Solid database using the DBI interface. Please refer to the DBI documentation for using it.

REFERENCE

Driver Level functions

  $dbh = DBI->connect('DBI:Solid:', $user, $pass);
  $dbh = DBI->connect('', $user, $pass, 'Solid');

        Connects to a local database.

  $dbh = DBI->connect('DBI:Solid:TCP/IP somewhere.com 1313', 
                      $user, $pass);
  $dbh = DBI->connect('TCP/IP somewhere.com 1313',
                      $user, $pass, 'Solid');

        Connects via tcp/ip to remote database listening on
        port 1313 at host "somewhere.com".
        NOTE: It depends on the Solid license whether 
              TCP connections (even to 'localhost') are possible.

Common handle functions

  $h->err               full support
  $h->errstr            full support
  $h->state             full support

  $h->{Warn}            used to deactivate 'Depreciated 
                        feature' warnings
  $h->{CompatMode}      not used
  $h->{InactiveDestroy} supported
  $h->{PrintError}      handled by DBI
  $h->{RaiseError}      handled by DBI
  $h->{ChopBlanks}      full support
  $h->trace(...)        handled by DBI
  $h->{LongReadLen}     full support
  $h->{LongTruncOk}     full support
  $h->func(...)         no functions defined yet

Database handle functions

  $sth = $dbh->prepare(                 full support
                $statement)             
  $sth = $dbh->prepare(                 full support
                $statement, 
                \%attr);

        DBD::Solid note: As the DBD driver looks for placeholders within 
        the statement, additional to the ANSI style '?' placeholders 
        the Solid driver can parse :1, :2 and :foo style placeholders 
        (like Oracle). 

        \%attr values:

        {LongReadLen => number}

        May be useful when you know that the LONG values fetched from 
        the query will have a maximum size.
        Allows to handle LONG columns like any other column.

        History note:
        DBD::Solid 0.07 and above: 
                the attribute 'blob_size' triggers a 'depreciated 
                feature' warning when warnings are enabled.
        DBD::Solid 0.08 and above:
                the attribute 'solid_blob_size' triggers a 
                depreciated feature' warning when warnings are enabled
                (because DBI 0.86+ specifies a LongReadLen attribute).

  $rc = $dbh->do($statement)            full support
  $rc = $dbh->commit()                  full support
  $rc = $dbh->rollback()                full support
  $dbh->{AutoCommit}                    full support

  $dbh->{solid_characterset} = $charset;

        This is a quick hack to activate Solid's 
        characterset translation, just in the case 
        Solid doesn't guess the default translation 
        (based on operating system and adjustable 
        by a solid.ini parameter in the working directory) 
        right.

        Possible values are:

        $charset = 'default';
        $charset = 'nocnv';
        $charset = 'ansi';
        $charset = 'pcoem';
        $charset = '7bitscand';

  $rc = $dbh->disconnect()              full support
        does a ROLLBACK, so the application must
        commit the transaction before calling 
        disconnect

  $rc = $dbh->ping()                    supported; prepares and executes
                                        from a small system table.

  $rc = $dbh->quote()                   handled by DBI
  $rc = $sth->execute()                 full support
  @array    = $sth->fetchrow_array()    full support
  @array    = $sth->fetchrow()          full support
  $arrayref = $sth->fetchrow_arrayref() handled by DBI
  $hashref  = $sth->fetchrow_hashref()  handled by DBI
  $tbl_ary_ref = $sth->fetch_all()      handled by DBI
  $sth->rows()                          full support

  $rv = $sth->bind_col(                  full support
        $column_number,
        \$var_to_bind);                 

  $rv = $sth->bind_col(                  no attr defined yet
        $column_number, 
        \$var_to_bind, 
        \%attr);                        

  $rv = $sth->bind_columns(              full support
        \%attr, 
        @refs_to_vars_to_bind);         

  $sth->{NUM_OF_FIELDS}                 full support
  $sth->{NUM_OF_PARAMS}                 full support
  $sth->{NAME}                          full support
  $sth->{NULLABLE}                      full support
  $sth->{CursorName}                    full support

AUTHOR

T.Wenrich, wenrich@ping.at or wet@timeware.co.at

SEE ALSO

perl(1), DBI(perldoc), DBD::Solid::Const(perldoc), Solid documentation