Stack Overflow
Stack Overflow

Questions tagged [dbd]

DBD is a common prefix for all perl modules used as database drivers by the DBI module. These drivers hide the internals of different relational database management systems by providing a common API through the DBI module.

Access to relational databases in Perl is usually accomplished by the CPAN DBI module. See also DBI tag wiki entry.

DBI provides a common API for database access that uses separate drivers (DBD::*) internally to handle the specifics of different database management system implementations.

Some of the most popular DBD modules available on CPAN are:

DBD::MySQL
DBD::Oracle
DBD::Pg       (PostgreSQL)
DBD::ODBC
DBD::SQLite
DBD::Informix
DBD::Mock     (for testing purposes) 
DBD::CSV      (limited SQL access for CSV files)
DBD::JDBC
169 questions
2
votes
1 answer

Variant Effect Predictor | DBD mysql failing to setup

I trying to get set up with Variant Effect Predictor (VEP) on the command line. I'm following the setup tutorial but I'm encountering some errors around dependencies. I'm also quite new to the command line so if anyone is able to break down the…
Jepson
  • 47
  • 1
  • 6
2
votes
1 answer

Cannot install DBD::Oracle on macOS Big Sur => dependent dylib '@rpath/libclntsh.dylib.19.1' not found

I cannot build and install Oracle Instant Client 19.8 on macOS Big Sur 11.2.1. I get the following error: Error: Can't load '/Users/x/.cpanm/work/1613898291.17798/DBD-Oracle-1.80/blib/arch/auto/DBD/Oracle/Oracle.bundle' for module DBD::Oracle:…
h q
  • 1,168
  • 2
  • 10
  • 23
2
votes
0 answers

DBD::mysql error in ActivePerl 5.28 on Windws10 64bits, Can't load mysql.dll

I'm having an issue with the DBD::mysql module. This question has been asked before on this forum but a solution was not posted so I thought I would repost it. Sorry if this is not appropriate for this forum. This is my first post. You can find…
Ned LeBouthillier
  • 21
  • 2
2
votes
2 answers

IN in WHERE-clause is not being parsed correctly using SQL::Statement

I'm using a slightly modified version of the example provided here: https://metacpan.org/pod/distribution/SQL-Statement/lib/SQL/Statement/Structure.pod use SQL::Statement; use Data::Dumper; my $sql = q{ SELECT c1 , col2 as c2 , c3 FROM…
Jerome Provensal
  • 931
  • 11
  • 22
2
votes
1 answer

Perl running as user "apache" cannot load DBD::mysql while other users can

The site I administer has some CGI scripts that run scripts of the form: #!/usr/bin/env bash perl my-script.pl my-script.pl uses DBD::mysql. use DBD::mysql; My scripts use many CPAN modules and I do not want to pollute the "system" Perl (5.16)…
Lawrence I. Siden
  • 9,191
  • 10
  • 43
  • 56
2
votes
1 answer

Trouble installing DBD::mysql under macOS Mojave

Can't install DBD::mysql under macOS Mojave with perl v5.18.2 MySQL Community Server 8.0.13 is installed from DMG from the official site. Here is the installation log via cpan: Checking if libs are available for compiling... dyld: Library not…
Dmitriy
  • 463
  • 1
  • 5
  • 12
2
votes
1 answer

Setting up DBD::SQLite to support a custom version of sqlite3

I get a too many SQL variables error using a package-default version of sqlite3, when I pass in more than 998 variables into a SQL query. The sqlite3 binary packaged with yum for my OS and version was compiled with support for default variable names…
Alex Reynolds
  • 95,983
  • 54
  • 240
  • 345
2
votes
1 answer

apache 2.4 - Cant get Sybase database connection using mod_lua, mod_dbd, freetds

We are migrating our python scripts to lua scripts as part of apache 2.4 upgrade. One of the requirement is connecting to Sybase database and execute queries. To do that we have developed a small code using mod_lua api to get db connection, but we…
Abir
  • 33
  • 5
2
votes
2 answers

Using php to connect to mysql using mod_dbd

I would like to use mod_dbd to implement connection pooling for my php application. I am able to define the mod_dbd module for apache and I can see the connections that it is opening, but I am not able to "hook on" those connections with my php…
Ariel Rauch
  • 21
  • 2
2
votes
1 answer

Store perl array in memory for other perl instances

I am using a perl script that upon receiving parameters, it check one value on a database and then executes other actions accordingly. Since traffic is increasing there are a lot of mysql reads/writes being executed and might be affecting…
Diego
  • 39
  • 1
  • 1
  • 3
2
votes
2 answers

Perl - Too many files error when using DBD Oracle

Can someone advise on why I get errors opening the file in the code below. The errors start about half way through the 9th iteration of 25 threads, and are "Too many open files" errors. The error only happens when running in threads, and only when…
Joe Watkins
  • 1,593
  • 4
  • 15
  • 25
2
votes
2 answers

Why can't Perl's DBD::DB2 find dbivport.h during installation?

We are using a Perl utility to dump data from DB2 database. We installed DBI package and it is asking for DBD package also. We dont have root access and when we try to install DBD package we are getting the following error: ERROR BUILDING…
Liju Mathew
  • 871
  • 1
  • 18
  • 31
2
votes
1 answer

How I can connect to Oracle from Perl?

We have Oracle Server " Oracle Version: 10.2.0.4.0 - 64bit". I like to connect to this server with Perl from my RHEL machine. I am able to connect via sqlplus successfully. I can use 32-bit or 64-bit Perl. I have few questions. Which files I…
aartist
  • 3,145
  • 3
  • 33
  • 31
2
votes
2 answers

DBD::Oracle and utf8

I have some troubles inserting an UTF8 string into an oracle 10 database on Solaris, using the latest DBD::Oracle on perl v5.8.4. This are my DB settings > --------SELECT * from NLS_DATABASE_PARAMETERS------------------------------- >…
golemwashere
  • 159
  • 1
  • 7
2
votes
1 answer

Manually connect to PostgreSQL with Ruby

Connecting to postgres with rails was no big deal. rails -d postgresql app_name, setup the database.yml and voila. I cannot, however, use postgres with just a little test script I've tried installing the gems postgres, dbi & dbd-pg, pg, and…
Felix
  • 699
  • 2
  • 9
  • 24
1 2
3
…
11 12