Re: wrong results - HELP!

2004-01-08 Thread shildreth
I did say to be fair, I have not tried the perl that comes with RH9. I just thought I would mention it, since I know somebody that was having problems the the RH9 perl. Which could be an isolated instance. On 08-Jan-2004 Hardy Merrill wrote: <[EMAIL PROTECTED]> 01/08/04 01:26PM >>> > I beg

Re: wrong results - HELP!

2004-01-08 Thread shildreth
This may be totally unrelated, but I had a friend email me about the Vendor Perl not working correctly on RH9. I encouraged him to compile 5.8.1 or 5.8.2, I have had nothing but trouble using the /usr/bin/perl that is shipped with RedHat. One of the biggest my complaints is that LARGEFILE_SOURCE

Re: Perl Upgrade & Bundle::DBI

2004-01-08 Thread shildreth
I'll look into that. Next server I upgrade I will pay more attention to the details on each step to see where the @INC is getting altered. Thanks, STH On 07-Jan-2004 Tim Bunce wrote: > Maybe your CPAN.pm config is altering @INC someho

Re: Perl Upgrade & Bundle::DBI

2004-01-07 Thread shildreth
On 07-Jan-2004 Tim Bunce wrote: > On Wed, Jan 07, 2004 at 11:03:23AM -0600, [EMAIL PROTECTED] wrote: >> >> Has anyone done a 5.8.1 install, then use CPAN to install Bundle::DBI with a 5.6.1 >> perl installed on the server? When I install perl 5.8.1 on the server then use a >> CPAN script to inst

Perl Upgrade & Bundle::DBI

2004-01-07 Thread shildreth
Has anyone done a 5.8.1 install, then use CPAN to install Bundle::DBI with a 5.6.1 perl installed on the server? When I install perl 5.8.1 on the server then use a CPAN script to install modules, the serever will hang or on an alpha it will run out of swap space, when the make test portion of DBI

RE: (Fwd) DBD::Oracle (CLOB and sp)

