Weird. My alarm(2) takes 14 seconds? Is DBD::Informix or something else
overriding my $SIG{ALRM}?
If I substitute the connect() call with a sleep 10, then my alarm(2)
takes 2 seconds, as I expected. :)
Thanks,
j
$ cat j.t
use strict;
use DBI;
my $dbh;
eval {
local $SIG{ALRM} = sub { die
Oops. I noticed my versions were behind. I upgraded DBI and
DBD::Informix.
I'm still getting the same behavior (14.3 seconds to time out), so I'm
still curious about what might be going on.
Thanks,
j
$ perl -MDBI -e'DBI-installed_versions'
Perl: 5.008004(i686-linux)
OS
I did get quite a few build errors though, and only half of
them (or so) are listed in
DBD-Sybase-1.06/README.freetds
so I thought I'd post my build dialogue here. I'm ignoring
all the errors below unless someone slaps me.
Looks like last year I threatened to attempt to patch the
diff -ruN exec.t.original exec.t
Hmm... The patch was longer than the file.
If you prefer, here's the full contents of the modified file.
j
#!perl
#
# $Id: exec.t,v 1.8 2005/06/27 18:04:18 mpeppler Exp $
use lib 'blib/lib';
use lib 'blib/arch';
use lib 't';
use _test;
use strict;
#use
The subject of those last 2 emails I sent (and this one) should have been
DBD::Sybase success, build errors
I don't know how I hosed that. I'll make sure it's correct on any followup.
My apologies,
j
The good news is with:
Perl: 5.008007(i686-linux)
OS : linux (2.4.21-243-default)
DBI : 1.48
DBD::Sybase : 1.06
freetds v0.63
(./configure --prefix=/usr/local/freetds --with-tdsver=7.0)
I can connect to and query the following
Not us. We use DBD::Sybase and FreeTDS to connect to MS-SQL from Linux.
Could you give me a pointer on how to set this up?
I did a couple of tests the other day but I couldn't make it work.
Maybe our Intranet document will help you? I attached it. If not, I'll need a
lot more info about
Has anyone made this work?
Not us. We use DBD::Sybase and FreeTDS to connect to MS-SQL from Linux.
j
Thanks for using the error reporting mechanism supplied with
DBD::Informix (or providing the equivalent information); it makes it
so much easier to help you when the necessary information is all
available.
:) Hey, I'm very willing to do whatever I can do to help you help me. -grin-
Do I
Do I need to manually build a 64-bit Perl on this AIX box? Will that offset the
problem?
Thanks,
j
Installing DBD::Informix...
# perl Makefile.PL
*** ExtUtils::AutoInstall version 0.61
*** Checking for dependencies...
[Core Features]
- DBI ...loaded. (1.47 = 1.33)
[High Resolution
It looks like DBD::Sybase is still working (after forcing the install), but I
thought I'd report these test failures. Seeing 86.84% okay is pretty scary.
-grin-
Thanks!
j
freetds-0.62.4
# perl -MDBI -e 'DBI-installed_versions'
Perl: 5.008004(i686-linux)
OS
On Mon, 2004-11-29 at 18:56, Jay Hannah wrote:
It looks like DBD::Sybase is still working
For certain values of working.
Indeed. The story of my life. -grin-
FreeTDS unfortunately does not yet implement the full Client Library
API, so there are a number of things that don't work
Hypothetically*, would you have any interest in a patch to exec.t
(etc.) that would use Test::More and the SKIP blocks documented
therein to skip tests if $ENV{SYBASE} =~ /freetds/?
Sure.
Patches are always welcome!
I asked because I'd be *changing* how exec.t (etc.) work -- to use
FWIW,
My company turns about $480M annually. We continue to (aggressively) expand
our use of Apache / Perl / DBI.
j
---
From: Oscar Gomez [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: perl future
Date: Mon, 8 Nov 2004 13:14:48 -0500
all the applications of my company work with
From: Tim Bunce [mailto:[EMAIL PROTECTED]
On Mon, Feb 16, 2004 at 07:46:49PM -0600, Jay Hannah wrote:
...it seems that it is being thrown in global destruction in the 2 DBD's
I use the most...
DBD::Informix - Informix 9.3:Issuing rollback() for database...
DBD::Informix
- Anyone presenting?
- BOF (Birds of a Feather)?
- Who's coming?
I went last year and learned a lot. I'm still sad Tim couldn't make it. I wanted to be
one of his groupies.
j
From: Tim Bunce [mailto:[EMAIL PROTECTED]
But the Issuing rollback() warning is now only generated if AutoCommit
is turned off and Executed is true.
I'll miss the warning. It was an easy way to know I or my programmers were being
sloppy with explicit disconnects.
Enterprise wide all our
From: Andrew Pimlott [mailto:[EMAIL PROTECTED]
On Mon, Feb 16, 2004 at 03:46:28PM -0600, Jay Hannah wrote:
I would *love* to set another flag/whatever so DBI would bark at us
whenever $dbh's were garbage collected.
Can I ask exactly what you are worried about?
...
Or am I missing some
Kudos all!! We've got our first production DBI server up and running under 5.8.2 and
DBD::Informix and DBD::Sybase (freetds to MS-SQL servers). Everything seems to be
churning along just fine.
perl -MDBI -e 'DBI-installed_versions'
Perl: 5.008002(i686-linux)
OS
From: Edward Pang [mailto:[EMAIL PROTECTED]
I'm installing DBI on my AIX4.3.3 (4330-10) system. I use gcc-3.3.2 and I have
installed perl 5.8.0. But I got following error when run make command:
FWIW, after much main and suffering we gave up on building Perl / DBI / DBD::Informix
(gcc or cc)
From: Jay Hannah [mailto:[EMAIL PROTECTED]
FWIW, after much main and suffering
errr... s/main/pain/
I blame AIX for that typo. That's usually a safe bet.
Grin,
j
From: Dean Arnold [mailto:[EMAIL PROTECTED]
Just curious if anyone else got the latest issue of Dr. Dobbs, and read the
article Networks, ODBC, Perl. I couldn't find a single reference to DBI,
I would certainly think a general DBI discussion (rather than just ODBC) would be a
much more
From: Jonathan Leffler [mailto:[EMAIL PROTECTED]
If you (and Darryl) could send me outputs of 'perl -V' from your
working versions of Perl + DBI + DBD::Informix, it may help
me - thanks.
All that fun stuff is in my original post:
Subject: DBD::Informix, AIX 5.1 -- no joy w/ AIX C or gcc
From: Priest, Darryl - BALTO [mailto:[EMAIL PROTECTED]
Did you build your own perl, or are you using the perl shipped with AIX?
I built 5.8.0 myself, first w/ AIX's C compiler (w/ all patches circa July 2003)
lslpp -l | grep C for
vac.C 6.0.0.4 COMMITTED C for AIX
What's the output from perl -V?
You're replying to my 2nd post. My 1st one (15 minutes
earlier) has exhaustive diagnostics in it, including perl -V.
Doh! I botched the subject line on my second post, breaking this thread from the
original, which is undoutedly why you didn't see my first
.
Thanks,
Jay Hannah
---
/opt/freeware/bin/perl -V
---
Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration:
Platform:
osname=aix, osvers=4.3.3.0, archname=ppc-aix
uname='aix emperor 3 4 000289424c00 unknown
From: Priest, Darryl - BALTO [mailto:[EMAIL PROTECTED]
Your lslpp looks identical to what I have, with the remaining caveat that
I'm on 5.2. However, I now remember that I needed to remove the
'-qlanglvl=ansi' compile option from the Makefile to get it
to compile.
So you used AIX's
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
cs_ctx_global() to cs_ctx_alloc().
---
Thanks for the memories Michael!
Grin,
Jay Hannah
Application Development Manager
Omni Hotels Reservation Center
Tel: (402) 952-6573
Mobile: (402) 578-3976
Email: [EMAIL PROTECTED]
In an ideal
%somelabels ],
-default = 4,
-labels = \%somelabels
);
---
HTH,
Jay Hannah
Application Development Manager
Omni Hotels Reservation Center
Tel: (402) 952-6573
Mobile: (402) 578-3976
Email: [EMAIL PROTECTED]
In an ideal world, one
are good. -grin- The
performance/efficiency hit is rarely noticeable in my environment.
$0.02,
Jay Hannah
Application Development Manager
Omni Hotels Reservation Center
Tel: (402) 952-6573
Mobile: (402) 578-3976
Email: [EMAIL PROTECTED]
In an ideal world, one of the luxuries of a luxury hotel would
that plunge a couple weekends ago. -grin-)
Cheers,
Jay Hannah
Application Development Manager
Omni Hotels Reservation Center
[EMAIL PROTECTED]
V: 1-402-952-6573
F: 1-402-334-8013
-Original Message-
From: [EMAIL PROTECTED] [mailto:rino.mail;libero.it]
Sent: Friday, October 25, 2002 3
the problem.
Jay Hannah
Application Development Manager
Omni Hotels Reservation Center
[EMAIL PROTECTED]
V: 1-402-952-6573
F: 1-402-334-8013
-Original Message-
From: Brad Smith [mailto:mata;matatech.tzo.com]
Sent: Monday, October 21, 2002 8:00 PM
To: [EMAIL PROTECTED]
Subject: Strange
33 matches
Mail list logo