DBD::Informix FAILURE CLASS A gcc: language arch=v9 not recognize d

2006-06-22 Thread Govinda . Pfister
Hello, I do have a big problem with a configuration failure (perl Makefile.PL does not work). I studied all the provided readmes and googled endlessly, but did not found a solution. Hopefully you can help! The error message is: gcc: language arch=v9 not recognized A lot of problems I found

Performance issue

2006-06-22 Thread Richard J McWaters
I was trying to improve the performance of a Perl DBI query. In the process I was also trying to improve the look and maintenance of my code. I am doing a batch job where I am doing multiple queries based on an input file. The old code had the prepare statement inside the read file loop. A

DBD::mysql 3.0004+ not resetting $sth-{Active} after fetch

2006-06-22 Thread Addison, Mark
Hello, I upgraded DBD::mysql from 2.9006-1 to 3.0006-1 and suddenly started getting screens full of errors like: prepare_cached(SELECT * FROM foo) statement handle DBIx::ContextualFetch::st=HASH(0x971cc80) still Active at /usr/share/perl5/Ima/DBI.pm line 381 After some digging it seems that

Re: Performance issue

2006-06-22 Thread Alexander Foken
You generate a big number of open statement handles, each costing some memory. Put the SQL statements (*NOT* the statement handles) into a hash, like this: use DBI; my %statements=( 'find_users' = 'select foo,bar from users where baz=?', 'find_documents' = 'select * from documents where

DBI version

2006-06-22 Thread Rajesh Golani
I installed the DBI using CPAN on cygwin(windows), but when i run the programs it gives the error DBI object version 1.51 does not match $DBI::VERSION 1.48 at /usr/lib/perl5/5.8/cygwin/DynaLoader.pm line 253 Can anyone help me in this aspect. Rajesh Golani Elina Networks NSR-GIV Center,

Re: DBI version

2006-06-22 Thread Alexander Foken
There are traces of an old DBI version on your system. Remove that first. Search for files and folders named DBI below Perl's @INC. Alexander On 22.06.2006 15:24, Rajesh Golani wrote: I installed the DBI using CPAN on cygwin(windows), but when i run the programs it gives the error DBI

Re: DBD::Informix FAILURE CLASS A gcc: language arch=v9 not recognize d

2006-06-22 Thread Jonathan Leffler
On 6/22/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I do have a big problem with a configuration failure (perl Makefile.PLdoes not work). I studied all the provided readmes and googled endlessly, but did not found a solution. Hopefully you can help! The error message is: gcc: language

Getting spatial data?

2006-06-22 Thread Todd Chisholm
Hi all, I'm trying to get some sdo data, but running into trouble. The program snippet: my $connect = DBI-connect( dbi:Oracle:, '', '', ) || die No connect; #my $query = select update_date from

RE: Getting spatial data?

2006-06-22 Thread Garrett, Philip \(MAN-Corporate\)
-Original Message- From: Todd Chisholm Sent: Thursday, June 22, 2006 1:54 PM Subject: Getting spatial data? my $query = select geometry from processed_product where id=15601; my $sth = $connect-prepare($query); $sth-execute(); [snip] DBD::Oracle::db prepare failed: ERROR

Re: Getting spatial data?

2006-06-22 Thread John Scoles
Tricky one. The sdo_geometry is a very Oracle specific binary field as DBI and DBD::Oracle basically default of strings so the program dies. You may want to define the field as an ora_type = ORA_CLOB or ORA_BLOB and get it that way. If may work. I might have write a patch for it and treat it

Re: Getting spatial data?

2006-06-22 Thread Todd Chisholm
Great, thanks for your help guys. Right now, I'm getting it out with getvertices. Didn't know how that worked. I may try the BLOB as well, to streamline things, since I just need a dump of it. Philip, I added the die command, thanks (usually they are there...really!) Todd On 6/22/06, John

Always Die (was: RE: Getting spatial data?)

2006-06-22 Thread Rutherdale, Will
Just to expand on that piece of the discussion, there are cases where I don't use 'die' on DBI statements at all. For instance, I may have a system script (not for end users) whose purpose is to do some database update operations and either succeed or fail. If it succeeds then it does the whole

multiple perl installs - OT

2006-06-22 Thread LLC
Hi List; does anyone know how to install a new instance/version of perl on a Linux box (RHEL4) which already has more than one instance installed and force scripts to not only use the new perl executable but the new perl libs, modules, etc? Thanks in advance...

Re: multiple perl installs - OT

2006-06-22 Thread Matthew Persico
On 6/22/06, LLC [EMAIL PROTECTED] wrote: Hi List; does anyone know how to install a new instance/version of perl on a Linux box (RHEL4) which already has more than one instance installed and force scripts to not only use the new perl executable but the new perl libs, modules, etc? Thanks in

Re: DBI version

2006-06-22 Thread Ron Savage
On Thu, 22 Jun 2006 18:54:48 +0530, Rajesh Golani wrote: Hi Rajesh DBI object version 1.51 does not match $DBI::VERSION 1.48 at /usr/lib/perl5/5.8/cygwin/DynaLoader.pm line 253 You have 2 versions of DBI installed. I suggest you delete both and re-install one. Don't overlook components in the

RE: Speed test for connecting to Oracle for Windows via ODBC - Solved!

2006-06-22 Thread Ron Savage
On Wed, 14 Jun 2006 11:13:52 +1000, Ron Savage wrote: Hi Ron After some kindly prompting by Job Miller (thanx to all who offered help) and a long tour of Oracle's site and of http://asktom.oracle.com/ I did this: o Changed sqlnet.ora from: SQLNET.AUTHENTICATION_SERVICES = (NTS) to:

RE: Always Die (was: RE: Getting spatial data?)

2006-06-22 Thread Garrett, Philip \(MAN-Corporate\)
Yeah, you're right. T definitely IMTOWTDI. Using RaiseError is a valid choice, as is checking each call for errors. However, you do need one or the other. Calling a method on a undefined variable is rarely one of TWTDI. From: Rutherdale, Will [mailto:[EMAIL

AW: DBD::Informix FAILURE CLASS A gcc: language arch=v9 not recog nize d

2006-06-22 Thread Govinda . Pfister
Dear Jonathan, Thanks a lot for your sound advice. And sorry that I did not include the plattform information (Solaris) as part of the problem description. I noticed just one moment after sending the email... By the way is it allways the case that one should not use programs together that are