Can you post an example script that calls selectrow_hashref and
demonstrates the problem?
Tim.
On Fri, Feb 14, 2003 at 01:18:56PM +1100, Craig Sanders wrote:
> this seems to have changed since i installed DBI 1.32 (i upgraded from 1.30),
> and is breaking some scripts which assume that it will al
On Sat, Feb 15, 2003 at 11:23:13AM +1100, Craig Sanders wrote:
> On Sat, Feb 15, 2003 at 10:51:14AM +1100, Craig Sanders wrote:
> > On Fri, Feb 14, 2003 at 11:05:19AM +0000, Tim Bunce wrote:
> > > Can you post an example script that calls selectrow_hashref and
> > &g
On Fri, Feb 14, 2003 at 06:10:11PM +0100, Roger Perttu wrote:
>
> I assume the functionality I'm looking for doesn't exist.
You're right. The DBI can't effectively keep track of whether a
driver's session with it's database server is in a transaction of not.
And many database API's don't provide
On Tue, Feb 18, 2003 at 10:59:35AM +, oliver wrote:
>
> On Mon, 17 Feb 2003 09:56:02 -0800, Tim Howell wrote:
>
> >I'm having a problem with dbiproxy on Win2K. I'm connecting to the
> >proxy server from perl 5.8 on a linux box in order to access a MS SQL
> >database on the Win2K box. Everyt
On Thu, Feb 20, 2003 at 04:45:44PM +, oliver wrote:
> On Tue, 18 Feb 2003 11:10:52 +0000, Tim Bunce wrote:
>
> >*Please* give back to the community that gave the modules to you,
> >by sending the patches to the maintainers of the modules.
>
> We would have fedback ear
Does enyone have a reasonably working implementation of column_info() for mysql?
Tim.
On Thu, Feb 20, 2003 at 02:36:04PM -0800, Jeff Zucker wrote:
> Jeff Zucker wrote:
>
> > There is no database independent way to match a delimited identifier
> >to an undelimited identifier.
>
> That part of my previous post is correct, but my examples were bad.
> Here is a better explanation wi
On Thu, Feb 20, 2003 at 06:57:37PM +, Tim Bunce wrote:
> Does anyone have a reasonably working implementation of column_info() for mysql?
I guess not, so I've written my own basic one and appended it below for feedback.
Tim.
sub DBD::mysql::db::column_info {
my ($dbh, $catalog,
On Sun, Feb 23, 2003 at 11:05:33AM +1100, Ron Savage wrote:
>
> 4) Starting at what is now line 295, we see:
> my $desc = $dbh->selectall_arrayref("DESCRIBE $table", {
> Columns=>{} });
> my $ordinal_pos = 0;
> foreach my $row (@$desc) {
>
> Inside this for loop, I changed all refere
I'd be very grateful if someone could send me the results from
$dbh->column_info (using a recent DBD::ODBC with a recent MyODBC
v3 driver) for a table containing just about every valid mysql data
type (including an unsigned int).
A csv file with column headings would be great.
Please send just to
On Tue, Feb 25, 2003 at 09:10:18AM +1100, Ron Savage wrote:
> On Mon, 24 Feb 2003 09:22:09 +0000, Tim Bunce wrote:
> >On Sun, Feb 23, 2003 at 11:05:33AM +1100, Ron Savage wrote:
>
> >>5) At the end of this sub, I added code to return something :-):
> >>\%col_info;
&
Anyone using perl 5.8.0?
Jarkko and I would be interested in any feedback you may have.
Obviously my main interest is with DBI and drivers but Jarkko's
is wider.
Please reply to Jarkko (CC'd) and then also CC me if your reply
includes any feedback related to the DBI and/or the new signal
handling
On Tue, Feb 25, 2003 at 02:16:12PM +0100, Guillaume Rousse wrote:
> Le Mardi 25 Février 2003 13:50, Tim Bunce a écrit :
> > Anyone using perl 5.8.0?
> Yes.
>
> > Jarkko and I would be interested in any feedback you may have.
> > Obviously my main interest is with D
On Tue, Feb 25, 2003 at 01:26:03PM -, Steve Haslam wrote:
> Tim, Jarkko; my main problem with using perl 5.8 for our
> DBD::Oracle/DBD::Sybase apps is the inability to use signals to "time out"
> an operation. We have constructs like:
>
> eval {
> alarm(60);
> local $SIG{ALRM} = sub { $sth->
On Tue, Feb 25, 2003 at 09:13:47AM -0500, Thomas Good wrote:
> On Tue, 25 Feb 2003, Tim Bunce wrote:
>
> > Anyone using perl 5.8.0?
> >
> > Jarkko and I would be interested in any feedback you may have.
> > Obviously my main interest is with DBI and dri
On Tue, Feb 25, 2003 at 03:14:24PM -0500, Michael Houghton wrote:
> Howdy!
>
> I'm trying to write a WARN handler for an Informix application.
> I want to be able to get to stuff in the SQLCA, which, if I read
> things correctly, means I need the statement handle for the offending
> action.
>
> I
On Tue, Feb 25, 2003 at 05:30:31PM -0500, Thomas Good wrote:
> On Tue, 25 Feb 2003, Tim Bunce wrote:
>
> > > While I was using 5.8 large data transfers via DBI failed consistently.
> > > I have compared notes with others (including Lincoln Stein) and this
> > >
Ah, mentioning PerlIO and DBD::Oracle points the finger at the fact that
DBD::Oracle hasn't been updated to use PerlIO for warnings/trace (at least
not in the release on CPAN). That may be a factor.
If DBD::Oracle needs to 'say' anything (which is very rare in normal
operation) it'll be passing a
- Forwarded message from Fernando Luna <[EMAIL PROTECTED]> -
Delivered-To: [EMAIL PROTECTED]
Subject: DBI - the book
Date: Wed, 26 Feb 2003 13:56:21 -0800
From: "Fernando Luna" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
There is the need at my organization to process DDL statements
cont
I believe this is due to DBD::mysql implementing its own do() method
that does not creat a statement handle.
I've worked around it by marking do (and prepare) as methods
that should trigger the $h->{Statement} to be cleared on entry.
That way if they don't set it before an error occurs then at lea
On Thu, Feb 27, 2003 at 11:32:43AM -, Clark, Ralph wrote:
> Tim Bunce wrote:
> > NOTE: Future versions of the DBI *will not* support perl 5.6.0 or earlier.
> > : Perl 5.6.1 will be the minimum supported version.
>
> It sounds like "future versions" d
> Netscape/7.01
> X-Accept-Language: en-us, en
> To: Rudy Lippan <[EMAIL PROTECTED]>
> Subject: Re: ParamValues & Bind
>
> Rudy Lippan wrote:
> >On Wed, 26 Feb 2003, Tim Bunce wrote:
> >>Rudy Lippan wrote:
> >>>I know there is a {NUM_OF_PA
On Thu, Feb 27, 2003 at 11:10:22AM -0500, Jeff Urlwin wrote:
> Tim,
>
> There's probably a deeper timing issue on these that's causing the
> issues, but I thought I'd let you know:
> 1) The following fails on my machine:
> t/40profile.t line 93
>
> ok($total > $longest);
>
> I
On Thu, Feb 27, 2003 at 12:52:24PM -0500, Jeff Urlwin wrote:
> Too many questions :)
:)
> > What's your operating system? (and perl -V output?)
> > And, out of interest, what's the spec of your machine?
> > (cpu/memory etc)
>
> Windows XP service pack 1.
> Pentium 4 (mobile), 2.2 Ghz
> 1 GB RAM
On Thu, Feb 27, 2003 at 04:01:40PM -0500, Roels, Steven wrote:
>
> Tim,
>
> Did the following get fixed in 1.33? I didn't see it in the release
> notes, but its such a minor thing I wouldn't really expect to have seen
> it there.
It's a DBD::Oracle issue, not DBI.
Tim.
> >> Specifically, I had
On Thu, Feb 27, 2003 at 05:01:56PM -0500, Jeff Urlwin wrote:
> Tim,
>
> I hate to say this, but, DBD::Oracle (here) doesn't work with DBI 1.33...
> Dbd_discon_all needs to be defined.
Thanks. What's the exact error message?
Tim.
Fix your perl.
Reconfigure and rebuild it so it does support dynamic loading
(Otherwise you're just heading into a whole world of pain and
frustration.)
Tim.
On Fri, Feb 28, 2003 at 02:53:35PM -, Chris Bucchere wrote:
> Hi Frans,
>
> When I wrote and ran the simple script with only "u
Built with 5.8.0 (thread-multi) for me.
The message looks like a compiler bug.
You could try DBI 1.34 which is winging it way to CPAN,
announcement to follow...
Tim.
On Fri, Feb 28, 2003 at 02:25:06PM -0600, Bobby Garza wrote:
> Tim,
>
> Here is my error message:
>
> ---snip---
> [EMAIL PROTECT
Thanks.
I've included it as a known problem (for people who have installed
Tom Lowery's DBI::Shell) in the release notes for DBI 1.33, which
is now on cpan.
Tim.
On Wed, Feb 26, 2003 at 09:29:26PM +0100, Jeroen Latour wrote:
> This distribution has been tested as part of the cpan-testers
> effor
On Wed, Feb 26, 2003 at 10:18:34PM -0800, Jonathan Leffler wrote:
> PAUSE wrote:
> >The uploaded file
> >
> >DBI-1.33.tar.gz
> >
> >has entered CPAN as
> >
> > file: $CPAN/authors/id/T/TI/TIMB/DBI-1.33.tar.gz
>
>
> t/70shell..Can't locate object method "init" via package
> "DBI:
file: $CPAN/authors/id/T/TI/TIMB/DBI-1.34.tar.gz
size: 290116 bytes
md5: f0056760bea3d5697c21d64358617895
NOTE: Future versions of the DBI *will not* support perl 5.6.0 or earlier.
: Perl 5.6.1 will be the minimum supported version.
NOTE: The "old-style" connect: DBI->connect($data
file: $CPAN/authors/id/T/TI/TIMB/DBI-1.33.tar.gz
size: 299066 bytes
md5: c6a737c990bc59f95c34657ec72ac68a
=head2 Changes in DBI 1.33,27th February 2003
NOTE: Future versions of the DBI *will not* support perl 5.6.0 or earlier.
: Perl 5.6.1 will be the minimum supported version.
Thanks. Known problem (due to windows time having less resolution).
Will be fixed in the next release (in a day or so).
Tim.
On Fri, Feb 28, 2003 at 12:10:09AM -0800, DH wrote:
> This distribution has been tested as part of the cpan-testers
> effort to test as many new uploads to CPAN as possible
On Sat, Mar 01, 2003 at 04:24:33PM -0800, Jonathan Leffler wrote:
> Tim Bunce wrote:
> > file: $CPAN/authors/id/T/TI/TIMB/DBI-1.34.tar.gz
>
> I got a clean compile and install on MacOS X 10.2.4 (yes, I got that
> upgraded too), over a forced install of DBI 1.33. Looks
On Sat, Mar 01, 2003 at 07:43:14PM -0800, Dean Arnold wrote:
> "Jonathan Leffler" <[EMAIL PROTECTED]> wrote:
> >
> > You show the 'install_method' working on
> > DBD::Driver::db->install_method(...). That appears to make it
> > available on a $dbh - correct? Is there an equivalent for the
> >
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
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, 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'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
On Mon, Mar 03, 2003 at 09:43:45PM -0800, Jonathan Leffler wrote:
> Tim Bunce wrote:
> >>package name at C:/Perl/site/lib/DBD/Proxy.pm line 272.
> >>BEGIN not safe after errors--compilation aborted at
> >>C:/Perl/site/lib/DBD/Proxy.pm line 414.
> >>Compilati
It looks like a false alarm. I can't reproduce it outside Class::DBI
(using mysql client, or DBD::mysql, using v3 or v4) so I need to
dig deeper into Class::DBI to see what's happening there.
Tim.
On Mon, Mar 03, 2003 at 06:39:01PM -0600, Paul DuBois wrote:
> At 0:18 +0000 3/4/
- Forwarded message from [EMAIL PROTECTED] -
Delivered-To: [EMAIL PROTECTED]
Subject: DBD::Oracle and AIX 5.1 64 bit
To: [EMAIL PROTECTED]
From: [EMAIL PROTECTED]
Date: Tue, 4 Mar 2003 11:40:32 +0100
Hallo,
do you have experience with AIX 5.1 64 bit mode and DBD::Oracle?
I have a strang
On Mon, Mar 03, 2003 at 08:20:34PM -0500, Bob X wrote:
> "Tim Bunce" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> > On Mon, Mar 03, 2003 at 04:25:13PM -0500, Bob X wrote:
>
> > Thanks. I believe the appended patch fixes it.
> >
>
On Tue, Mar 04, 2003 at 04:33:59PM +0100, Andreas Koch wrote:
> After successful installation of Perl and DBI, i get some errors installing
> the DBD 1.12. What can i do to fix it?
There are no errors, only warnings. The short story is that DBD::Oracle
has not yet been updated for recent perl vers
On Tue, Mar 04, 2003 at 09:32:27AM -0800, Jeff Zucker wrote:
> Tim Bunce wrote:
>
> >On Mon, Mar 03, 2003 at 10:07:29AM -0800, Jeff Zucker wrote:
> >
> >>use SQL::Statement;
> >> print $SQL::Statement::VERSION;
> >>
> >
> >Or run this co
On Tue, Mar 04, 2003 at 10:45:45PM -, Simon Taylor wrote:
> Will this include support for Oracle 8 objects?
Is your cheque in the mail?
;-)
Let's get the ball rolling bfore we try to steer it shall we?
Tim.
> -Original Message-----
> From: Tim Bunce [mailto:[EMAIL PROT
On Tue, Mar 04, 2003 at 02:31:37PM -0800, Dean Arnold wrote:
> While trying to test some multiprocessing on Win2K (ActiveState 633), I ran
> into
> an issue I'm hoping you can shed some light on. If I open a $dbh before
> forking
> off some kids that also open some $dbh's, I get the following error
On Tue, Mar 04, 2003 at 04:21:10PM -0800, Dean Arnold wrote:
> > On Tue, Mar 04, 2003 at 02:31:37PM -0800, Dean Arnold wrote:
> > > While trying to test some multiprocessing on Win2K (ActiveState 633), I
> ran
> > > into
> > > an issue I'm hoping you can shed some light on. If I open a $dbh before
On Tue, Mar 04, 2003 at 10:58:22PM -0500, Jeff Thies wrote:
> I have an Access database with funny field names like: REPORT #
>
> I forgot the advice to use square brackets [] and used double quotes
> instead : "REPORT #".
>
> Now, that works fine. But is that going to cause me trouble
> somew
On Wed, Mar 05, 2003 at 02:36:50PM +, Volker I. Lipper wrote:
> Hi Jeff,
>
> the correct syntax in access itself would be:
>
> >#9/30/1999#
>
> the writing of the data (mm.dd or dd.mm or mm/dd) belongs to the
> system variables set on the system acess is installed on. But in
> every case y
On Wed, Mar 05, 2003 at 01:38:58PM -0500, Jeff Thies wrote:
>
>
> Tim Bunce wrote:
> >
> > On Wed, Mar 05, 2003 at 02:36:50PM +, Volker I. Lipper wrote:
> > > Hi Jeff,
> > >
> > > the correct syntax in access itself would be:
> > &g
On Wed, Mar 05, 2003 at 08:13:00AM -0600, Philip Molter wrote:
> I have a very long running Perl process. I recently upgraded the
> DBI from 1.32 to 1.33 (and then 1.34) and now, the process is leaking
> memory. Given the complexity of the project, it's not possible to
> reduce it to a simple tes
Upgrade your DBI. Try 1.34
Tim.
On Thu, Mar 06, 2003 at 10:50:34AM -0500, Yang Li wrote:
> Hi There;
>
> I got following error during installing DBI-1.32 on Linux 6.2 with Perl
> perl-5.00503-12.
>
> Could you give any help? Thanks.
>
> Regards,
>
> Yang
>
> PERL_DL_NONLAZY=1
> /usr/bin/perl
On Wed, Mar 05, 2003 at 08:13:00AM -0600, Philip Molter wrote:
> I have a very long running Perl process. I recently upgraded the
> DBI from 1.32 to 1.33 (and then 1.34) and now, the process is leaking
> memory. Given the complexity of the project, it's not possible to
> reduce it to a simple tes
On Fri, Mar 07, 2003 at 09:24:51AM -0500, Cory Rau wrote:
> Hmmm...I did that. And now I get a different error:
>
>
> Argument " " isn't numeric in repeat (x) at /Library/Perl/darwin/DBD/Proxy.pm line
> 63.
Change the
5 x ' '
to
' ' x 5
on the line with the error. I
ift" in your example? Is
"fetchall_arrayref" still the fastest? What is the syntax of it? could you
use my code above as example of how to use "fetchall_arrayref"?
Also,is $dat->fetch the same as $dat->fetchrow_arrayref?
Thanks.
Guang
> -Original Message-
http://www.google.com/search?q=sql+null+three+value
Tim.
On Fri, Mar 07, 2003 at 04:36:41PM -0500, Rick Nakroshis wrote:
> I just installed DBI v1.34 and DBD-ODBC v1.04 on my AS build 633, and
> have a question about a query that I tried to test the ODBC connection
> to our SQL Server database:
>
file: $CPAN/authors/id/T/TI/TIMB/DBI-1.35.tar.gz
size: 288058 bytes
md5: 8ede0b8817ac8b0db6cc5db36109060c
NOTE: Future versions of the DBI *will not* support perl 5.6.0 or earlier.
: Perl 5.6.1 will be the minimum supported version.
NOTE: The "old-style" connect: DBI->connect($data
On Mon, Mar 10, 2003 at 12:26:51AM -0800, Victor A. Rodriguez wrote:
>
> I run through the same problem a few days ago, and I
> just fetched all the rows in a hash with
> fetchall_arrayref, finish()ed the query and performed
> a do() again.
If you fetch all the rows you should not need to call fi
On Mon, Mar 10, 2003 at 03:17:46PM +0530, murugan mohan wrote:
> Hi all,
>I am trying to know how I can use bind array. I am having Perl version 5.6 and i
> am working in windows 2k.
> what I tried is as follows.
>
> $sth = $g_dbh->prepare(q{
> BEGIN
> test_1.P1(
> ?,
> ?,
> ?,
> ?);
> END;
Thanks for posting the answer for the archives.
Tim.
On Mon, Mar 10, 2003 at 04:54:00PM +, Greg Thompson wrote:
>
> I found an answer to my problem regarding the use of
> mysql_read_default_file and my perl script crashing. According to:
>
> http://www.rosat.mpe-garching.mpg.de/mailing-l
> foreach ( $cgi->param() ) {
>push @cols, $_;
>push @vals, $cgi -> param( $_ );
> }
> my $sql = "INSERT INTO table ( " . join( ", ", @cols ) . " )\n" .
>" VALUES ( " . join( ", ", map { "?" } @cols ) . " )";
Seeing all that 'line noise' makes me think we need a neater way.
Personal
On Mon, Mar 10, 2003 at 02:39:36PM -0800, Jeff Zucker wrote:
> Tim Bunce wrote:
>
> >On Tue, Mar 04, 2003 at 09:32:27AM -0800, Jeff Zucker wrote:
> >
> >>>Or run this command
> >>>
> >>> perl -MSQL::Statement=
> >>>
> >
On Mon, Mar 10, 2003 at 03:47:31PM -0800, Jeff Zucker wrote:
> Paul Boutros wrote:
>
> >my $sql = qq{
> > INSERT INTO table
> >( ${\comma_separated_values(@col)} )
> > VALUES ( ${\comma_separated_placeholders(@col)} )
> >};
> >
>
> I'm not sure I like this, but if it is to be used, a bet
On Mon, Mar 10, 2003 at 10:51:21PM -0500, Matthew O. Persico wrote:
> I am using Perl 5.6.1, DBI 1.32 and DBD::Oracle 1.12. I have decided to upgrade to
> DBI 1.35 BEFORE reporting a problem I am having.
>
> I built DBI 1.35 with no problems. Then I tried to rebuild DBD::Oracle 1.12.
>
> 1) comp
On Mon, Mar 10, 2003 at 10:55:26PM -0500, Matthew O. Persico wrote:
> I am calling bind_param like this:
>
> $sth->bind_param($col_idx,
> $value,
> {TYPE =>?DBI::SQL_VARCHAR});
>
> for a co
a single row. Is there any other better way so
> that I can minimize the calls to the SQL/PL. Please let me know.
I don't think so.
Tim.
> Regards
> Murugan
>
>
> - Original Message -
> From: Tim Bunce
> Sent: Tuesday, March 11, 2003 3:08 PM
> To: muruga
On Tue, Mar 11, 2003 at 07:03:30PM -0500, Matthew O. Persico wrote:
> On Tue, 11 Mar 2003 21:26:56 +1100 (EST), Mark Ashley wrote:
> >
> >So using the truss output I went through each file it was missing
> >and copied it into the local tree. My finished tree consists of:
> This REALLY needs to get
On Tue, Mar 11, 2003 at 09:28:50PM -0500, Matthew O. Persico wrote:
> --- Original Message ---
> From: "M. Addlework" <[EMAIL PROTECTED]>
> To: Matthew O. Persico <[EMAIL PROTECTED]>
> Cc:
> Sent: Tue, 11 Mar 2003 15:59:27 -0800 (PST)
> Subject: Re: Fwd: Cannot bind a single blank space to a non-nu
On Wed, Mar 12, 2003 at 01:46:48PM +0100, Bernhard Donaubauer wrote:
> Hello!
>
> I have a problem to insert NULL values in CLOB/BLOB fields.
I think that's not currently supported. Patches welcome.
Tim.
> In the following example I insert four records into a testtable. The third row
> causes
Just looks like some left-over debugging. If unsigned short
columns are fetched okay then you can probably ignore the warning.
Tim.
On Wed, Mar 12, 2003 at 05:32:07PM +0100, Stephan Harren wrote:
> I did, my first mail was:
>
> ---snip---
> > I'm working on a perl-script connecting to myqsl usin
, that there are no
> "short" columns in MySQL. Maybe my knowledge on databases is too little, but
> maybe you can give me an explanation for that?
>
> Best regards,
>
> Stephan
>
> Am Mittwoch, 12. März 2003 18:47 schrieb Tim Bunce:
> > Just looks like som
On Thu, Mar 13, 2003 at 09:57:12AM +0100, [EMAIL PROTECTED] wrote:
>
> www.perl.com/CPAN should work nicely :)
>
> Latest stable version of DBI would appear to be 1.30. Changes coming a bit
> too fast to call the newer versions 'stable' though (sorry Tim).
No need to appologise.
The only probl
On Thu, Mar 13, 2003 at 07:43:17AM -0600, James.FitzGibbon wrote:
> There is one outstanding issue that I am aware of. We reported a problem
> setting the RootClass
> attribute in DBI v1.30, which was addressed in v1.31. Unfortunately, the
> fix has a small problem.
>
> Here is the original mess
[EMAIL PROTECTED]
7;} eq 'cc') && ($Config{'ccflags'} !~ m/\+z/ &&
> $Config{'ccldflags'} !~ m/\+Z/i) ) {
> print "Warning: perl was not built with +z in ccflags\n"
> . " You may need to rebuild perl from sour
Looks like you're using DBI v1.32. Try DBI 1.35
Tim.
On Fri, Mar 14, 2003 at 02:22:38PM +0800, [EMAIL PROTECTED] wrote:
> Dear sir,
>
> I have a problem with installing the DBI. I get 2 test failed
> when I perform "make test" and "make test TEST_VERBOSE=1".
> Attached is the
> logging message.
Buy this book: "Oracle performance tuning 101". You won't regret it.
Tim.
On Fri, Mar 14, 2003 at 10:54:24AM +0100, Filipe Vasconcelos wrote:
> Hello,
>
> Does anybody has any script that could give, detailed information about the
> performance of an Oracle Database.
>
> regards,
>
> _
After over 18 months of "stability" it gives me great pleasure to
say that the monstrous hunk of rock that is DBD::Oracle is rolling
forward once again...
file: $CPAN/authors/id/T/TI/TIMB/DBD-Oracle-1.13.tar.gz
size: 194630 bytes
md5: bcb1a887ac8f5da415a78fe7abb012b5
Special thanks are due
Please ignore previous test email to [EMAIL PROTECTED]
I'd forgotten that I'd set [EMAIL PROTECTED] to redirect to dbi-users.
Tim.
On Mon, Mar 17, 2003 at 12:04:22PM -0800, Michael A Chase wrote:
> On Mon, 17 Mar 2003 05:07:36 -0600 Moritz von Schweinitz <[EMAIL PROTECTED]> wrote:
>
> > i'd just like to recommend some more hash-friendly routines for these
> > kind of operations. i know that they are relativly tricial to code
finish() should be probably be called discard_pending_results().
It should only ever be used for SELECT statements where you have
not fetched past all the returned rows. (In which case it avoids
the warning message you'd otherwise get.)
Tim.
On Tue, Mar 18, 2003 at 10:17:19AM +0100, alex wrote:
Try DBD::Oracle 1.13.
Tim.
On Mon, Mar 17, 2003 at 03:58:11PM -0800, Maggie Wing (Sun Contractor) wrote:
> Hi.
>
> I've been trying for a week now to install DBD on my
> development machine. I was able to get the DBI installed,
> but make-test (and by extension, yours truly) keeps failing
> w
Thomas, did you get round to doing this?
Tim.
On Wed, Feb 26, 2003 at 10:54:12AM +, Tim Bunce wrote:
> On Tue, Feb 25, 2003 at 05:30:31PM -0500, Thomas Good wrote:
> > On Tue, 25 Feb 2003, Tim Bunce wrote:
> >
> > > > While I was using 5.8 large data transfers
On Wed, Mar 19, 2003 at 10:07:20PM +1000, Brook Schofield wrote:
> I've been unable to install DBD::Oracle on MacOS X
>
> I have:
>
> MacOS X 10.2.4
> Perl 5.8.0
> DBI-1.35
> DBD::Oracle-1.13
> Oracle Developer Editior 9iR2 for MacOS X
>
> the core errors that I receive are during 'make test':
Perl 5.005 is not supported by the DBI. You may find 5.005_03 will work
(but that version is also very old and the DBI soon won't support that).
I'd recommend using perl 5.6.1.
DBI-1.201 is also very old. Try 1.35.
Tim.
On Wed, Mar 19, 2003 at 12:38:43PM +, Venky Karuppur wrote:
> Hello All,
on MacOSX instructions - I just can't try them out.
>
> -Brook
>
> On Thursday, March 20, 2003, at 12:05 AM, Tim Bunce wrote:
>
> >the first step is for you to try manually building one of the Oracle
> >examples.
> >If you can't get that to work then it's v
On Wed, Mar 19, 2003 at 10:21:20PM +, Tim Bunce wrote:
> On Thu, Mar 20, 2003 at 07:59:52AM +1000, Brook Schofield wrote:
> > I haven't yet attempted the examples but I was hoping that the
> > instructions and associated downloads from Tom Mornini
> > ([EMAIL PRO
condly, the removable_symbols_dbd_create.pl logic can be integrated
into Makefile.PL. Thirdly, ... anything else to make life easier...
Tim.
> -Brook
>
> On Thursday, March 20, 2003, at 08:37 AM, Tim Bunce wrote:
>
> >On Wed, Mar 19, 2003 at 10:21:20PM +, Tim Bunce wrote:
&g
- Forwarded message from Carlos Ferreiro <[EMAIL PROTECTED]> -
Delivered-To: [EMAIL PROTECTED]
From: "Carlos Ferreiro" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Oracle 9i and DBD::Oracle
Date: Thu, 20 Mar 2003 09:40:01 +0100
X-MDRemoteIP: 192.168.0.249
X-Return-Path: [EMAIL PROT
I'm sure this could be done with much less code.
Any volunteers to try to create a shorter version?
Perhaps using selectall_hashref().
Tim.
On Fri, Mar 21, 2003 at 04:39:13PM -0800, Colette Lamm wrote:
> I have successfully created code that generates a popup_menu with the fields
> id & name. I wo
On Fri, Mar 21, 2003 at 05:43:08PM -0500, SMITH,MICHAEL C (HP-PaloAlto,ex1) wrote:
> I'm having a problem installing the DBI module on a Red Hat 8.0 system,
> using Perl 5.8.0. There are two problems that show up in the build,
> relating to t/40profile.t test and t/42prof_data.t.
Those problems w
mail list?
>
> Thanks,
> Tom
>
> On Sat, Mar 22, 2003 at 08:06:33PM +, Tim Bunce wrote:
> > On Fri, Mar 21, 2003 at 05:43:08PM -0500, SMITH,MICHAEL C (HP-PaloAlto,ex1) wrote:
> > > I'm having a problem installing the DBI module on a Red Hat 8.0 system,
> > >
Upgrade to DBD::Oracle 1.13 first, then try again.
Tim.
On Mon, Mar 24, 2003 at 04:57:44PM +0100, Salvatore Sorrentino wrote:
>
> Dear Sirs, could you help me in resolving the following error installing
> DBD under Slackware? Here is the error:
>
> bash-2.05a# perl Makefile.PL
> Using DBI 1.33
On Tue, Mar 25, 2003 at 09:04:41AM +0100, [EMAIL PROTECTED] wrote:
> Hi all,
>
>
>
> Currently in a project to convert our existing 7.3.4 and 8.1.7 Databases
> to Oracle9i.( Either the 9.0.1 or 9.2 version ) Now I'm having some
> problems connecting to some test databases I have setup. Do I nee
On Tue, Mar 25, 2003 at 09:06:16AM +0100, Salvatore Sorrentino wrote:
> Thanks for your answer.
> I upgraded to DBD::Oracle 1.13 then I tried again.
> This time things seems better but nevertheless there is an error:
> ocidfn.h and ociapr.h include files are missing.
> Could you please help me agai
om lib to lib32. And to run you are going to have to update
> your SHLIB_PATH to point to $ORACLE_HOME/lib32.
>
>
> Lincoln
>
>
> -Original Message-
> From: Tim Bunce [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 25, 2003 5:38 AM
> To: [EMAIL PROTECTED
e64bitall " to your Configure command to get a nicely working
> 64bit perl on HP, for those interested)
>
> Greetings,
>
> ---
> Frans Postma, (050-58) 81 852
> ATOS Origin, Unix Support
> "If at first you don't succeed, skyd
On Tue, Mar 25, 2003 at 09:55:40AM -0700, Ken Miller wrote:
> I've got a strange problem with Apache::Session, and DBD::Oracle:
>
> [Tue Mar 25 10:01:03 2003] [error] Invoking view: /security/list-users.html
> --> DBH LONG READ LEN: 256000 <--
> --> STATEMENT LONG READ LEN: 256000 <--
> [Tue Mar 2
Smells of memory corruption. Not good.
If you can turn that script into a patch to the t/longs.t that
demonstrates the problem (just to save me some time), I will attempt
to fix it asap.
Just send it direct to me along with a summary of your configuration
(perl -V output, DBI version, Oracle clie
1 - 100 of 2599 matches
Mail list logo