Re[2]: Strange behavior of DBI/DBD::Informix
Hi. I built a new test environment finally. The behavior is the same. No error appears if I disconnect before binding parameters and executing SQL. Here is the new tested versions information: DBI-1.37 DBD-Informix-2003.04 # esql -V INFORMIX-ESQL Version 9.51.UC3 IDS 9.30.UC1 and IDS 9.30.FC1 (both are checked) # perl -V Summary of my perl5 (revision 5.0 version 8 subversion 0) configuration: Platform: osname=solaris, osvers=2.8, archname=sun4-solaris uname='sunos name 5.8 generic_108528-19 sun4u sparc sunw,sun-blade-1000 ' config_args='-ds -e' hint=recommended, useposix=true, d_sigaction=define usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef useperlio=define d_sfio=undef uselargefiles=define usesocks=undef use64bitint=undef use64bitall=undef uselongdouble=undef usemymalloc=n, bincompat5005=undef Compiler: cc='/opt/SUNWspro/bin/cc', ccflags ='-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64', optimize='-O', cppflags='-I/usr/local/include' ccversion='', gccversion='', gccosandvers='' 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', nvsize=8, Off_t='off_t', lseeksize=8 alignbytes=8, prototype=define Linker and Libraries: ld='/opt/SUNWspro/bin/cc', ldflags =' -L/usr/local/lib ' libpth=/usr/local/lib /usr/lib /usr/ccs/lib libs=-lsocket -lnsl -ldl -lm -lc perllibs=-lsocket -lnsl -ldl -lm -lc libc=/lib/libc.so, so=so, useshrplib=false, libperl=libperl.a gnulibc_version='' Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' ' cccdlflags='-KPIC', lddlflags='-G -L/usr/local/lib' Characteristics of this binary (from libperl): Compile-time options: USE_LARGE_FILES Built under solaris Compiled at Jul 14 2003 10:15:15 @INC: /usr/local/lib/perl5/5.8.0/sun4-solaris /usr/local/lib/perl5/5.8.0 /usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris /usr/local/lib/perl5/site_perl/5.8.0 /usr/local/lib/perl5/site_perl . JL> Hi, JL> I' ve remembered - I did a bit of analysis of this and reckoned the trouble JL> was really in DBI. DBD::Informix was not getting an opportunity to say JL> 'this handle has gone missing'. I posted - or thought I posted - a message JL> about it to dbi-dev or dbi-users, but I don't recall seeing it. I'll have JL> to check again that it went - and where I sent it from (office or home - I JL> can't see it at the office, so I have to hope I sent it from home; I JL> remember dummying it up with one of Tim's example drivers - NullP IIRC). JL> -- JL> Jonathan Leffler (jleffler@us.ibm.com) JL> STSM, Informix Database Engineering, IBM Data Management JL> 4100 Bohannon Drive, Menlo Park, CA 94025 JL> Tel: +1 650-926-6921 Tie-Line: 630-6921 JL> "I don't suffer from insanity; I enjoy every minute of it!" Best regards, Alexandre Krasnov. sending to informix-list