Can not install/compile DBI/DBD on AIX 5.3 or AIX 5.2
we tried to install EBI 1.48 in a new box with AIX 5.3 whic included IBM's flavor of Perl 5.8.2. We got the following message. We trie to use gcc or IBM C compiler to compile it and got the same error. Can anyone help? /usr/opt/perl5/lib/5.8.2/aix-thread-multi/CORE/reentr.h:619: error: field `_drand48_struct' has incomplete type /usr/opt/perl5/lib/5.8.2/aix-thread-multi/CORE/reentr.h:727: error: field `_random_struct' has incomplete type /usr/opt/perl5/lib/5.8.2/aix-thread-multi/CORE/reentr.h:775: error: field `_srandom_struct' has incomplete type make: 1254-004 The error code from the last command is 1.
Re: DBD::Oracle - prepare() and the utf-8 flag.
On Wed, Aug 17, 2005 at 06:01:03PM +0100, Charles Jardine wrote: > Tim Bunce wrote, on 15/08/2005 14:36: > >On Mon, Aug 15, 2005 at 12:07:03PM +0100, Charles Jardine wrote: > > > >>Peter J. Holzer wrote, on 14/08/2005 09:23: > >> > >>>However, I am sure there exist tons of code which expect that perl > >>>strings are byte arrays in the client character set. This code would > >>>then break. > >>> > >>>I propose the following compromise: > >>> > >>>If the client character set is AL32UTF8 or UTF8, then all strings passed > >>>to prepare or inserted into or compared to varchar2 or clob fields are > >>>silently upgraded to utf8. All varchar2 and clob values returned by > >>>DBD::Oracle are in utf8 representation. > >> > >>This what I am proposing for prepare. It already happens for values > >>sent of returned via placeholders and to fetched values. > > > >Actually it's not quite what happens. There's no silent upgrading. > > Sorry. I did insufficient research before forming a plan. > > I was intending to provide silent upgrading for byte-encoded > statements being prepared when the client side database > charset is utf8. > > Now Tim points out that this is not how bound input values > behave in the current implementation, I realise I have to think > again. > > So, I won't be submitting a patch soon. When I can find time, > I will post with the intention of starting a discussion > about upgrading and downgrading. Why? What I proposed requires less work and is in-keeping with how DBD::Oracle behaves for bind values etc. (If you want to change how DBD::Oracle behaves for bind values etc. then you're staring into a can of worms the size of which you can barely imagine. Trust me, I've been there along with a few brave souls who all bare the scars.) If the $statement is UTF8 then simply tell Oracle that it's UTF8. Simple. Tim.
FW: DBI 1.48 make error in IBM AIX 5.3 with perl 5.8.2
Hi, We got the error when did "make" for DBI? Can anyone help us on this? We used gcc or IBM C compilier and got the same error. Thanks! John /usr/opt/perl5/lib/5.8.2/aix-thread-multi/CORE/reentr.h:619: error: field `_drand48_struct' has incomplete type /usr/opt/perl5/lib/5.8.2/aix-thread-multi/CORE/reentr.h:727: error: field `_random_struct' has incomplete type /usr/opt/perl5/lib/5.8.2/aix-thread-multi/CORE/reentr.h:775: error: field `_srandom_struct' has incomplete type make: 1254-004 The error code from the last command is 1.
Re: [ANNOUNCE] DBIx::Chart 0.04 (was Re: DBIx::Chart and Params)
OK, I installed the new versions of DBIx::Chart and DBD::Chart. Now a PH within the select works OK. But, if I try to use a PH within the RETURNING LINEGRAPH paragraph (for example, y-axis = ?, I get the following message: "DBD::Chart::st execute failed: Invalid dataset. at C:/Opt/Perl/site/lib/DBIx/Chart.pm line 425." Any ideas ?? Or is he use of PHs within the RETURNING portion of the chart syntax not supported ?? Thanks, --- Dean Arnold <[EMAIL PROTECTED]> wrote: > A new version of DBIx::Chart is now > available at > http://www.presicient.com/dbixchart/DBIx-Chart-0.04.tar.gz, > and should be available soon on CPAN. > > Changes in release 0.04: > > - Fixed placeholder mapping for source statements > - Fixed bad sth subclassing > - added test for same > - changed test suite to use temp tables > - removed unneeded dbh methods > > Regards, > Dean Arnold > Presicient Corp. > __ Find your next car at http://autos.yahoo.ca
Re: Bulk Inserts
On 2005-08-16 14:22:26 +0100, Tim Bunce wrote: > On Tue, Jul 19, 2005 at 12:58:59PM +0200, Peter J. Holzer wrote: > > On 2005-07-19 14:49:57 +0530, Kiran Kumar wrote: > > > We could have an option to do Bulk Inserts .. > > Seconded. Actually, DBIv1 already has it (look for bind_param_array in > > the manual), > > And execute_array() and execute_for_fetch(). > > > but I think support in the DBDs is still not very good > > The DBI emulates the behaviour for drivers that don't have native support, > so you can go ahead and use it in applications. Yes, but unless the driver has native support, you won't see much speedup. So the incentive to use it isn't that great. hp -- _ | Peter J. Holzer| In our modern say,learn,know in a day |_|_) | Sysadmin WSR | world, perhaps being an expert is an | | | [EMAIL PROTECTED] | outdated concept. __/ | http://www.hjp.at/ |-- Catharine Drozdowski on dbi-users. pgpC0N3rVz3Nz.pgp Description: PGP signature
Need help in compilation of DBI.c
Hi, I am trying to build and install DBI module. I have built and installed perl Version 5.8.7. The compiler gives the following errors; "DBI.c", line 3577: Error: Unexpected type name "SV" encountered. "DBI.c", line 3577: Error: Operand expected instead of "class". "DBI.c", line 3577: Error: Identifier expected instead of "=". "DBI.xs", line 3561: Error: Expected an expression. "DBI.xs", line 3561: Error: Identifier expected instead of ",". Compiler command line: /opt/Forte6.2/SUNWspro/bin/CC -c-I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O-DVERSION=\"1.48\" -DXS_VERSION=\"1.48\" -KPIC -I/home17/SG/clearcase/perl5/lib/5.8.7/sun4-solaris/CORE -DDBI_NO_THREADS DBI.c Any help will be greatly appreciated. Regards, Manas Kumar Sahu __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Re: [ANNOUNCE] DBIx::Chart 0.04 (was Re: DBIx::Chart and Params)
On Wed, 17 Aug 2005 22:35:38 -0400 (EDT), Kenneth Dick wrote: Hi Dean Here' what I get under MS Windows & Perl 5.8.6: C:\Perl-modules\DBIx-Chart-0.04>perl Makefile.PL Configuring DBIx::Chart ... >>> Remember to actually *READ* the README file! And re-read it if you have any problems. Checking for GD::Text, 0.80 or later ... ok Checking for GD, 1.19 or later ... ok Checking for DBD::Chart, 0.81 or later ... ok Checking for DBI, 1.28 or later ... ok Checking if your kit is complete... Looks good Writing Makefile for DBIx::Chart C:\Perl-modules\DBIx-Chart-0.04>nmake Microsoft (R) Program Maintenance Utility Version 6.00.8168.0 Copyright (C) Microsoft Corp 1988-1998. All rights reserved. cp Chart.pm blib\lib\DBIx\Chart.pm C:\Perl-modules\DBIx-Chart-0.04>nmake test Microsoft (R) Program Maintenance Utility Version 6.00.8168.0 Copyright (C) Microsoft Corp 1988-1998. All rights reserved. Skip blib\lib\DBIx\Chart.pm (unchanged) C:\Perl\bin\perl.exe "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib\lib', 'blib\arch' )" t\plottest.t t\plottestok 3/46Use of uninitialized value in numeric lt (<) at C:/Perl/site/lib/DBD/Chart.pm l ine 2211. DBD::Chart::st execute failed: LINEGRAPH chart requires at least 2 columns. at C:\Perl-modules\DBIx- Chart-0.04\blib\lib/DBIx/Chart.pm line 425. Use of uninitialized value in print at t\plottest.t line 2565. Use of uninitialized value in print at t\plottest.t line 2568. t\plottestok 4/46Use of uninitialized value in numeric lt (<) at C:/Perl/site/lib/DBD/Chart.pm l ine 2211. DBD::Chart::st execute failed: BARCHART chart requires at least 2 columns. at C:\Perl-modules\DBIx-C hart-0.04\blib\lib/DBIx/Chart.pm line 425. Use of uninitialized value in print at t\plottest.t line 2565. Use of uninitialized value in print at t\plottest.t line 2568. t\plottestok 5/46Use of uninitialized value in numeric lt (<) at C:/Perl/site/lib/DBD/Chart.pm l ine 2211. DBD::Chart::st execute failed: BARCHART chart requires at least 2 columns. at C:\Perl-modules\DBIx-C hart-0.04\blib\lib/DBIx/Chart.pm line 425. Use of uninitialized value in print at t\plottest.t line 2565. Use of uninitialized value in print at t\plottest.t line 2568. t\plottestok 6/46Use of uninitialized value in numeric lt (<) at C:/Perl/site/lib/DBD/Chart.pm l ine 2211. DBD::Chart::st execute failed: HISTOGRAM chart requires at least 2 columns. at C:\Perl-modules\DBIx- Chart-0.04\blib\lib/DBIx/Chart.pm line 425. Use of uninitialized value in print at t\plottest.t line 2565. Use of uninitialized value in print at t\plottest.t line 2568. t\plottestok 7/46Use of uninitialized value in numeric lt (<) at C:/Perl/site/lib/DBD/Chart.pm l ine 2211. DBD::Chart::st execute failed: BOXCHART chart requires at least 1 columns. at C:\Perl-modules\DBIx-C hart-0.04\blib\lib/DBIx/Chart.pm line 425. Use of uninitialized value in print at t\plottest.t line 2565. Use of uninitialized value in print at t\plottest.t line 2568. Use of uninitialized value in numeric lt (<) at C:/Perl/site/lib/DBD/Chart.pm line 2211. DBD::Chart::st execute failed: CANDLESTICK chart requires at least 3 columns. at C:\Perl-modules\DBI x-Chart-0.04\blib\lib/DBIx/Chart.pm line 425. t\plottestok 8/46Use of uninitialized value in print at t\plottest.t line 2565. Use of uninitialized value in print at t\plottest.t line 2568. t\plottestok 9/46Use of uninitialized value in numeric lt (<) at C:/Perl/site/lib/DBD/Chart.pm l ine 2211. DBD::Chart::st execute failed: PIECHART chart requires at least 2 columns. at C:\Perl-modules\DBIx-C hart-0.04\blib\lib/DBIx/Chart.pm line 425. Use of uninitialized value in print at t\plottest.t line 2565. Use of uninitialized value in print at t\plottest.t line 2568. Use of uninitialized value in numeric lt (<) at C:/Perl/site/lib/DBD/Chart.pm line 2211. DBD::Chart::st execute failed: PIECHART chart requires at least 2 columns. at C:\Perl-modules\DBIx-C hart-0.04\blib\lib/DBIx/Chart.pm line 425. Use of uninitialized value in print at t\plottest.t line 2565. t\plottestok 10/46Use of uninitialized value in print at t\plottest.t line 2568. t\plottestok 11/46Use of uninitialized value in numeric lt (<) at C:/Perl/site/lib/DBD/Chart.pm line 2211. DBD::Chart::st execute failed: HISTOGRAM chart requires at least 2 columns. at C:\Perl-modules\DBIx- Chart-0.04\blib\lib/DBIx/Chart.pm line 425. Use of uninitialized value in print at t\plottest.t line 2565. Use of uninitialized value in print at t\plottest.t line 2568. t\plottestok 12/46Use of uninitialized value in numeric lt (<) at C:/Perl/site/lib/DBD/Chart.pm line 2211. DBD::Chart::st execute failed: LINEGRAPH chart requires at least 2 columns. at C:\Perl-modules\DBIx- Chart-0.04\blib\lib/DBIx/Chart.pm line 425. Use of uninitialized value in print at t\plottest.t line 2565. Use of uninitialized value in print at t\plottest.t line 2568. t\plottestok 13/46Use of uninitialized value in numeric lt (<) at C:/Perl/site/lib/DBD/Chart.pm line
Re: [ANNOUNCE] DBIx::Chart 0.04 (was Re: DBIx::Chart and Params)
Ron Savage wrote: On Wed, 17 Aug 2005 22:35:38 -0400 (EDT), Kenneth Dick wrote: Hi Dean Here' what I get under MS Windows & Perl 5.8.6: C:\Perl-modules\DBIx-Chart-0.04>perl Makefile.PL Configuring DBIx::Chart ... Do you have DBD::CSV installed ? The tests require that. BTW: I built/tested on AS 5.8.3, never got any of those errors - Dean
Re: [ANNOUNCE] DBIx::Chart 0.04 (was Re: DBIx::Chart and Params)
Kenneth Dick wrote: OK, I installed the new versions of DBIx::Chart and DBD::Chart. Now a PH within the select works OK. But, if I try to use a PH within the RETURNING LINEGRAPH paragraph (for example, y-axis = ?, I get the following message: "DBD::Chart::st execute failed: Invalid dataset. at C:/Opt/Perl/site/lib/DBIx/Chart.pm line 425." Any ideas ?? Or is he use of PHs within the RETURNING portion of the chart syntax not supported ?? Thanks, Er, it should work, but I don't think I've tested that very thoroughly yet either, and won't have time to pursue it for a while. Sorry, you'll have to patch in literals for the time being. Regards, Dean Arnold Presicient Corp.
Re: [ANNOUNCE] DBIx::Chart 0.04 (was Re: DBIx::Chart and Params)
On Thu, 18 Aug 2005 08:35:54 -0700, Dean Arnold wrote: Hi Dean > Do you have DBD::CSV installed ? The tests require that. BTW: I > built/tested on AS 5.8.3, never got any of those errors Yes. -- Cheers Ron Savage, [EMAIL PROTECTED] on 19/08/2005 http://savage.net.au/index.html Let the record show: Microsoft is not an Australian company
