Tim Bunce wrote:
On Mon, Mar 03, 2003 at 04:25:13PM -0500, Bob X wrote:
I have this script:
[...]
It simply gives me a list of DBD drivers installed. Ran fine until I upgrade
to 1.34 at which point I get the following error now:
install_driver(Proxy) failed: Global symbol "$this" requires explicit
connect_cached creates a _new_ connection on the second call
in this sample (only difference being PrintError attribute)
DBI->connect($data_source, $user, $auth, {PrintError=>1});
DBI->connect($data_source, $user, $auth, {PrintError=>0});
I would submit that this is "wrong" behavior, and that the
IBM Informix Database Driver for Perl Version 2003.03.0303 (2003-03-03) has been
uploaded to CPAN.
IBM Informix Database Driver for Perl (also known as DBD::Informix) is
the driver code that enables Perl 5.005 or later to access Informix
databases via the DBI module (but if you are not already u
At 0:18 + 3/4/03, Tim Bunce wrote:
I've discovered that DBD::mysql will return "tablefoo.fieldbar" as
the NAME of the field in a select like:
SELECT tablefoo.fieldbar FROM tablefoo
That's not what I observe. Is this a recent change in the MySQL C client
library? The library has not return
I've discovered that DBD::mysql will return "tablefoo.fieldbar" as
the NAME of the field in a select like:
SELECT tablefoo.fieldbar FROM tablefoo
It does that simply because that's what the underlying mysql client
API tell it is the name of the field.
I believe this is very rare (I know of n
> From: Tim Bunce [mailto:[EMAIL PROTECTED]
> Anyone using perl 5.8.0?
After a lot of upgrades (seg fault, DBI connect hangs), we seem to have one old RedHat
server happy w/ 5.8.0.
Linux version 2.4.7-10 ([EMAIL PROTECTED]) (gcc version 2.96 2731 (Red Hat Linux
7.1 2.9
6-98)) #1 Thu Sep 6
On Mon, Mar 03, 2003 at 04:25:13PM -0500, Bob X wrote:
> I have this script:
>
> use strict;
> use warnings;
>
> use DBI;
>
> my %attr = (
> PrintError => 0,
> RaiseError => 1
> );
>
> my @drivers = DBI->available_drivers();
>
> foreach my $driver(@drivers) {
> print "Driver: $driv
I have this script:
use strict;
use warnings;
use DBI;
my %attr = (
PrintError => 0,
RaiseError => 1
);
my @drivers = DBI->available_drivers();
foreach my $driver(@drivers) {
print "Driver: $driver\n";
my @dataSources = DBI->data_sources($driver);
foreach my $dataSource(@d
I am trying to do either :-
Retrieve data from an Oracle table with a nested table column
or
Retrieve data from an Oracle object table based on an object which contains
a nested table
Either attempt results in :-
DBD::Oracle::db selectrow_array failed: ERROR OCIDefineObject call needed
but not im
I am trying to do either :-
Retrieve data from an Oracle table with a nested table column
or
Retrieve data from an Oracle object table based on an object which contains
a nested table
Either attempt results in :-
DBD::Oracle::db selectrow_array failed: ERROR OCIDefineObject call needed
but not im
Hello Jenda,
I have used the same data under Linux and Windows, also the same scripts.
The times I gave in A) are only for the select of the CSV table not for the
script. But comparing the select query with the execution of the rest of the
script, select is taking most of the time. Under Windows (S
Hello,
thanks for your answers.
I would also like to stick to MySQL, but I have to change it, since there is
no DB-Server available.
Dan, yes the data of the tables are *exactly* the same!!!
The querry I use for C) is like:
where (field1=?) and (field2=?) order by field3
again the same data and
On 2003-03-03 13:35:36 +0100, Peter Schuberth wrote:
> I have changed from
> MySQL DB to CSV File (DBD::CSV).
> And also from Linux to Windows
Neither seems like a smart move to me.
Changing two things at once definitely isn't.
> A)
> But now I discovered few problems:
> On the same hardware sy
Please has anybody got a similar problem and a fix
I've already installed DBI.1.21 on 2 Sun servers with Solaris 8 ...one was a 32 bit
and the other a 64 without any problems well not too many !!
But on this server its proving impossible ...I've also tried a different dbi ..1.34
I am trying to insert into a table which has a nested table.
I have an array in Perl which I want to load into the nested table.
I have a variable number of entries in the array and dont want to have to
enumerate them.
How can I load my data into a nested table?
Ok thanks - just wanted to check it wasn't down to how I was using it
"Michael A Chase" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> On Mon, 3 Mar 2003 20:50:09 - Simon Taylor <[EMAIL PROTECTED]>
wrote:
>
> > I am trying to do either :-
> >
> > Retrieve data from an Oracle ta
On Mon, 3 Mar 2003 20:50:09 - Simon Taylor <[EMAIL PROTECTED]> wrote:
> I am trying to do either :-
>
> Retrieve data from an Oracle table with a nested table column
> or
> Retrieve data from an Oracle object table based on an object which
> contains a nested table
>
> Either attempt result
Hi Michael,
Attached are 2 files. One is a build script for a Sybase stored procedure
(fill in the database name). The other is a perl script (fill in the
connection information).
The reason I am raising this issue is that I found I had to code for special
conditions during error handling be
I am trying to do either :-
Retrieve data from an Oracle table with a nested table column
or
Retrieve data from an Oracle object table based on an object which contains
a nested table
Either attempt results in :-
DBD::Oracle::db selectrow_array failed: ERROR OCIDefineObject call needed
but not im
On Mon, Mar 03, 2003 at 10:07:29AM -0800, Jeff Zucker wrote:
> Peter Schuberth wrote:
>
> >On the same hardware system
> >the same select for the same table
> >
> Please check your version of SQL::Statement which is the module that
> determines the speed and capabilities of DBD::CSV. Put these t
On Mon, 3 Mar 2003 09:42:51 -0800 Fernando Luna <[EMAIL PROTECTED]> wrote:
> It would have been nice to know if, say, someone had worked out
> something to process SQL files since this is such a common task and
> developers who don't use perl but work with Oracle frequently use SQL
> files.
Bulk
Snethen, Jeff wrote:
I've worked with the DBI some, but I'm now starting to experiment with DBD::CSV. I'm
trying to read a table without
column headers, letting CSV create the column names for me. If I understand the
documentation correctly, an empty array
reference should cause the driver to
Peter Schuberth wrote:
On the same hardware system
the same select for the same table
Please check your version of SQL::Statement which is the module that
determines the speed and capabilities of DBD::CSV. Put these two lines
at the top of the scripts:
use SQL::Statement;
print $SQL::Sta
I have already realized that simply stripping out the semi-colon will not work with
all situations. I even posted something to that effect.
It would have been nice to know if, say, someone had worked out something to process
SQL files since this is such a common task and developers who don't use
On Sat, 01 Mar 2003 12:02:15 -0800, G S wrote:
>I have been posting messages here by emailing to [EMAIL PROTECTED] Is
>there a way to post messages so that they are part of an ongoing thread?
Select "reply" to respond. Make sure "[EMAIL PROTECTED]" is amongst the
recipients. That's it, basica
> Hello,
> thanks for your answers.
>
> I would also like to stick to MySQL, but I have to change it,
> since there is no DB-Server available.
Use a remote one, your isp's perhaps. Anywho...
>
> Dan, yes the data of the tables are *exactly* the same!!!
How about posting the first few lines
On Fri, 28 Feb 2003 20:21:29 -0500, Cory Rau wrote:
>I
>purposely mistyped the url with 'cgi-bin' rather than what it actually
>is, 'CGI-BIN' just to see what would happen. I ended up getting the
>entire *code* of the perl script in my web browser
This is OT for perl-DBI, but...
I think that
From: "Dan Muey" <[EMAIL PROTECTED]>
> > A)
> > But now I discovered few problems:
> > On the same hardware system
> > the same select for the same table
> >
> > 1) Linux the select takes 0.4 seconds
> >
> > 2) Windows the select takes 2.1 seconds
> >
> > Using Apache 1.3.27 and under Windows Ac
Sounds like the cgi-bin directory is in the document_root hierarchy it
doesn't match the ScriptAlias and get executed so it is just returned as a
text file. Make sure the cgi-bin is in a different directory path not in
document root then you'll just get a Document not found error.
NOTE: Pure conjec
Not sure with windows, probably should see apache.org for details, but it seems
That perhaps
There is a 'ScriptAlias' directive for CGI-BIN but not cgi-bin.
I'd try adding that in your httpd.conf file or making some kind of symlink or alias
with each other for both versions.
Also it may be an E
> Hello,
>
> I have changed from
> MySQL DB to CSV File (DBD::CSV).
> And also from Linux to Windows
There's the first two mistakes! :)
>
> A)
> But now I discovered few problems:
> On the same hardware system
> the same select for the same table
>
> 1) Linux the select takes 0.4 seconds
>
On Mon, 3 Mar 2003 08:23:11 -0500 Cory Rau <[EMAIL PROTECTED]> wrote:
> I ended up changing all my references to CGI-BIN to cgi-bin and ran
> into the same problem as before when I'd purposely *uppercase* the
> cgi-bin portion of the url.
>
> I ended up creating a shortcut to cgi-bin which is c
On Sat, Mar 01, 2003 at 11:10:34AM -0800, David Dyck wrote:
>
> There seem to be conflicting versions of DBI::Format in
> DBI-1.34 and DBI-Shell-11.91.
>
> After upgrading to the recent DBI-1.34 I again get
> a warning from the CPAN "r" command which reports that
> there is a more recent version
I ended up changing all my references to CGI-BIN to cgi-bin and ran
into the same problem as before when I'd purposely *uppercase* the
cgi-bin portion of the url.
I ended up creating a shortcut to cgi-bin which is called CGI-BIN and
added that directory to the appropriate sections of the httpd.
On Sat, 01 Mar 2003 12:02:15 -0800 G S <[EMAIL PROTECTED]> wrote:
> I have been posting messages here by emailing to [EMAIL PROTECTED] Is
> there a way to post messages so that they are part of an ongoing thread?
That is a function of your email client. Normally, if you reply to a
message, the
Hello,
I have changed from
MySQL DB to CSV File (DBD::CSV).
And also from Linux to Windows
A)
But now I discovered few problems:
On the same hardware system
the same select for the same table
1) Linux the select takes 0.4 seconds
2) Windows the select takes 2.1 seconds
Using Apache 1.3.27 and
I searched google, but could not find the answer.
We are using
oracle 9.2.0.2.0
SunOS enigma 5.7 Generic_106541-18 sun4u sparc SUNW,Ultra-4
This is perl, v5.6.1 built for sun4-solaris
DBI 1.34
but when I was trying to install DBD:Oracle 1.12
at make test, I got
Test returned status 255 (wsta
I have been posting messages here by emailing to [EMAIL PROTECTED] Is
there a way to post messages so that they are part of an ongoing thread?
Thanks.
_
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.co
I am tracking down an issue where an error condition is not returned from a
call to $sth->execute().
Here is my example code with comments. I show the output for 3 tests. Test
1 and test 2 produce results that I understand. The problem is in test 3.
In test 3 I would expect the returned valu
There seem to be conflicting versions of DBI::Format in
DBI-1.34 and DBI-Shell-11.91.
After upgrading to the recent DBI-1.34 I again get
a warning from the CPAN "r" command which reports that
there is a more recent version of DBI::Format to
be found in DBI-Shell-11.91.tar.
When I read that the n
Lincoln Stein wrote:
My test case is part of a big script that requires BioPerl. What I'll do is
to pull it out into a self-contained script.
Frankly I don't think that this has anything to do with DBI, but rather
something fundamental that changed with Perl's IO handling. A whole bunch of
sy
Hi,
I am a happy user of DBD::Sybase to enable my perl to talk with MS SQL
Server.
The DBD::Sybase I am using is .tar.gz, I need distribution in .rpm as the
deployment machine don't have make :)
What I have done is the following:-
(1)
/usr/lib/rpm/cpanflute2 DBD-Sybase-0.94.tar.gz // convert
Hi Glen,
I hope you don't mind the (nearly) fullquote to keep the list informed.
"G S" <[EMAIL PROTECTED]> wrote:
> Hi Hans,
>
> Thank you for your response. I was able to capture $retCode using your
> suggestion. I eventually removed the error handler (after the "||") just to
> isolate some
43 matches
Mail list logo