473,403 Members | 2,183 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,403 software developers and data experts.

recordset error/perl messages

Hi All,

I have a problem using DBIx::RecordSet. I get correct results but continue
to get these messages on stderr. I looked at Compat.pm and it seems to be
pointing out a problem with my call to Setup. Could anyone (much thanks)
shed some light on my tired eyes? See below...

Gary

code sample:
*set = DBIx::Recordset-> Setup ( {'!DataSource' => "dbi:mysql:database=$opt_db;host=127.0.0.1",
'!Username' => $user,
'!Password' => $password,
'!Table' => $opt_table,
} );
error message:
gen1:/home/mysql_dev # ./dbutil.pl -d t -t abc
returning default for NumericTypes on driver mysql at /usr/lib/perl5/site_perl/5.8.1/DBIx/Compat.pm line 517
DBIx::Compat::GetItem('mysql','NumericTypes') called at /usr/lib/perl5/site_perl/5.8.1/DBIx/Database.pm line 212
DBIx::Database::Base::QueryMetaData('DBIx::Records et=HASH(0x8538138)','abc') called at /usr/lib/perl5/site_perl/5.8.1/DBIx/Recordset.pm line 240
DBIx::Recordset::SetupDBConnection('DBIx::Recordse t=HASH(0x8538138)','dbi:mysql:database=t;host=127. 0.0.1','abc','root','sql!my','undef') called at /usr/lib/perl5/site_perl/5.8.1/DBIx/Recordset.pm line 334
DBIx::Recordset::New('DBIx::Recordset','dbi:mysql: database=t;host=127.0.0.1','abc','root','sql!my',' undef') called at /usr/lib/perl5/site_perl/5.8.1/DBIx/Recordset.pm line 432
DBIx::Recordset::SetupObject('DBIx::Recordset','HA SH(0x85381b0)') called at /usr/lib/perl5/site_perl/5.8.1/DBIx/Recordset.pm line 595
DBIx::Recordset::Setup('DBIx::Recordset','HASH(0x8 5381b0)') called at ./dbutil.pl line 194
main::dump_table('dbi:mysql:database=t;host=127.0. 0.1','root','sql!my','abc','','') called at ./dbutil.pl line 51
main::main_routine('t','abc','undef','') called at ./dbutil.pl line 32

my version of perl:
Summary of my perl5 (revision 5.0 version 8 subversion 1) configuration:
Platform:
osname=linux, osvers=2.6.0-test3, archname=i586-linux-thread-multi
uname='linux g8 2.6.0-test3 #1 smp fri nov 14 00:07:01 utc 2003 i686 i686 i386 gnulinux '
config_args='-ds -e -Dprefix=/usr -Dvendorprefix=/usr -Dinstallusrbinperl -Dusethreads -Di_db -Di_dbm -Di_ndbm -Di_gdbm -Duseshrplib=true -Doptimize=-O2 -march=i586 -mcpu=i686 -fmessage-length=0 -Wall -pipe'
hint=recommended, useposix=true, d_sigaction=define
usethreads=define use5005threads=undef useithreads=define usemultiplicity=define
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='cc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
optimize='-O2 -march=i586 -mcpu=i686 -fmessage-length=0 -Wall -pipe',
cppflags='-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -fno-strict-aliasing'
ccversion='', gccversion='3.3.1 (SuSE Linux)', gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
alignbytes=4, prototype=define
Linker and Libraries:
ld='cc', ldflags =''
libpth=/lib /usr/lib /usr/local/lib
libs=-lnsl -ldl -lm -lcrypt -lutil -lpthread -lc
perllibs=-lnsl -ldl -lm -lcrypt -lutil -lpthread -lc
libc=, so=so, useshrplib=true, libperl=libperl.so
gnulibc_version='2.3.2'
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-rdynamic -Wl,-rpath,/usr/lib/perl5/5.8.1/i586-linux-thread-multi/CORE'
cccdlflags='-fPIC', lddlflags='-shared'
Characteristics of this binary (from libperl):
Compile-time options: MULTIPLICITY USE_ITHREADS USE_LARGE_FILES PERL_IMPLICIT_CONTEXT
Built under linux
Compiled at Dec 10 2003 09:22:12
@INC:
/usr/lib/perl5/5.8.1/i586-linux-thread-multi
/usr/lib/perl5/5.8.1
/usr/lib/perl5/site_perl/5.8.1/i586-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.1
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.1/i586-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.1
/usr/lib/perl5/vendor_perl
Jul 19 '05 #1
0 1945

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Ricky_newbie | last post by:
Hello, I don't know any thing about perl and i don't even under stan the script. I am SQL Server DBA. One of my Developer(Not working an more) wrote the perl script and i created a SQL job. My sql...
4
by: Chris Oakleaf | last post by:
With the following code snippet: <%="complexid =" & rsComplex("ComplexID")%> <% rsPhoto.filter = "complexID =" & rsComplex("ComplexID") %> <%response.Write("<br>ID: " & rsPhoto("complexID"))%> ...
5
by: crunix | last post by:
Hello. I have developed a medical application with php 4 linked to IBM DB2 database. The database connection is right and i can access data with no problem...but sometimes when i reload the...
6
by: Geir Baardsen | last post by:
Hi! This is a routine for copying a recordset into a new order. It has worked fine under Win98. However, my client has changed to Win XP, and suddenly it doesn't work anymore. I keep getting the...
6
by: Robin | last post by:
Hello! I am useing ASP scripts with PERL and IIS 6.0 (Internet Information Server). The scripts are useing the 'Response.Redirect "xxx.asp"' cmd. Beside this there is a form which calls another...
1
by: Akino877 | last post by:
Hello, I have a simple Perl program that connects to MySQL and creates a table of first names and last names. The code is as follows : #!/usr/bin/perl -w use DBI; use Mysql; use DBD::mysql;
4
by: vijaybabudev81 | last post by:
Hi, I want to get the error & warnings messages from program. like fatal error, variable declaration error in strict mode & etc.. is it possible in perl? plz give your suggestions. Thanks...
4
by: Chronictank | last post by:
Hi, as a bit of background (and seeing as it is my first post :)) i am a complete newbie at perl. I literally picked it up a week ago to do this project as it seemed like the best choice for a...
2
by: akhilesh.noida | last post by:
I am trying to compile glibc-2.5 for ARM based board. But I am getting errors while configuring it. Please check and give your inputs for resolving this. configure command : $...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.