the perl-5.8.8 directory). The tricky bit is
getting your new Perl to do it. This seemed to work for me y'day:
../../../perl -I../../../lib Makefile.PL
> Killed
>
> -Original Message-
> *From:* Jonathan Leffler [mailto:[EMAIL PROTECTED]
> *Sent:* Thursday,
ostname Sys/Syslog Thread Time/HiRes Unicode/Normalize
XS/APItest XS/Typemap attrs re threads threads/shared
localtime_r_proto=0
timeincl=/usr/include/sys/time.h
timetype=time_t
Black JL:
If you get anything significantly different, it might be informative and
relevant. OTOH, it may not help in the sli
a
config.over got extended each time I ran the configure. Grump!
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2008.0229 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
Darn the mailing list!
-- Forwarded message --
From: Jonathan Leffler <[EMAIL PROTECTED]>
Date: Thu, Mar 20, 2008 at 10:20 AM
Subject: Re: Make problem Building 64 bit Perl 5.8.8 from source on Solaris
10 with gcc 3.4.6
To: "Vachon, Frederick P (Fred) A5IT" &
rongly suspect this would apply to any DBMS where the client is in
a separate process from the DBMS.
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2008.0229 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
time. So, I'm willing to assist in the
mentoring, but would hope/expect to have at least one other major DBMS
driver writer on the team to ensure that things stay balanced.
I need my head seeing to. I must remember that word, what is it now? ...
Oh, yes; I remember.
"No".
Another time, perhaps. :)
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2008.0229 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
40 needs to be resolved.
Support email address:
* This release is supported by Jonathan Leffler <[EMAIL PROTECTED]>.
* You may also report your bugs via the CPAN resolution tracking system:
http://rt.cpan.org/
* Such bug reports can be sent by email to [EMAIL PROTECTED];
they also g
orresponding format string conversion
> sprintf(s_tz_hour," %02ld",tz_hour);
>^
>
> "oci8.c", line 1364: warning #2181-D: argument is incompatible with
> corresponding format string conversion
> sprintf(s_tz_min,":%02ld",tz_minute);
>^
>
> "oci8.c", line 1365: warning #4212-D: mismatch between character pointer
> types
> "text *" and "char *"
> strcat(str_buf,s_tz_hour);
> ^
>
> "oci8.c", line 1366: warning #4212-D: mismatch between character pointer
> types
> "text *" and "char *"
> strcat(str_buf, s_tz_min);
> ^
>
> "oci8.c", line 916: warning #4275-D: constant out of range ([0 -
> 4294967295])
> for the operator
>New(42, buffer, buflen, ub1);
>^
>
> "oci8.c", line 1821: warning #4275-D: constant out of range ([0 -
> 4294967295])
> for the operator
>Newz(1, obj->fields, (unsigned) obj->field_count,
> fbh_obj_t);
>^
>
> "oci8.c", line 2021: warning #4275-D: constant out of range ([0 -
> 4294967295])
> for the operator
> Newz(42, imp_sth->fbh, num_fields, imp_fbh_t);
> ^
>
> Running Mkbootstrap for DBD::Oracle ()
>chmod 644 Oracle.bs
>rm -f blib/arch/auto/DBD/Oracle/Oracle.so
>/usr/bin/ld
> -Wl,+b"/usr/oracle/client/10.2/lib:/usr/oracle/client/10.2/r
> dbms/lib" -b +vnocompatwarnings -L/usr/lib/hpux64 Oracle.o dbdimp.o
> oci8.o -L
> /usr/oracle/client/10.2/rdbms/lib/ -L/usr/oracle/client/10.2/lib/
> -lclntsh `c
> at /usr/oracle/client/10.2/lib/ldflags` -lm -lpthread -o
> blib/arch/auto/DBD
> /Oracle/Oracle.so \
>\
>
> ld: Unrecognized argument:
> -Wl,+b/usr/oracle/client/10.2/lib:/usr/oracle/client/10.2/rdbms/lib
> Fatal error.
> *** Error exit code 1
>
> Stop.
> -
>
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2007.0914 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
t; Any help is much appreciated.
Why do you want to 'use DBD::Sybase' given that the working example shows
that it is not necessary to do so?
If you were importing some specific symbols from DBD::Sybase, it would make
sense - but you aren't self-evidently doing that, so it doesn'
> I know nothing about hpux, do have extensive experience perusing
> documentation.
>
> A good start would be to read the extensive instructions in
> README.hpux.txt. (perldoc README.hpux.txt)
>
> Jared
>
>
>
>
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2007.0914 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
rry if I wasn't clear enough in my previous mail.
>
OK - fair enough. With DBD::Informix the Name is the 'DSN' supplied at
connection time. There's a separate ix_Database attribute (in the private
namespace) that gives the current database name. If you can change
databas
ble post without waiting for an answer or explaining
your double post.
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2007.0914 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
ects the law will help you other than
by telling you to get them from Oracle.
Please wake up, read the messages, and act on them.
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2007.0914 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for
e fixed in a general release of DBI?
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2007.0914 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
[*] 64-bit mode: or it might be on a 32-bit mach
at for
> anything longer than about 60 characters, q() and '' and everything else
> start to look horribly inelegant.)
>
q{}; q%%; q[];
On occasion, I've done evil things like q"" and qq'' -- it seemed like a
good idea at the time.
>
> Thanks.
>
> Colin
>
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2007.0914 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
This I agree seems to be missing some data - two characters as you say. You
are fortunate that your SQL does not contain any single quotes, of course --
that's the SQL injection issue above.
> Can't call method "execute" on an undefined value at
> ../../bin/DBhealthParseDB.
> l line 655, line 319.
>
This is because you ignored the error from prepare and blithely tried to use
the $sth that wasn't available.
>
> Issuing rollback() for database handle being DESTROY'd without explicit
> disconn
> ct(), line 319.
>
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2007.0914 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
t your current directory is not where the DBI source code is.
It is good that you have both Sun Studio and GCC available; the build will
use the same one as was used to build Perl. That should save you angst
later.
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix -
there is no error message from the compiler - but it appears
that the compilation failed.
Do you have gcc installed?
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2007.0914 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
lt;[EMAIL PROTECTED]>
Hello Jonathan Leffler
I try to install the DBI package but it failed. Can you please help?
thanks.
My os is HP-UX 11.23,perl version 5.8.8.
---
1、perl Makefile.PL
Set up gcc environment - 4.2.1
*** You are using a perl configured with thre
nough to say why cc ends up in the
> OTHERLDFLAGS, since its not a flag? Is there something I should add to the
> commandline of Makefile.PL when I run it?
>
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2007.0914 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
itializers not shown...
my $dbh = DBI>connect("dbi:Oracle:host=$host;port=$port;sid=$sid", $user,
> $passwd) or die "Unable to connect: $DBI::errstr";
There's a typo above: DBI->connect
my $statement = 'SELECT * FROM table';
> $sth = $dbh->prep
On 9/27/07, Clive Eisen <[EMAIL PROTECTED]> wrote:
> Jonathan Leffler wrote:
> > On 9/27/07, Clive Eisen <[EMAIL PROTECTED]> wrote:
> >> I seem to have a problem with negative int8 on a 64 bit linux platform
> >>
> >> dbaccess gives the correct an
ing = $pings_remaining\n";
>
> [EMAIL PROTECTED]:~> perl test.pl
> pings_remaining = 4294710784
>
>
> Any help gratefully received
Dear Clive,
Unfortunately (for you - fortunately for me), Perl 5.8.8 with 64-bit
CSDK 3.00.FC2 on Solaris 10 correctly produces the negative a
s in
> > perl_clone: ... 22839 [perl #29790] Optimization busted: '@a = "b",
> > sort @a' ... 22850 [PATCH] 'perl -v' fails if local_patches contains
> > code snippets 22852 TEST needs to ignore SCM files
> > 22886 Pod::Find should ignore
/07_Database_Interfaces
http://dbi.perl.org/
** When you successfully build this module, use the ItWorks (Perl)
** script to report your configuration to the maintenance team (meaning
** Jonathan Leffler) at [EMAIL PROTECTED]
** The ItWorks script does not send email to anybody; you have to do
** that
re may be
sufficiently good freebies from MS for my purposes - but it just adds
to the complexity of the job. "Cobbler's Children" springs to mind as
an epithet - so does "over-worked, under-paid".
> >From: "Jonathan Leffler" <[EMAIL PROTECTED]>
>
Oops - omitted dbi-users; sorry.
-- Forwarded message --
From: Jonathan Leffler <[EMAIL PROTECTED]>
Date: Aug 27, 2007 6:43 PM
Subject: Re: DBI::Informix and DBD::Informix
To: Martin Gainty <[EMAIL PROTECTED]>
On 8/27/07, Martin Gainty <[EMAIL PROTECTED]> wr
/07_Database_Interfaces
http://dbi.perl.org/
** When you successfully build this module, use the ItWorks (Perl)
** script to report your configuration to the maintenance team (meaning
** Jonathan Leffler) at [EMAIL PROTECTED]
** The ItWorks script does not send email to anybody; you have to do
** that
ck of code - lines 2192 to
2211. If you prefer to leave it there, then you'll have to embed it
in comments, but there are already comments in that section, so it
ain't trivial. Alternatively, wrap the #if 0 / #endif section in
"$ifdef POLLYWOGS_ARE_STUPENDOUS;" and "$endif;&qu
ween processes (It's too difficult to keep the processess
> from messing with each other). Even if your database does support it, it
> is unlikely that the JDBC driver and the DBD driver also support it in
> a compatible way, so I wouldn't bother and just open a new connection.
--
e
excruciatingly hard and revoltingly error prone and most probably
wholly unportable (across platforms and across DBMS)..
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2007.0226 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease
to be amused."
s of Programming Style" by Kernighan & Plauger, it says
words to the effect that:
A wise programmer once said 'moving floating point numbers is like moving
sand piles; every time you do, you lose a little sand and you pick up a
little dirt'.
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2007.0226 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
T
Built under solaris
Compiled at Nov 14 2003 17:42:31
@INC:
/apps/iw-home/iw-perl/lib
/apps/iw-home/iw-perl/site/lib
/apps/iw-home/iw-perl/vendor/lib
Oh, and for whatever it is worth, a default build of GCC 4.2.0 needs about 2
GB disk space in the object directo
" set "NUM_OF_FIELDS" to 0 (though it may be undef in some
>drivers).
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2007.0226 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
llow for
a lot of control and information for which there is no corresponding C API,
sadly.
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2007.0226 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
Perl
will; Oracle I won't answer for), then DBI and DBD::Oracle will too.
Will the Oracle database be installed in a fixed location on all machines?
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2007.0226 - http://dbi.perl.org
"Blessed are we who c
circumstances under which it fails are obscure is to be
excessively polite.
I tried to release an update to DBD::Informix, but the release process goes
through the test suite, and since the test t/t93lvarchar.t was failing, it
was not possible to make the release automatically, so I haven'
has is on the visibility of
the problem - some versions of DBI make it easier to spot the trouble than
others - probably on a platform-specific basis.
Or, IOW, this is one of those hard bugs - I'm having trouble locating the
real problem.
--
Jonathan Leffler <[EMAIL PROTECTED]> #inc
postings dating
> from 2002-2005.)
> Is this anything to be concerned about if I have no columns of type
> "lvarchar not null"?
> Any recommendations?
>
> A bug report for "D t/t93lvarchar.t" is attached.
>
> Thank you for your assistance.
> --
> Mark Abajian
>
>
>
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2007.0226 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
of the query.
Does anyone have any idea of how can I fix this problem and eliminate this
error
message?
Thanks very much.
I've seen you send this several times. Have you contacted the
[EMAIL PROTECTED] email address as documented?
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
d of
the half-dozen needed; that might generate an error, though I'd not want to
rely on that.
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2007.0226 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
en the appropriate data. The module
is unlikely to be under the DBI or DBD hierarchies, so there's at least some
argument that the question is inappropriate for this list.
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2007.0226 - http://dbi.perl.org
"
dress and get more
information.
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2007.0226 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
Ooops; most of the mailing lists I work with redirect responses to the
list. I forget this one doesn't.
-- Forwarded message --
From: Jonathan Leffler <[EMAIL PROTECTED]>
Date: May 1, 2007 6:32 AM
Subject: Re: Proposal for new $h->{ReadOnly} attribute
To: &
point is - Perl 5.6.1 is not valid (though you can try it and the best
of British); 5.6.2 is OK but you may run into issues.
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2007.0226 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
n a more general Perl
forum - such as one of the comp.lang.perl.* news groups.
Alternatively, show the DBI code that is giving problems...but we will not
be very interested in debugging the supporting CGI-related bits'n'pieces
(which is where it sounds as if your problem is).
--
Jonathan
| I'd be programming in Java.
| | | [EMAIL PROTECTED] | I don't, and I'm not.
__/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi-users
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2007.0226 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never lack
amusement."
I'd not gotten around to Perl
at that point - with the older compiler.
You need to use the same compiler that was used to build the perl you're
building DBI for.
Often that means building and installing your own, separate, perl.
Was the gcc you are using built for/on Solaris 10?
the system copy of Perl strictly alone - well, I would
(and do)
leave the system Perl well alone and install my own version of Perl
elsewhere).
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2007.0226 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
a module DBI at version 1.54, there is also a module file::Spec that needs
to be at version 1.00 or greater, and your version of it is 0.86.
So - go get it from CPAN and install it. (And I suggest you get a newer
Perl while you're at it, but that is not mandatory.)
--
Jonathan Leff
COMMITTED
| READ UNCOMMITTED }
READ WRITE | READ ONLY
I suspect you'll find that this 'turns off autocommit' for you.
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2007.0226 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
)
** script to report your configuration to the maintenance team (meaning
** Jonathan Leffler) at [EMAIL PROTECTED]
** The ItWorks script does not send email to anybody; you have to do
** that yourself.
New in release 2007.0226:
* Support for CSDK 3.00.
* Minor bug fixes.
* No exploitation of new
ata/Dumper.pm
line 5
That version number doesn't appear in the source, so I assume it isn't your
problem.
'perl -V' below signature.
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer
or exit code 1
sem_perm is likely to be part of or related to . Fix
the first and I expect the second will go away too.
Stop.
please help in installing this.Thanx in advance.Waiting eagarly for the
reply
I'm always tempted to leave such mails unanswered for a few days... :-(
--
Jon
Failure Keeps u Humble, Success keeps u Glowing, But only God Keeps u
Going.."
Thanx & Regards
Anupam Sarkar
Software Developer
Baysquare Technologies
Plot No. 66,Street No. 13
MIDC,Andheri(East)
Mumbai 400093
India
Phone:022-28254266
Mobile:9892233493
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
DBD::Informix pretty thoroughly ignores LongReadLen - it won't make any
difference. A MULTISET is not a LOB type, anyway, so it is far from clear
that LongReadLen should affect it.
You're suffering from an itch I've not been suffering - want to do the "Open
Source thing" and scratch your itch? Patches (or new maintainers)
gratefully accepted.
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
205 6 11 15-16 19
t/t65updcur.t 1 256162 7 15
3 tests skipped.
Failed 3/55 test scripts. 11/834 subtests failed.
Files=55, Tests=834, 17 wallclock secs ( 9.53 cusr + 0.71 csys = 10.24
CPU)
Failed 3/55 test programs. 11/834 subtests failed.
*** Error code 29
make: Fatal error: Command failed for target `test_dynamic'
To get verbose test output of the three tests:
sh test.verbose.sh t/t4[13]* t/t65*
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
.1? Use 5.8.8!
It appears that your Perl was built with GCC but you don't have GCC on your
machine.
Install GCC - and then the fun continues...
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
of Perl.)
Regards, Joe
-Original Message-
*From:* Jonathan Leffler [mailto:[EMAIL PROTECTED]
*Sent:* Thursday, February 08, 2007 2:38 PM
*To:* Wholey, Joseph (GTI)
*Cc:* DBD::DB2 Maintenance Team; DBI Users Mailing List
*Subject:* Re: perl DBD and DBI for 64 bit perl
On 2/8/07, Wholey, Jose
ld correctly.
DBD::DB2 Maintenance Team - please note this suggested change; validate and
fix for the next release of DBD::DB2. Thanks!
Thanks again...
Regards, Joe
-Original Message-
*From:* Jonathan Leffler [mailto:[EMAIL PROTECTED]
*Sent:* Thursday, February 08, 2007 1:14 PM
*To:*
uot;03060106".
Informational tokens are "DB2 v8.1.3.112", "s060429", "MI00159", and
FixPak
"12".
Product is installed at "/opt/IBM/db2/V8.1".
-Original Message-
*From:* Jonathan Leffler [mailto:[EMAIL PROTECTED]
*Sent:* Thursday, Febru
rying to compile as well as the perl version.
DBI-1.51
DBD-DB2-0.78
[EMAIL PROTECTED] DBD-DB2-0.78]# perl -v
This is perl, v5.8.5 built for x86_64-linux-thread-multi
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
l issues are
then down to specifying the correct library directories (/usr/lib/sparcv9,
IIRC, for example, instead of /usr/lib).
-Ursprüngliche Nachricht-
Von: Jonathan Leffler [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 6. Februar 2007 00:56
An: Wholey, Joseph (GTI)
Cc: dbi-users@perl.org
ng DBI with your pre-built 64-bit Perl?
Do you want a pre-built 64-bit Perl?
If so, for which platform? The version I have on Solaris 8 may not be all
that much use to you.
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don&
;
>
> > cat /etc/profile.d/informix.sh
> export INFORMIXDIR="/opt/informix"
> export INFORMIXSERVER=pmuk2
> export LD_LIBRARY_PATH=/opt/informix/lib:/opt/informix/lib/esql/
> PATH=/opt/informix/bin:${PATH}
> export ACCEPTLICENSE=yes
> export DBANSIWARN="&
I'd use the privileges then, but only then.
[Aside: I'm not sure why you feel having DBANSIWARN set is a good idea.]
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
tion and
configuration of DB2 Connect - no need to mention DBD::DB2.
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
On 1/23/07, Martin Evans <[EMAIL PROTECTED]> wrote:
Thanks Jonathan,
Jonathan Leffler wrote:
> DBD::Informix is careful about errors.
I would hope all DBDs are ;-)
> Each statement handle keeps a copy of its most recent status/error
> information out of the global sqlca var
available. I notice the connection handle (with
DBD::Oracle) also contains the same error number/string and this would
be great except for the fact we use multiple DBDs.
Thanks.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
--
Jonathan Leffler <[EMAIL PROTECTED]>
On 1/19/07, Jonathan Leffler <[EMAIL PROTECTED]> wrote:
The solution I proposed works [...]
I sent it on the 17th. Unfortunately, I only sent it to Oscar, not to
dbi-users as well.
Sorry - my mistake - both then and earlier today.
This subject should now be closed.
--
Jonathan L
ation is prohibited. Please notify
the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
ve all released (and probably some unreleased)
versions back to 0.23, but they already seem to have those (or enough that
the difference is unlikely to matter). The versions prior to 0.25 are under
Alligator Descartes' directory, not mine.
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
shrplib=true, libperl=libperl.so
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-R
/usr/perl5/5.00503/sun4-solaris/CORE'
cccdlflags='-KPIC', lddlflags='-G'
Characteristics of this binary (from libperl):
Built under solaris
C
);
...
}
I can find no reason why the system call to the 'mv' command fails, and
the Perl 'rename' function works, and better yet, why the 'mv' system
call is used in one sub-module, and the Perl 'rename' function in
another sub-module.
I am planni
ulong' defined? It isn't immediately obvious to me:
$ grep -l ulong /usr/include/*.h /usr/include/*/*.h
/usr/include/slapi-plugin.h
/usr/include/i386/types.h
/usr/include/openssl/x509v3.h
/usr/include/php/acconfig.h
/usr/include/ppc/types.h
/usr/include/tidy/fileio.h
/usr/include/tidy/pla
er';
$dbh = DBI->connect ("dbi:$dbd:$dbname",$user, $password);
But need to be able to connect with user identified externally (as
before).
I cannot find documentation on proper syntax or if a fix was made in
later version of DBI.
Can anyone help?
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
chine where things are broken to match the machine where things work.
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
le/app/oracle/product/oas10.1.2.0.2/perl/lib/5.6.1/i86pc-sol
> aris/DynaLoader.pm line 25.
[...]
And for the rest, note that 5.6.1 in the Oracle pathway - it isn't the same
as 5.8.x that you're using.
Either downgrade to Perl 5.6.1 or upgrade the Oracle stuff to Perl 5.8.x.
g - what you
need is an array of values, with the ccompid value at the end and the other
values in sequence. So, build the SQL statement one item at a time and add
the corresponding value to an array.
You then pass the array to the $sth->execute() call.
--
Jonathan Leffler <[EMAIL PROTECTED
On 11/9/06, Bart Lateur <[EMAIL PROTECTED]> wrote:
On Wed, 8 Nov 2006 23:26:02 -0800, Jonathan Leffler wrote:
> Bart Lateur <[EMAIL PROTECTED]> asked:
>>And 2), in a fetch loop, is it possible to adjust a property like
>> {ReadLongLen}, and retry the same fetch w
Because this error typically happened several minutes into the
loop.
Highly unlikely. The data has been fetched - and truncated. There's not
usually a way to refetch the same row - unless you have a scroll cursor, and
DBI doesn't have support for those.
--
Jonathan Leffler <[EMAIL PRO
DBD::Informix : 2005.02
DBD::File : 0.35
DBD::ExampleP : 11.12
DBD::DBM: 0.03
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
your
options.
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
: get GCC and build your own Perl with it.
His Perl was version 5.8.7; yours is 5.8.3; the differences are
immaterial to this problem.
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
cursion in macro "PerlIO".
*** Error exit code 1
You're using the bundled C compiler which is not an ANSI C compiler.
Your Perl was built with the HP ANSI C compiler.
Either: get the HP ANSI C compiler
Or: get GCC and build your own Perl with it.
--
Jonathan Leffler <[
uot;Database Hacker's Handbook" for more information. See also Ron
Ben-Natan's "Implementing Database Security and Auditing".
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
Message
From: Paul Adelaide <[EMAIL PROTECTED]>
To: Jonathan Leffler <[EMAIL PROTECTED]>
Sent: Saturday, July 22, 2006 7:46:47 AM
Subject: Re: perl DBI-1.51 install error
Ok I will start all over again. The following are the steps I need to
take right? I am going to re-com
l using that compiler, and then you can build and install DBI and
DBD::Informix.
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
t as soon as one child exits, the handle is lost.
Is the best solution to use connect_cached?
No; the best solution is to connect in each child process. Anything else is
unreliable.
I'm pretty sure this is covered in 'perldoc DBI' - it certainly should be.
--
Jonathan Leffler &l
mand is 127.
This is the first module you've added (that needs a C compiler)?
The Perl you're using was built with a compiler you don't have.
Either obtain the compiler used to build Perl (possibly by fixing your PATH)
or build Perl with the compiler you have. Anything much els
disconnect;
}
sub test_subroutine
{
while (1)
{
test_connection;
print "Connections: $conn_count\n" if ($conn_count % 1000 == 0);
}
}
memory_leak_test(\&test_subroutine);
exit;
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2005.02
ui retourner le présent message, puis
d'effacer immédiatement ce message de votre système
***
This e-mail and any
attachments is a confidential correspondence intended only for use of the
individual or entity named above. If you are not the intended recipient or the
agent responsible for delivering the message to the intended recipient, you are
hereby notified that any disclosure, distribution or copying of this
communication is strictly prohibited. If you have received this communication
in error, please notify the sender by phone or by replying this message, and
then delete this message from your system.
-- Jonathan Leffler <[EMAIL PROTECTED]> #include Guardian of DBD::Informix - v2005.02
- http://dbi.perl.org"I don't suffer from insanity - I enjoy every minute of it."
errstr\n");
}
$sth->finish;
__CODE_ENDS__
Of course, $sth->cursor don't really exist (as far as I know).
TIA!
--
pDale Campbell
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
the transaction, you call
$dbh->commit or $dbh->rollback. If AutoCommit is on, then maybe the
transaction is completed on finish.
while (my @one_group = $groups_query->fetchrow_array)
> {
> print @one_group;
> }
>
>#place 2
>
> --
>
> Can
b/perl5/site_perl/5.8.7/sun4-solaris
/usr/local/lib/perl5/site_perl/5.8.7 /usr/local/lib/perl5/site_perl/5.6.1
/usr/local/lib/perl5/site_perl .) at t/t98pod.t line 5.
BEGIN failed--compilation aborted at t/t98pod.t line 5.
t/t98poddubious
Test returned status 2 (wstat 512, 0x200
7;
ccversion='', gccversion='3.3.2', gccosandvers='solaris2.8'
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
ivtype='long', ivsize=4, nvtype='double
1
/usr/local/lib/perl5/site_perl
esql -v
---
IBM Informix CSDK Version 2.90, IBM Informix-ESQL Version 2.90.FC4
Software Serial Number AAA#B000000
dbaccess -V
DB-Access Version 9.21.UC6
Software Serial Number AAD
e clause to create a tabel catalog query. Yuk.
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
or I'm just calling something
wrong. But any help would be appreciated.
There's a chance I misinterpreting the symptoms - I'm not a DB2 expert.
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
<>
+ setenv INFORMIXC = /usr/local/bin/perl esqlcc
+ setenv ESQLCC = gcc -B/usr/ccs/bin/
gcc: esqltest.o: No such file or directory
gcc: esqlc_v6.o: No such file or directory
gcc: language arch=v9 not recognized
Failed to link test program esqltest
Govinda Pfister
Remedy Approved Consultant, Clarify Certified Consultant, ITIL-Certified
Projectcenter Business Process Solutions
Solution & Service Center Business Enabling Solutions
Global Competence Center
T-Systems Enterprise Services GmbH
Memmelsdorfer Str. 209a, 96052 Bamberg
+49 951 4097-161 (Tel)
+49 951 4097-200 (Fax)
E-Mail: Govinda.Pfister <mailto:[EMAIL PROTECTED]> @
t-systems.com
Internet: <http://www.t-systems.com/> http://www.t-systems.com
--
Jonathan Leffler <[EMAIL PROTECTED]> #include
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."
101 - 200 of 540 matches
Mail list logo
