Re: DBI && DB_File problem

Anthony, I encountered the exact same problem as you described when I upgraded my perl installation from 5.004_04 to 5.6.1 quite a while ago. Scripts that used both DB_File to access berkeley DB files, and DBI to access oracle caused the DB files to become corrupted whenever they were modified.

Re: Readling large amount of records with DBD::Oracle

Look at the docs for RowCacheSize. It often helps to set that higher, at the expense of using more memory in the client. You set it in the database handle; e.g., $dbh->{RowCacheSize} = 100; [EMAIL PROTECTED] wrote: > Hi, > > i'm doing some queries that dump a lot of records (1.000.0

Re: DBI installation problem with DBI 1.20 on linux

On Thu, Dec 27, 2001 at 02:32:27PM -0800, Christopher Solomon wrote: > On Thu, 27 Dec 2001, Tim Bunce wrote: > > > On Thu, Dec 27, 2001 at 01:16:40PM -0800, Christopher Solomon wrote: > > > On Thu, 27 Dec 2001, Christopher Solomon wrote: > > > > > > > > > > > My setup: > > > > > > > > linux (2.4.

Re: Readling large amount of records with DBD::Oracle

Thanks! I found it... Dont know how I missed that ... :/ Best regards, On Thu, Dec 27, 2001 at 05:41:43PM -0500, Steve Sapovits wrote: > Look at the docs for RowCacheSize. It often helps to set that > higher, at the expense of using more memory in the client. You > set it in the database hand

Re: Embedding perl in Oracle

I'm putting together a "Using Perl with Oracle" talk (for the Perl Whirl '02 GeekCruise conference) and would very much like to hear from anyone who's used Jeff's extproc_perl. The talk, like all my others, will be available from http://cpan.valueclick.com/authors/id/TIMB/ once it's done.

Readling large amount of records with DBD::Oracle

Hi, i'm doing some queries that dump a lot of records (1.000.000+). Are there any parameters I can set on the client to improve my performance? Any pointers? Thanks in advance. -- Pedro Melo Cunha - <[EMAIL PROTECTED]> Novis Telecom, S.A. - Dir. Rede - ISP Edifício Nov

Re: DBI installation problem with DBI 1.20 on linux

On Thu, 27 Dec 2001, Tim Bunce wrote: > On Thu, Dec 27, 2001 at 01:16:40PM -0800, Christopher Solomon wrote: > > On Thu, 27 Dec 2001, Christopher Solomon wrote: > > > > > > > > My setup: > > > > > > linux (2.4.10) > > > perl 5.6.1 (output of perl -V attached) > > > > > > Perl works fine (insofar

Re: DBI installation problem with DBI 1.20 on linux

On Thu, Dec 27, 2001 at 01:16:40PM -0800, Christopher Solomon wrote: > On Thu, 27 Dec 2001, Christopher Solomon wrote: > > > > > My setup: > > > > linux (2.4.10) > > perl 5.6.1 (output of perl -V attached) > > > > Perl works fine (insofar as I've tested it with a few scripts), and I > > originall

Re: DBI installation problem with DBI 1.20 on linux

Grok this and your DBI problems should go away: A.) Install the following RPM packages: Development/Libraries/Perl: perl-DBI Applications/Databases: all postgresql modules Development Libraries: postgresql-devl B.) Setup directories and paths for PostgreSQL: Open a terminal and su as root Setu

DBI && DB_File problem

Hi, I'm trying to create Berkeley DB binary files using some information from my Oracle database. I'm using DB_File.pm(perl 5.6.1 dist), B-trees for handling Berkeley DB and DBI (DBD::Oracle) version 1.14. For some bizarre reason when connect method of the DBI package is called all m

Re: DBI installation problem with DBI 1.20 on linux

On Thu, 27 Dec 2001, Christopher Solomon wrote: > > My setup: > > linux (2.4.10) > perl 5.6.1 (output of perl -V attached) > > Perl works fine (insofar as I've tested it with a few scripts), and I > originally tried to install DBI from CPAN: > > perl -MCPAN -e shell > shell%> install DBI > > but

DBI installation problem with DBI 1.20 on linux

My setup: linux (2.4.10) perl 5.6.1 (output of perl -V attached) Perl works fine (insofar as I've tested it with a few scripts), and I originally tried to install DBI from CPAN: perl -MCPAN -e shell shell%> install DBI but it didn't take; I can't remember the errors. Then I downloaded the so

Postgres' arrays

Is it possible to bind to Postgres' array types? My postgres table definition: create table AYear ( --#! keylist( cust, year ) cust varchar(16) references cust(cust), year int, amt numeric(12,4)[12] ); My DBI code: my $sth_store; # cache

Re: Another DBD::mysql bug

Zitiere Christian Jaeger <[EMAIL PROTECTED]>: > Hello > > There is also another bug: > > connect with autocommit 0ff. > restart mysql > $DB->commit; # This time it will *NOT* give an error. It seems ># that this commit is silently optimized away by It is not optimized, it is due

Re: DBD::mysql bug (Was: commit fails on reconnect under DBD::mysql)

Please try the following patch, to be found in DBD::mysql 2.1006: --- dbdimp.c~ Thu Dec 13 09:58:07 2001 +++ dbdimp.cThu Dec 27 18:45:25 2001 @@ -1951,6 +1951,15 @@ /* Other error */ return FALSE; } + + if (DBIc_has(imp_dbh, DBIcf_AutoCommit)) { +/* We never reconnect if

isamchk quota exceeded !!!!

Major problem for me :o(( I'm running on a virtual server and have a max of 800MB. I've got a LARGE (260Meg) table in mysql that i tried to clean up so i deleted about 80.000 rows. But it didn't clean up any diskspace !! After some research this seems normal since i should just do OPTIMIZE TA