Webmaster Forum / Perl / DBI Library / May 2005

Hi list!
I want to disable the object index for my webpages (embedded perl2 under
mod_perl2) but not for my scripts.
Is it possible to set the var '$Class::DBI::Weaken_Is_Available = 0;' in the

Hi list!
Another object index question right after the last one ;-)
I want to retrieve all objects of a class to avoid lots of
single-row-returning sql queries against the db.

I'm migrating a perl application in postgres to Oracle.  Here, the data is
being retrieved as below.
 while ($row = $sth->fetchrow_hashref()) {
   push (@list,$row);

    This morning while reinstalling various modules after a Tiger  
upgrade I ran into a test failure during Class::DBI testing in 04-
lazy.t. I'm using the stock perl (5.8.6) that comes with Tiger,  
others have confirmed that the tests do pass if using a custom built.

I finally needed this to work, so here's a test that shows the failure
and a patch that fixes it.
- Perrin

By default DBI will generate warnings if you try to prepare_cached() a
statement that already has an active handle. Ima::DBI can generate
those warnings when used with Class::DBI/DBIx::ContextualFetch. Below
my sig is a patch to do the safe thing, gracefully clear the active

I have a Perl application which uses the DBI library to do it's
database work. The backend database is a SQL Server database that I am
communicating through unixODBC using the FreeTDS library as the ODBC
driver.

Example: (Using DBD::SQLite)
$ref_rsch = $dbh->selectall_hashref('
       SELECT * FROM rsch ORDER BY Idx
   ', 'Idx');

I think it would be handy to have a transform_sql substitution akin
to __ESSENTIAL__ that would drop in a particular column group instead
of the Essential group.
I've added this to transform_sql:

Hello dbi-users,
I'm relatively new to Perl DBI so bear with me as this might be very
simple for the gurus.
I would like to use the results of a query as an input to another query's

I am sorry if this is covered somewhere that I have been unable to find
it.  I have not been able to connect to the FAQ at
http://dev.isystek.com/dbi/fom.cgi.  The only faq's I have found on-line
are dated CY2000, and do not appear to address this issue.

I have a problem with java application.
My shell script uses some jar files and calls a class
I have set up the DBAccessor.properties with
driver=COM.ibm.db2.jdbc.app.DB2Driver

Has anyone used DBI in an Oracle 9i RAC configuration on Linux?  If
so, were there any issues moving to RAC?

I am trying to set the LongReadLen value of $dbh dynamically to select a
CLOB, using:
$dbh->{LongReadLen} = $dbh->selectrow_array(qq{
     SELECT MAX(mc.mc_long_description)

Hi, I'm trying to compile the DBD 1.05 with perl 5.8.6 and sybase 12.5 on
solaris 8.  There is a small problem during the perl Makefile.PL but my
primary concern is during the make test.  It generates a core during the
test of xblk and fails that series of tests.  I guess the first ...