DBD::Solid - DBD driver to access Solid database
require DBI; $dbh = DBI->connect('DBI:Solid:' . $database, $user, $pass); $dbh = DBI->connect($database, $user, $pass, 'Solid');
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.
$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.
$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
$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
T.Wenrich, wenrich@ping.at or wet@timeware.co.at
perl(1), DBI(perldoc), DBD::Solid::Const(perldoc), Solid documentation
1 POD Error
The following errors were encountered while parsing the POD:
You forgot a '=back' before '=head1'
To install DBD::Solid, copy and paste the appropriate command in to your terminal.
cpanm
cpanm DBD::Solid
CPAN shell
perl -MCPAN -e shell install DBD::Solid
For more information on module installation, please visit the detailed CPAN module installation guide.