It appears that DBD::Oracle when compiled with Oracle 8i, has serious
performance issues when talking -- across the WAN -- to databases running
Oracle 7.3.4. Queries that used to return in a couple of seconds are now
taking several minutes.
Some tests have revealed that we are unable to set
Hmm. Maybe just a dependency bug? Oh well, I just put in a perl 5.8 package,
which has Time:HiRes allready in it, and DBI built just fine. Of course, now I'm
having trouble with DBD-Pg-131 :-(
Thanks for the help!
-Brian
Envelope-to: [EMAIL PROTECTED]
Delivery-date: Fri, 13 Dec 2002
Hi Tim
I am the fink (http://fink.sf.net) package maintainer of the DBI perl
module for MacOS X. I tried to update the package to version 1.32 and
got the following test error:
...
t/10examp...1..245
ok 1 at line 33
... (all ok)
ok 102 at line 316
fetchrow_hashref('NAME_uc')
ok 103
On Mon, Dec 16, 2002 at 08:56:26AM +0100, Christian Schaffner wrote:
Hi Tim
I am the fink (http://fink.sf.net) package maintainer of the DBI perl
module for MacOS X. I tried to update the package to version 1.32 and
got the following test error:
...
t/10examp...1..245
ok 1 at
Hi eveyone;
Can someone help me with this: I am trying to do a prepare and execute a .sql when
connected to a DB2 database using DBI. The foo.sql is the ($sqlfilename)has to
($genpak.sql) here is the code:
my $sth = $dbh-prepare($sqlfilename);
$sth-execute();
$rows =
The argument for prepare is a SQL statement, not the name of a file.
Also, AFAIK, you can't prepare multiple statements at a time, only one at
a time (and including a ; may or may not work, depending on your platform;
I'm not DB2/DBI literate).
Have you gotten this to work?
$sth =
W licie z pon, 16-12-2002, godz. 10:32, Brien Pirkle pisze:
my $st_create_trigger = $dbh-do(qq{
});
Are there any reasons, you are using 'qq' instead of 'q'?
BTW - escaping can be done using '\' (backslash) character, as qq(some
string) is equivalent to some string.
Waldemar
Ney guys,
I am trying to fetch and array form a table and I am not getting the
results I thought I would get:
I thought it was quote simple but when I print them outwell you'll
see?
code
#!/usr/bin/perl
use strict;
use warnings;
use DBI;
my( $dbname ) = BACKUP;
my( $mysqluser ) =
Hi,
Does anybody have experience using DBI with
Activestate's Perl for HP-UX 11? Does the PPM work in
the same way as it does for the Windows version.
Specifically, a colleague of mine wants to use
DBD::Informix, and had given up on the re-compiling
perl + module with gcc.
PPM would make his
I'm not sure I understand the problem, but I think(?) I see
one problem - see below.
Another thing I noticed was you are using the same $sth
statement handle for each prepare/execute/fetch you are
doing. As long as each fetch fetches *ALL* the rows, I
don't think that's a problem, but a safer
Use trace! (see the docs)
Tim.
On Mon, Dec 16, 2002 at 11:37:18AM -0500, chad kellerman wrote:
Ney guys,
I am trying to fetch and array form a table and I am not getting the
results I thought I would get:
I thought it was quote simple but when I print them outwell you'll
see?
W licie z pon, 16-12-2002, godz. 10:32, Brien Pirkle pisze:
my $st_create_trigger = $dbh-do(qq{
});
Are there any reasons, you are using 'qq' instead of 'q'?
BTW - escaping can be done using '\' (backslash) character, as qq(some
string) is equivalent to some string.
Waldemar
Hi. First time poster here. I am using DBI in a web application. The web
application consists of several perl scripts. Once a user signs on, I would
like to use that database handle in subsequent perl scripts. So the first
script signs the user on with something like:
my($fulldsn) =
The answer to the problem was supplied by Lincoln Baxter.
His suggestion was to use the 64bit Oracle client.
THANK YOU VERY MUCH Lincoln! It is really appreciated.
And thank you to all who tried to help.
So for the record, the DBD does not work on HPUX with the 64bit OS and
the 32bit Oracle
I am using dbi to connect to an Oracle database on a HP-UX (HP-UX 11.0)
database. When I attempt to connect to the database I receive the following
error:
DBI-connect(prd1) failed: ORA-12154: TNS: could not resolve service name
(DBD Error: OCIServerAttach) at ./tryDBI.pl
This happens when we
Has anyone build the newest DBI (1.32) on Perl 5.00503? I'm putting it on a
Sun Solaris 8 box, and it makes fine, but fails 2 tests. The main error I get
is this:
t/10examp...Insecure dependency in parameter 1 of
DBI::st=HASH(0x19dd70)-FETCH method call while running with -T switch at
I am a newbie to Perl on Windows. I have tried to do the ppm method but
cannot run dbiproxy due to a module not being installed with that method.
Could anyone be so kind as to explain how to compile modules on Windows or
better yet how to run the cpan utility on Windows?
Thanks,
Kevin
On
Roderick A. Anderson [EMAIL PROTECTED] writes:
I can't seem to find it in the Cheetah book and it isn't mentioned in The
man page so I ask. Does the DBD understand the different types of
authentication that PostgreSQL can do? IE, if I've sent up my database to
allow access using md5
Can anyone elaborate on the specifics of how to do this?
Thanks,
Kevin
On 1/14/02 5:34 PM, Hardy Merrill [EMAIL PROTECTED]
wrote:
If I remember right, to use DBI Proxy you'll need to
install Bundle::DBI - it contains the RPC::P1Server.pm and
everything else that's necessary. I haven't used
Unfortunately ppm cannot find plrpc.
On 6/27/02 12:36 AM, Thomas A. Lowery [EMAIL PROTECTED] wrote:
Roger,
The simplest method is to use ActiveStates PPM or PPM3. Install
DBI, Net-Daemon, and PlRPC (use the query/search feature to
confirm the names).
c:ppm
ppminstall DBI ...
It's
I assume therefore the tnsping does not work. Talk to your DBA/system
admins.
Perl DBI can not possibly work if the underlying database does not work.
Lincoln
-Original Message-
From: Powell, Bruce [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 3:05 PM
To: '[EMAIL
Kevin Diffily [[EMAIL PROTECTED]] wrote:
Can anyone elaborate on the specifics of how to do this?
I can't be much more help now than I was almost a year ago
when I wrote that message, since I haven't used dbiproxy
since then, but the one thing that comes to mind is that the
Programming the Perl
Dear Jeff and Tim,
Here's a patch which more or less got DBD::ODBC 1.01 up and running
using Informix CLI as the ODBC driver (and driver manager) on Solaris.
What did I have to fix?
First of all, for some reason I don't understand fully, my system was
initially diagnosed as being a udbc system.
Hello. I'm a newbie with respect to Oracle and DBI/DBD, so please bear with
me...
I'm trying to use DBD::Oracle to retrieve info from a read-only database. I
am successful on an HP-UX 11.0 machine when using the Oracle 8i sqlplus
command and when using perl 5.6.1 / DBI-1.20 / DBD::Oracle-1.06
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, Dec 16, 2002 at 03:43:29PM -0800, Kimball, Conrad wrote:
my perl script pauses for 5 seconds or so and then I get this error:
ORA-03113: end-of-file on communication channel (DBD ERROR:
OCIStmtExecute)
Check Oracle's alert log,
I tried to install DBI-1.32 on my system running Solaris 8. I read about the
compiler problem with perl on Solaris8.
I modified my PATH so I would use SUNWspro/bin/cc to compile DBI. I recieved
the following error.
Can someone help or point me to some other docs I can read about this.
Summary of
From what I can see, you just have the print in the wrong place. Each step
of the fetch loop, as it gets the names one by one, you push to the names
array, then print the array - so you see it each step of the way. Move the
print to outside the loop
-Original Message-
From: chad
On Mon, 16 Dec 2002 16:15:29 -0500, Kevin Diffily wrote:
Hi Kevin
I am a newbie to Perl on Windows. I have tried to do the ppm method
Just for the record, installation help is here:
http://savage.net.au/Perl-modules.html
--
Ron Savage, [EMAIL PROTECTED] on 17/12/2002
Deakin University, 221
hi there (again)
i was just wondering whether there's any ppm of dbd-mysql flying around
for perl 5.8 somewhere for the rest of us stuck on win32 machines w/o a
compiler.
i'd really like to updadate to 5.8, but i just can't live without mysql
(and Tk, for that matter).
the ppm that ilya's
On Mon, 16 Dec 2002 21:30:46 -0600, Moritz von Schweinitz wrote:
hi there (again)
Hi Moritz
i was just wondering whether there's any ppm of dbd-mysql flying
around
for perl 5.8 somewhere for the rest of us stuck on win32 machines
Try:
http://theoryx5.uwinnipeg.ca/ppmpackages/
--
Ron Savage,
Henry McGuinness wrote:
Does anybody have experience using DBI with
Activestate's Perl for HP-UX 11? Does the PPM work in
the same way as it does for the Windows version.
Not being aware that there was an ActiveState version of Perl for any
platform other than MS Win32, there's no way I can
31 matches
Mail list logo