2003-12-09 Thread shildreth
Read the docs on LongReadLen. On 09-Dec-2003 Tim Bunce wrote: > - Forwarded message from builder developer <[EMAIL PROTECTED]> - > > Delivered-To: [EMAIL PROTECTED] > X-Originating-IP: [200.163.79.22] > X-Originating-Email: [EMAIL PROTECTED] > From: "builder developer" <[EMAIL PROTECTED

RE: Aqua Data Studio?

2003-11-11 Thread shildreth
No, but I am going to try it, thanks for the link. On 11-Nov-2003 Tim Bunce wrote: > http://www.aquafold.com/ > > "Aqua Data Studio is a database query and administration tool that > allows developers to easily create, edit, and execute SQL scripts, > as well as browse and modi

RE: possible memory leak in either DBI or DBD:Oracle (or maybe oci??)

2003-11-05 Thread shildreth
I don't see the script? On 05-Nov-2003 Roman Hochleitner wrote: > On Wed, 5 Nov 2003 [EMAIL PROTECTED] wrote: > >> >> I was just debugging this problem for co-workers, on RedHat 7.3 perl 5.6.1, >> DBI 1.37 & DBD::Oracle 1.14. I am going to upgrade the DBI to 1.38 and the >> perl 5.8.1(not that

RE: possible memory leak in either DBI or DBD:Oracle (or maybe oci??)

2003-11-05 Thread shildreth
I was just debugging this problem for co-workers, on RedHat 7.3 perl 5.6.1, DBI 1.37 & DBD::Oracle 1.14. I am going to upgrade the DBI to 1.38 and the perl 5.8.1(not that this is affecting the memory leak). If you search the archives, DBI 1.37 seems to had memory leak problems with other driver

Re: Has anyone seen this.

2003-10-15 Thread shildreth
Thanks Tim, so that will apply to my other post as well. On 15-Oct-2003 Tim Bunce wrote: > On Wed, Oct 15, 2003 at 08:41:41AM -0500, [EMAIL PROTECTED] wrote: >> >> ..if I run the test with >> >> /usr/local/bin/perl5.8.1 -Mblib t/01basics.t >> >> ..everything tests "ok", but if I run with >>

Re: Has anyone seen this.

2003-10-15 Thread shildreth
okay I looked up Coexistence in the INSTALL doc sent with the perl dist and it claims that since 5.6.? are not binar compatiable with 5.8.?, the Arch lib will not be searched in older perls. Seems right, >> /usr/local/bin/perl5.8.1 -e 'print join "\n", @INC' /usr/local/lib/perl5/5.8.1/i686-lin

Re: Has anyone seen this.

2003-10-15 Thread shildreth
I did run it with -d and it ran fine, but I didn't use -d with "-MExtUtils::MM" which shows me the error or leads me towards it, ok 39 at line 104 /u01/usr/local/bin/perl5.8.1: error in loading shared libraries: /usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBD/Oracle/Oracle.so: undefi

Has anyone seen this.

2003-10-15 Thread shildreth
I am compiling Perl 5.8.1 on one of our servers, currently all the code uses perl 5.6.1. I wanted to get 5.8.1 compiled, installed and all the modules needed on this server. When everything is installed and tested, I will point /usr/local/bin/perl -> perl5.8.1. I was installing DBI and one of th

RE: DBD:Oracle; unable to 'make test'

2003-09-22 Thread shildreth
On 22-Sep-2003 McDonald, Jeffrey wrote: > All, > My apologies if there was misconduct in my submission methods, as I have yet to > receive a > response from anyone. ..Didn't see it till now. But you did what everyone would have told you, update to the latest DBI. DBI 1.20 was very old

Memory Leak - DBD::mysql

2003-08-09 Thread shildreth
I know this was discussed before, but I don't if anything came out of it. I upgraded one of our servers to DBD::mysql 2.9002 and suddenly one of our programs grows in memory until it runs out. I ran the same program on my server which had 2.1020, no problems, then I upgraded to version 2.9002 an

ActiveState Awards

2003-06-12 Thread shildreth
...Has anybody mentioned that Tim is a nominee??? I just voted for him, "nudge nudge, wink wink, say no more, say no more". -- E-Mail: [EMAIL PROTECTED] Date: 12-Jun-2003 Time: 13:20:34 --

Re: Vague DBI Error

2003-06-09 Thread shildreth
I didn't see the earlier post, but Mysql will select all rows by default, >From DBD::mysql, Note, that most attributes are valid only after a success- full execute. An "undef" value will returned in that case. The most important exception is the "mysql_use_result" at

Re: $dbh->unquote()

2003-03-27 Thread shildreth
On 27-Mar-2003 Jeff Zucker wrote: > [EMAIL PROTECTED] wrote: > >>"\n" => "\r\n" in windows env. >> > LOL. How can something be equal to itself plus something else? And the > "windows env" is not a monolithic thing, its behaviour can be modified > by binmode. > > A better way to say it is:

RE: $dbh->unquote()

2003-03-27 Thread shildreth
"\n" => "\r\n" in windows env. On 27-Mar-2003 Brian Spindler wrote: > If printed in a windows environment "\n" is a carriage return. > Brian > > > -Original Message- > From: Paul DuBois [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 27, 2003 11:32 AM > To: Brian Spindler; [EMAIL PRO

RE: Using perl 5.8.0?

2003-02-26 Thread shildreth
> I would like to take this moment to thank Lincoln Stein for his wonderful > book "Network Programming with Perl"; it's been a wonderful resource for me ..has been a great resource for me as well. > on this current project. If yo

RE: multiple posts

2003-02-26 Thread shildreth
Nope.. On 26-Feb-2003 Markham, Richard wrote: > is anyone else receiving two copies of emails sent by the listers??? -- E-Mail: [EMAIL PROTECTED] Date: 26-Feb-2003 Time: 11:24:01 --

RE: DBI and DBD not found

2003-02-04 Thread shildreth
Also, you will have install DBI/DBD with the new perl(5.6.1). On 04-Feb-2003 [EMAIL PROTECTED] wrote: > > 'rm /usr/bin/perl' > > and then > > 'ln -s /usr/local/bin/perl /usr/bin/perl' > > Or you could use "/usr/local/bin/perl" in the code, instead of /usr/bin/perl. > > I would do the link,

RE: DBI and DBD not found

2003-02-04 Thread shildreth
'rm /usr/bin/perl' and then 'ln -s /usr/local/bin/perl /usr/bin/perl' Or you could use "/usr/local/bin/perl" in the code, instead of /usr/bin/perl. I would do the link, it insures that you are always getting the same version. On 04-Feb-2003 Chamlee, Douglas, B. (Contractor) wrote: > This is

RE: DBI and DBD not found

2003-02-04 Thread shildreth
Did the Os upgrade include a Perl? If it did, it is usually in /usr/bin which would not know that you have DBI/DBD installed. check, /usr/bin/perl -v /usr/local/bin/perl -v ..see if the versions are the same. On 04-Feb-2003 Chamlee, Douglas, B. (Contractor) wrote: > I recently upgraded t

RE: Source-info-INSTALL: Perl 5.8 DBI::ORACLE9I

2003-01-30 Thread shildreth
On 30-Jan-2003 dshagun wrote: > Is anybody gives me a good source for Using Perl 5.8 with Oracle 8.1.7 on RedHat >Linux i386 8.0. > > I'm installing Oracle 9i on Linux 8.0 and heard that version 5.8 of Perl (From >Lunix) does not work well with such > version of Oracle. ..where did you h

RE: sigh, dependency hell

2002-11-13 Thread shildreth
you are missing the RPC::PlClient module, you can install use CPAN to install Bundle::DBI, which will install the modules you need (Storable, RPC::PlClient, ...etc) or install them yourself. prompt> perl -MCPAN -eshell On 13-Nov-2002 Steven Hajducko wrote: > -BEGIN PGP SIGNED MESSAGE- >

Re: use DBD::Oracle qw(:ora_types); - from cron

2002-11-06 Thread shildreth
or set LD_LIBRARY_PATH in the cron. On 06-Nov-2002 Darin McBride wrote: > On November 5, 2002 04:41 pm, you wrote: >> When I need to have a "use DBD::Oracle qw(:ora_types);" in my program, and >> I am running from cron, I get a message like: >> >> Can't load '/auto/DBD/Oracle/Oracle.so' for modu

Re: Shared object "libmysqlclient.so.6" not found

2002-10-28 Thread shildreth
Well an upgrade is good, but it was an example. So you should have seen ".6.so" line. On 28-Oct-2002 Mark wrote: > It did not have the .10 client library. So, I just installed a new 3.23.53 > client, and everything works now. Thanks! :) Good... your welcome. > > - Mark > > Sys

RE: Shared object "libmysqlclient.so.6" not found

2002-10-28 Thread shildreth
Type in 'ldconfig -r'... you should see something like this, . . . 333:-lmysqlclient.10 => /usr/local/lib/mysql/libmysqlclient.so.10 ... if not, 'ldconfig -m /usr/local/lib/mysql'. On 28-Oct-2002 Mark wrote: > The oddest thing; I installe

RE: DBD::Oracle and FreeBSD

2002-10-22 Thread shildreth
2 things : - if you are using an Linux Oracle install, you need to compile a linux perl and use that. - if you've installed the Oracle7 client libraries, /usr/ports/databases/oracle7, then you can use the FreeBSD native Perl. Make sure you set the env var LD_LIBRARY_PATH. I a

RE: Performance problem with DBI, DBD-Oracle8

2002-10-03 Thread shildreth
Have him update your DBI & DBD::Oracle to the latest versions. (1.30) & (1.12) On 03-Oct-2002 John-Thomas Beadles wrote: > It's definite. I implemented it all through my code and dropped the > execution time from 40+ minutes to approximately 4.5 minutes. I've notified > t

RE: Performance problem with DBI, DBD-Oracle8

2002-10-03 Thread shildreth
I'm sure you are aware of this, but the DBI/DBD::Oracle are very old on that server. On 03-Oct-2002 John-Thomas Beadles wrote: > Thanks. v1.03 on the Unix side, v1.8 on the PC. > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 03, 200

RE: Performance problem with DBI, DBD-Oracle8

2002-10-03 Thread shildreth
perl -MDBD::Oracle -e 'print $DBD::Oracle::VERSION, "\n"' On 03-Oct-2002 John-Thomas Beadles wrote: > Hm, I'll try that. However, the listener appears to be down now, so I can't > try it just yet. > > Not sure about the DBD Oracle version, not sure how to find the physical > module. Is ther

RE: Performance problem with DBI, DBD-Oracle8

2002-10-03 Thread shildreth
Ah yes, there was a bug in DBD::Oracle. I forget which version numbers, you can add my $foo = $sth->{NAME} before the $sth->execute which will start the caching. Which version of DBD::Oracle are you using? .. Not that this affects performance, but you can set your sql by, my

RE: Performance problem with DBI, DBD-Oracle8

2002-10-03 Thread shildreth
If you are doing selects, you can set the $dbh->RowCacheSize, perldoc DBI will tell you what you need to know. On 02-Oct-2002 John-Thomas Beadles wrote: > Help! I'm having a severe performance problem with a Perl program talking > to a remote Oracle database. I've read the DBI & DBM perldocs,

Re: Can't save oracle BLOB with DBI::Oracle

2002-09-19 Thread shildreth
Sorry, I skimmed the email to fast, I didn't notice you were updating the db. STH On 18-Sep-2002 Michael A Chase wrote: > On Wed, 18 Sep 2002 13:52:22 -0500 (CDT) [EMAIL PROTECTED] wrote: > >> ""LongReadLen"" (unsigned inte

RE: Can't save oracle BLOB with DBI::Oracle

2002-09-18 Thread shildreth
""LongReadLen"" (unsigned integer, inherited) This attribute may be used to control the maximum length of long fields ("blob", "memo", etc.) which the driver will read from the database automatically when it fetches each row of data. The "LongRea

RE: Problem with DBI::execute eating away memory.

2002-07-26 Thread shildreth
mysql returns all the rows by default, if large could eat up all the memory. Do a perldoc DBD::mysql and look for "use_result", I forget the syntax. This will return the rows...here I will paste the docs, Note, that most attributes are valid only after a successfull execute. An