Re: How to post? cpan install DBI fails

> $ perl Makefile.PL > $ make > $ make test > $ make install Eyeball the Makefile.PL for dependencies; along with the release docs. Double check any supported library versions listed in the DBI docs. cd to whence the build happens and follow the steps above. What do you get from: make -wk

Re: cpan install DBI fails

Hi Dennis, You should be able to get cpanm by sudo apt-get install cpanminus Does the version of DBI.pm you get from sudo apt-get install libdbi-perl Work for your needs? You should just be able to install the system package. The build problems you're seeing from cpan are likely related to

cpan install DBI fails

Thank you very much for your prompt replies. 1) platforms: (sorry details were in my original .original email)    1a)  My linux (mint)     1b) Raspberry Pi Linux dapi2 5.10.103+ #1529 Tue Mar 8 12:19:18 GMT *2022* armv6l GNU/Linux; cpan (v2.20) After the gcc *warnings:* chmod 755

Re: How to post? cpan install DBI fails

On 6/29/24 18:22, C.J. Collier wrote: I think you figured the mailing list out. Can you tell us about your environment?  On what system are you attempting to install?  Why aren't you using cpanm or your system packages? On Sat, Jun 29, 2024, 15:16 Dennis German

Re: How to post? cpan install DBI fails

I think you figured the mailing list out. Can you tell us about your environment? On what system are you attempting to install? Why aren't you using cpanm or your system packages? On Sat, Jun 29, 2024, 15:16 Dennis German wrote: > I have been having a wonderful discussion with ezmlm. > >

How to post? cpan install DBI fails

I have been having a wonderful discussion with ezmlm. After reading careful, all her recommendations and subscribing and acknowledging, I cannot seem to understand how to post to the mailing list. I am attempting to * * *cpan install DBI*

Version 3.18.0 of DBD::Pg released (Perl DBI driver for Postgres)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Version 3.18.0 of DBD::Pg, the Perl DBI driver for PostgreSQL, is now available. This release adds support for the new PQclosePrepared function inside libpq. What this means is that if DBD::Pg is compiled against version 17 or higher of Postgres,

Re: DBI.pm connects with 'use DBI' to a PostgreSQL server without credentials

El día martes, noviembre 28, 2023 a las 11:14:35 +, Mark Lawrence via dbi-users escribió: > > the 'use DBI;' already does a connect to the server and tries to read > > the names of the available databases from the server: > > I would check this assumption, because it strikes me as extremely

Re: DBI.pm connects with 'use DBI' to a PostgreSQL server without credentials

the 'use DBI;' already does a connect to the server and tries to read the names of the available databases from the server: I would check this assumption, because it strikes me as extremely unlikely. DBI does not load any drivers at use or require/import time. You could add some tracing

DBI.pm connects with 'use DBI' to a PostgreSQL server without credentials

Hello, We encounter with a bigger Perl written applications the problem that in the serverlog of a remote PostgreSQL server appear the following lines: 2023-11-20 10:45:55.826 CET [84269] FATAL: no pg_hba.conf entry for host "172.16.5.3", user "nobody", database "postgres", no encryption ...

DBD::Pg on a client system

Trying to install DBD::Pg on a client system (ie one NOT running a postgres database) it is asking for the location of the pg_config file, which (not surprisingly) doesn’t exist. System is Rocky Linux release 9.2 (Blue Onyx) Postgresql IS installed via the postgres.org repository: dnf info

Re: [EXT]Re: Error with DBD::Pg

[Adding the mailing list back in] You might try turning on DBI_TRACE which will tell you *which* DBD/Pg.pm driver file and version it thinks it successfully loaded. I added the requisite lines to httpd.conf as per here

Re: [EXT]Re: Error with DBD::Pg

Sorry that I keep dripping this out. My mail reader doesn't parse your html emails well and I haven't been reading them thoroughly. You trace output also included this: install_driver: DBD::Pg version undef loaded from /usr/lib64/perl5/vendor_perl/Bundle/DBD/Pg.pm Is that the expected /

Re: [EXT]Re: Error with DBD::Pg

On Mon Oct 30, 2023 at 11:21:42PM +, Johnson, Bruce E - (bjohnson) wrote: DBI 1.643-ithread default trace level set to 0x0/3 (pid 101338 pi 5613a02b73e0) at DBI.pm line 294 via startup.pl line 5 -- DBI::END ($@: , $!: ) DBI 1.643-ithread default trace level set to 0x0/3 (pid 101338

Re: DBD::Oracle forked client hangs with Oracle Client Libraries 19.20 and later.

To follow up, with the hackaround in the previous post, and modify test.pl to dispatch batches of 20 children, it eventually dies with a segfault (below - coredump available on request). Although I can not be sure if this is related to my hack, or the core library. Thanks, Justin   

Re: Error with DBD::Pg

More experimentation reveals that this is possibly an artifact of mod_perl in Apache or some ENV issue since running an application on the command line on the same machine that has the following connection string works my $lda = DBI->connect("dbi:Pg:$dbname", $login, $dbpass, {RaiseError=>1});

Error with DBD::Pg

I am moving some web applications from Oracle to Postgres, and on one system I’m getting the following error: [Fri Oct 27 13:25:19.725785 2023] [:error] [pid 98181:tid 98230] DBD::Pg initialisation failed: Can't locate object method "driver" via package "DBD::Pg" at

DBD::Oracle forked client hangs with Oracle Client Libraries 19.20 and later.

Good day, I am trying to dig into an issue after a recent Oracle update. The application has been running flawlessly from version 9.x to 18.5, and has only broken on the most recent client library updates. Attached is a cut down application which demonstrates the issue. The forked child

Re: [EXT]Re: Is this a DBD::Pg problem or Postgres problem?

Thank you! This is a pattern I've used in a bunch of applications with Oracle, so this helps me fix a bunch of stuff. (Like this app that got pushed live without adequate testing.) On Oct 16, 2023, at 6:35 AM, Peter J. Holzer wrote: On 2023-10-15 23:26:03 +, Johnson, Bruce E - (bjohnson)

Re: Is this a DBD::Pg problem or Postgres problem?

On 2023-10-15 23:26:03 +, Johnson, Bruce E - (bjohnson) wrote: > I’ve move an application to Postgres for the database and am having a problem > with using named parameters. > > My code: > > my $csr_newinv =$lda->prepare("insert into inventory (inv_id, instid, av_id, > vials, volume,

Is this a DBD::Pg problem or Postgres problem?

I’ve move an application to Postgres for the database and am having a problem with using named parameters. My code: my $csr_newinv =$lda->prepare("insert into inventory (inv_id, instid, av_id, vials, volume, expiration_date, update_date) values (nextval(invid_seq),:INST, :AV,:VI,:VO,

DBD::MariaDB 1.23

Hello, New version of DBD::MariaDB 1.23 is now on CPAN: https://metacpan.org/release/PALI/DBD-MariaDB-1.23 DBD::MariaDB is DBI driver for connecting to MariaDB and MySQL databases. It is a fork of DBD::mysql driver which aims to work correctly with Unicode and to have a better support for

Re: DBD::Pg authentication methods

https://www.postgresql.org/docs/current/ssl-tcp.html should get you started. Authentication is documented in https://www.postgresql.org/docs/current/client-authentication.html DBI->connect() accepts various parameters in the first argument when connecting to PostgreSQL, one of them is

DBD::Pg authentication methods

I am in the process of moving from an Oracle-based system to Postgres, and am trying to replicate the setup I have in Oracle. This is primarily for a variety of web-based applications. None of the database users exist as user accounts on the client or servers involved; in Oracle the encryption

Re: Load duplicates

Using perl 5.28 and mysql on windows. Question: Can DBI give me a field from the record on the main table causing the duplicate so I can add that to the record going to the duplicate table? It might be preferable to do this directly in SQL, using triggers. See here for a similar question:

Re: Advice or best practice for updating multiple rows with a single query

Hi, Another opportunity is to use execute_array() instead of execute(). Fore details search for 'execute_array' in 'perldoc DBI'. I use Postgresql in the example below, because I have no MySQL. sub db_update_with_fw_obj_ids { my $data = shift; my (@cust_id, @fw_id); for (values

Re: Advice or best practice for updating multiple rows with a single query

On 2023-08-28 08:57:51 +0200, Ritter wrote: > here is my example code trying to update multiple rows with a single > query. Since the number of lines to be updated varies constantly, both > the placeholders and the data need to be generated dynamically with > each call. > > Based on the

Advice or best practice for updating multiple rows with a single query

Dear Mongers, here is my example code trying to update multiple rows with a single query. Since the number of lines to be updated varies constantly, both the placeholders and the data need to be generated dynamically with each call. Based on the following example

Re: Load duplicates

Geoffrey, Thank you for that info. Working on getting it in. Very helpful. Best regards. On Tue, Aug 15, 2023 at 1:34 PM Geoffrey Rommel wrote: > So are you reading the records one at a time through DBI and looking for > duplicates? There is probably a better way.  > > I work with Teradata,

Re: Load duplicates

So are you reading the records one at a time through DBI and looking for duplicates? There is probably a better way.  I work with Teradata, so I'll use Teradata syntax, but the syntax for other databases will be similar. To find the duplicates in your table, you can select all columns from the

Load duplicates

Hi group, My perl skills are basic and my SQL skills almost match that. Using perl 5.28 and mysql on windows. I have a couple million records that needs processing to go to their final destination. Currently I'm catchin duplicates with error 1062 in perl and using that to write the duplicate

DBD::Informix

Hi, I am trying to install DBD::Informix on Solaris 11.3 that has Informix14.10 database installed. It can build Makefile but than make just hangs. root@plum:~# env |sort _=/usr/bin/env A__z="*SHLVL DBD_INFORMIX_NO_RESOURCE=yes DBD_INFORMIX_USERNAME=sysadmin DISPLAY=localhost:10.0 EDITOR=vi

Re: perl is not working after migrating the server to AIX 7.2

On Thu, 17 Feb 2022 09:42:38 + "MK, Karthick" via dbi-users wrote: > Hello Brain, > > Thanks for your respond.. The server was migrated from 6.1 TL9 SP12 > to 7.2 TL5 SP3. The DB2 version is 10.5 and Perl version before > migration it was 5.8.8 and now it is 5.28.1 You ever got this

Re: Oracle connection error

Where is the library installed to? In what directory? Is that directory referenced in the /etc/ld.so.conf file? If not, add it and then run "ldconfig" command, then re-try. On Thu, Jan 12, 2023 at 11:32 AM Syed Abdulla wrote: > Thank you Clive. I installed the library libnsl.x86_64. Below

Re: Oracle connection error

Tough luck! That isn't working either. I tried: make realclean perl Makefile.PL LINKTYPE=static make make perl (you'll need to use and install _this_ new perl binary) make test make -f Makefile.aperl inst_perl MAP_TARGET=perl (install new perl) make install and then I see

Re: Oracle connection error

Thank you Clive. I installed the library libnsl.x86_64. Below I pasted outputs from the commands. I logged in as root. *# dnf install libnsl.x86_64* *Last metadata expiration check: 0:04:34 ago on Thu 12 Jan 2023 04:22:12 PM UTC.* *Package libnsl-2.28-189.5.el8_6.x86_64 is already installed.*

Re: Oracle connection error

dnf install libnsl.x86_64 > On 12 Jan 2023, at 14:25, Syed Abdulla wrote: > > Hi, > > While installing Perl DBI module to connect to Oracle 19c on RedHat 8 VM, I > see the below error and the installation fails. > > /usr/bin/ld: cannot find -lnsl > collect2: error: ld returned 1 exit status

Oracle connection error

Hi, While installing Perl DBI module to connect to Oracle 19c on RedHat 8 VM, I see the below error and the installation fails. /usr/bin/ld: cannot find -lnsl collect2: error: ld returned 1 exit status make: *** [Makefile:524: blib/arch/auto/DBD/Oracle/Oracle.so ] Error 1

Re: Table Value Parameter for SQL server

Hi Rich. I had a similar task and for me the best way to bulk import a large number of rows into SQL Server was to use the bcp utility. Here's a great resource for it: https://www.red-gate.com/simple-talk/sql/database-administration/working-with-the-bcp-command-line-utility/ I create a

Table Value Parameter for SQL server

Hi All, I am attempting to bulk merge a lot of rows quickly to an mssql server and I understand that table value parameters are a possible option for doing so. I set up the following test objects on the sql server (modeled after a python example of sorts from

Fatal error trying to install DBI on Cygwin

Good day. I am receiving an error when trying to install DBI on a fresh Cygwin install. Enclosed is a screenshot of the error, and output from cygcheck. Do you have an idea on where I might look next? I am inexperienced in Cygwin, and have installed DBI only twice before. Running Mkbootstrap

Re: please help with DBD-Oracle-1.76

Also the SDK package needs to be installed or the build fails. Minimum for DBD::Oracle are the Basic and SDK packages. On Sep 5, 2022, at 6:43 AM, kmo...@esntech.com wrote: Hi Daniel, I have three questions. 1. Did you install the instant client as root? I

RE: please help with DBD-Oracle-1.76

Hi Daniel, I have three questions. 1. Did you install the instant client as root? I always install it as Oracle. 2. LD_LIBRARY_PATH should be set as =/root/ora2pg/instantclient_21_7/lib in your case 3. The link you provided has a download to sqlplus, I’d suggest you

Fwd: please help with DBD-Oracle-1.76

> Begin forwarded message: > > From: Daniel Chmielewski > Subject: Fwd: please help with DBD-Oracle-1.76 > Date: 5 September 2022 at 10:03:15 IST > To: t...@cpan.org > > Tim, please help. > Regards, > Daniel > > > -- Forwarded message - > Od: Daniel Chmielewski

DBD::Pg version 3.16.0 released

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Version 3.16.0 of DBD::Pg, the Perl DBI driver for PostgreSQL, is now available. The full list of changes for 3.16.0 is listed below. Development happens at: https://github.com/bucardo/dbdpg Version 3.16.0 can be downloaded from CPAN at:

Oracle DBD with 19c - forked child hangs on exit

We just upgraded one of our database servers from Oracle 12.2.0.1 to 19.15.0 and one our perl programs is behaving differently. We are running with RedHat 8.4 using Perl v5.26.3 and the latest DBD::Oracle and DBI from cpan. Under 19c, a forked child hangs on exit if the parent has (or had) an

Please test DBD::Oracle v1.90_1

Hi All, Anyone using DBD::Oracle is invited to test out out this dev release v1.90_1 Download from metacpan https://metacpan.org/release/ZARQUON/DBD-Oracle-1.90_1 GH Tag https://github.com/perl5-dbi/DBD-Oracle/tree/v1.90_1 v1.90 candidate branch

Re: [External] : DBD::Oracle use_drcp and connection class

On 5/3/2022 3:44 am, Andrei A. Voropaev via dbi-users wrote: Hello, after looking at the sources of DBD::Oracle I am somewhat confused. OCI offers Session pooling and Connection pooling. "DRCP" is abbreviation for "connection pooling", but DBD::Oracle offers "session pooling", which is not

DBD::Oracle use_drcp and connection class

Hello, after looking at the sources of DBD::Oracle I am somewhat confused. OCI offers Session pooling and Connection pooling. "DRCP" is abbreviation for "connection pooling", but DBD::Oracle offers "session pooling", which is not exactly the same. Connected to this is the question about

RE: perl is not working after migrating the server to AIX 7.2

Hello Brain, Thanks for your respond.. The server was migrated from 6.1 TL9 SP12 to 7.2 TL5 SP3. The DB2 version is 10.5 and Perl version before migration it was 5.8.8 and now it is 5.28.1 Thanks and Regards, Karthick MK Email : karthick...@accenture.com

DBD driver for Apache Ignite

I've been working on a DBD driver for Apache Ignite that interfaces ultimately via Ignite's binary protocol interface. Wanted to make sure no driver is already in the works. I know one could use the ODBC or JDBC packages, but that requires support on Ignite server side, which some DBAs might not

Re: perl is not working after migrating the server to AIX 7.2

When I get errors from CPAN I usually switch to whet or curl to get the package them make ; make all and make test ; make install. You could also try cpanm and see if it gives you better error messages - if you are building binary packages you May need a c compiler - easy with Linux - may be

perl is not working after migrating the server to AIX 7.2

Hello Team, We have migrated our AIX server from 6.1 to 7.2 . After the migration the perl is upgraded with v5.28.1 but perl scripts are not working . We are getting below error message. Could you please take a look of below and help us to fix this issue. Can't locate DBI.pm

RE: [EXTERNAL] Re: select decimal column from mysql

Before someone points out that my description of perl variables is incomplete: Here are the extra details for the very curious: https://perldoc.perl.org/perlguts#Datatypes https://metacpan.org/pod/Scalar::Util https://perldoc.perl.org/Scalar::Util#dualvar

RE: [EXTERNAL] Re: select decimal column from mysql

Variables in perl are “untyped” or better yet “dynamically typed”. Every variable is a string but will behave like a int or float in the right context. Conversions from string to int to float and back to string happen automatically and silently. This may be surprising and confusing if you are

Re: select decimal column from mysql

sorry, please ignore this stupid question, 0.015 is > 0 On Mon, Dec 20, 2021 at 2:19 PM john miky wrote: > hmm. it is perl's "problem", not dbi. > > On Mon, Dec 20, 2021 at 1:20 PM john miky wrote: > >> hi, >> >> I select a decimal column, from mysql with dbi, >> the value 0.015 for example,

Re: select decimal column from mysql

hmm. it is perl's "problem", not dbi. On Mon, Dec 20, 2021 at 1:20 PM john miky wrote: > hi, > > I select a decimal column, from mysql with dbi, > the value 0.015 for example, my ($v) = $dbh->selectrow_array("select > price from test limit 1") > it is greater than 0 in perl. > > What's the

select decimal column from mysql

hi, I select a decimal column, from mysql with dbi, the value 0.015 for example, my ($v) = $dbh->selectrow_array("select price from test limit 1") it is greater than 0 in perl. What's the proper way to get a float value ?

Re: Debian Buster -> Bullseye upgrade issue with UTF8?

On Tue, Aug 17, 2021 at 3:42 AM Simon Cruickshank < simon.cruicksh...@gmail.com> wrote: > I use perl CGI::Session on a Debian buster box, after upgrading to > Bullseye the website barfs with message :- > > DBD::mysql::db do failed: Incorrect string value: > '\xF9\x08a\x00\x00\x00...' for column

Re: Debian Buster -> Bullseye upgrade issue with UTF8?

Sorry I was mistaken I actually use CGI::Application::Plugin::Session but I will look into your suggestion. Many thanks, Simon On Tue, 17 Aug 2021 at 10:14, wrote: > Hi Simon > > Did you see the same issue when replacing the deprecated CGI::Session > with my module Data::Session? > > I must

Re: Debian Buster -> Bullseye upgrade issue with UTF8?

Hi Simon Did you see the same issue when replacing the deprecated CGI::Session with my module Data::Session? I must confess I don't expect the latter to fix this particular problem. --- Cheers Ron savage.net.au On 2021-08-17 17:41, Simon Cruickshank wrote: I use perl CGI::Session on a

Debian Buster -> Bullseye upgrade issue with UTF8?

I use perl CGI::Session on a Debian buster box, after upgrading to Bullseye the website barfs with message :- DBD::mysql::db do failed: Incorrect string value: '\xF9\x08a\x00\x00\x00...' for column `webapp`.`sessions`.`a_session` at row 1 at /usr/share/perl5/CGI/Session I can recreate the issue

Re: Strange issue with inserting varchar2()

On 2021-05-27 23:35:32 +, Bruce Johnson wrote: > The column in question is a varchar2(4000) so I am truncating the > input to 4000 bytes. > > (via use “bytes; $string=substr($orig,0,4000); ” in the section where > I actually truncate the string.) > > When I do the insert I get an

Re: Strange issue with inserting varchar2()

That would work, I think. Or, just changing the datatype in the table for the comments to a 4K CLOB in the *first* place, then the perl side truncate would work. This table is truncated each year, so there’s no real need to maintain any sort of historical data. On May 28, 2021, at 3:55 AM,

Re: Strange issue with inserting varchar2()

What about truncating the data in PLSQL? Eg an insert function? It would have to input a CLOB I would guess… Sent from my iPhone > On May 28, 2021, at 4:15 AM, Marcus Bergner wrote: > >  > The way I have done it is to ensure that truncation only happens on valid > UTF-8 boundaries but

Re: Strange issue with inserting varchar2()

The way I have done it is to ensure that truncation only happens on valid UTF-8 boundaries but length calculation is done in "use bytes" mode, and then try to guesstimate where to make the UTF-8 cut, and try that repeatedly until you manage to go under the max size you specified. Then you

RE: Strange issue with inserting varchar2()

One more https://stackoverflow.com/questions/1454952/dummys-guide-to-unicode The information contained in this electronic mail transmission is intended only for the use of the individual or entity named in this transmission. If you are not the intended recipient of this transmission, you

RE: Strange issue with inserting varchar2()

Here are a few articles if you really want to dig in https://stackoverflow.com/questions/5290182/how-many-bytes-does-one-unicode-character-take https://docs.oracle.com/database/121/NLSPG/ch2charset.htm#NLSPG1037 https://metacpan.org/pod/Text::Iconv

Re: Strange issue with inserting varchar2()

I’m beginning to think that just truncating the string to something well short of the column limit is going to be the simplest way to go. This has been a persistent issue in the past with earlier versions of this app that were handled by the previous programmer/dba by…manually editing the file

RE: Strange issue with inserting varchar2()

UTF-8 has a variable number of bytes per character. Some encodings have 1 byte per character always. Some encodings have two bytes per character always. Assuming that the number of bytes is the same as the number of characters sometimes leads to wrong answers. When you are using perl as a

Re: Strange issue with inserting varchar2()

On Thursday 27 May 2021 23:35:32 Bruce Johnson wrote: > use bytes; $string=substr($orig,0,4000); Hello! This is really suspicious. See **BOLD** description of 'bytes' module: **Use of this module for anything other than debugging purposes is strongly discouraged.** **If you feel that the

Strange issue with inserting varchar2()

I'm working on an app that processes (among other thing) long sections of text, and I’m running into odd multi-byte characters in some of the entries. The column in question is a varchar2(4000) so I am truncating the input to 4000 bytes. (via use “bytes; $string=substr($orig,0,4000); ” in the

DBD::Pg version 3.15.0 released

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Version 3.15.0 of DBD::Pg, the Perl DBI driver for PostgreSQL, is now available. The full (but short) list of changes for 3.15.0 is listed below. Development happens at: https://github.com/bucardo/dbdpg Version 3.15.0 can be downloaded from CPAN

Re: DBD::Oracle insert speed

On 10/1/21 11:22 am, Peter Meszaros wrote: Hi, I have already asked this question at perlmonks.org but I did not get proper answer. Module DBD::Oracle

DBD::Oracle insert speed

Hi, I have already asked this question at perlmonks.org but I did not get proper answer. Module DBD::Oracle has serious performance degradation at inserting rows. Except execute_array (or bind_param_array), all other insert solutions are pretty

Re: [EXTERNAL] Re: DBI.pm - Memoryfault(coredump)

Please see below with more details; dbh declaration is of perl hash. my %connection_hash = (); # keep open connections $connection_hash{$dbname} = DBI->connect( $sid, $user, $pass, {AutoCommit => $autocommit_flag}); for(keys %connection_hash){ lib_log::debug_msg("Connection hash of $_ is

Re: [EXTERNAL] Re: DBI.pm - Memoryfault(coredump)

These connection strings are not the same. There really is not much to say about them without code samples that include variable definitions. On Wed, Oct 28, 2020 at 13:06 Srikantha wrote: > Hello Fennel & David, > Thanks a lot for your response. FInally I could sort out the segmentation >

Re: (Fwd) DBD:Oracle

I have not looked at this list in some time, but today I am doing so. That explains the late response, which is probably too late Ajay. If Oracle 12c is already installed, then Perl and DBD::Oracle are also installed. Oracle depends quite heavily on Perl for several utilities. Try

Re: [EXTERNAL] Re: DBI.pm - Memoryfault(coredump)

I forgot to mention, when I print what is there in the hash after DBI->connect, I see an extra line(see o/p section) is coming up there. *Regards* *Srikantha* *Mb-9980073640* On Mon, Nov 2, 2020 at 6:49 PM Srikantha wrote: > Basically below connection_hash is causing a core dump. Can you

Re: [EXTERNAL] Re: DBI.pm - Memoryfault(coredump)

Basically below connection_hash is causing a core dump. Can you please guide me, how I can rewrite this? In the previous email, the Not working db handle is using a hash method and which is what dumps core. code: my %connection_hash = (); # keep open connections for(keys %connection_hash){

Re: [EXTERNAL] Re: DBI.pm - Memoryfault(coredump)

Hello Fennel & David, Thanks a lot for your response. FInally I could sort out the segmentation fault/Memory dump error after too many rounds of debugging. Basically I can blame it on the Oracle connection but I may be wrong as there are few minor changes(could be on connection_hash too) in the

Re: [EXTERNAL] Re: DBI.pm - Memoryfault(coredump)

I wonder what the difference between "$sid" and "dbi:$db_driver:$db" is. If nothing, it would look like Oracle::DBD might have some kind of weakness regarding multiple active connections, if the fault happens later instead of right at connect time, like on the second time through, with a different

Re: DBI.pm - Memoryfault(coredump)

On Tuesday, October 27, 2020 1:18:29 PM EDT Bruce Johnson wrote: > Or the client isn’t installed or the environment variables are not > set properly, or, or... > > RHEL, Fedora and CentOS do NOT include DBD::Oracle in their > pre-built perl modules. Like Gary I’ve always had to build it with >

Re: DBI.pm - Memoryfault(coredump)

On Oct 26, 2020, at 7:31 PM, Garry T. Williams mailto:gtwilli...@gmail.com>> wrote: On Monday, October 26, 2020 11:47:54 AM EDT David Nicol wrote: if the Oracle module is maintained by red hat, yum update should help. If you built it in-house, you may need to yum update the perl development

Re: DBI.pm - Memoryfault(coredump)

On Monday, October 26, 2020 11:47:54 AM EDT David Nicol wrote: > if the Oracle module is maintained by red hat, yum update should > help. If you built it in-house, you may need to yum update the perl > development environment and reinstall. This is good advice. The original poster also should

Re: [EXTERNAL] Re: DBI.pm - Memoryfault(coredump)

I think the following links should cover all the pieces needed for Perl/JDBC/Oracle https://www.oracle.com/database/technologies/appdev/jdbc.html https://metacpan.org/pod/distribution/DBD-JDBC/JDBC.pod https://sdkman.io/ Perl can launch the java server using qx: https://perlmaven.com/qx This

Re: [EXTERNAL] Re: DBI.pm - Memoryfault(coredump)

Also consider switching to the JDBC module and using the Oracle JDBC driver. The JDBC driver requires launching a Java server which perl accesses via sockets which is available from CPAN but is not simply a drop in replacement for other DBI / DBD modules. I had to downgrade both perl and

Re: DBI.pm - Memoryfault(coredump)

if the Oracle module is maintained by red hat, yum update should help. If you built it in-house, you may need to yum update the perl development environment and reinstall. On Fri, Oct 23, 2020 at 11:27 PM Srikantha wrote: > Hello, > We are having the below issue from one of the perl modules. We

DBI.pm - Memoryfault(coredump)

Hello, We are having the below issue from one of the perl modules. We are trying to get Oracle query results via this perl package and that package is using DBI.pm. The perl script is executing end-end but at the end there is a segmentation fault error. We have recently upgraded our RHEL version

DBD::Pg 3.14.0 released

-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Version 3.14.0 of DBD::Pg, the Perl DBI driver for PostgreSQL, is now available. The full list of changes for 3.12.0 through 3.14.0 is below. Development happens at: https://github.com/bucardo/dbdpg Version 3.14.0 can be downloaded from

RE: DBD error

Hi Bala, I’d show this to my sys admin, looks like there are missing libraries on your system. Cheers From: Bala GANESH Sent: Tuesday, July 21, 2020 3:18 AM To: Kevin Moore Cc: Christopher Jones ; dbi-users@perl.org Subject: Re: DBD error HI Kevin, While DB:Oracle ,

Re: DBD error

In message , Bala GANESH writes: >ld: 0711-736 ERROR: Input file /oracle/product/19.7/lib/libclntsh.so: >XCOFF64 object files are not allowed in 32-bit mode. $ file `which perl` $ file /oracle/product/19.7/lib/libclntsh.so John groenv...@acm.org

Re: DBD error

On 17/07/2020 13:02, Bala GANESH wrote:         LD_RUN_PATH="/oracle/product/19.7/lib:/oracle/product/19.7/rdbms/lib" ld  -bhalt:4 -G -bI:/usr/opt/perl5/lib/5.28.1/aix-thread-multi/CORE/perl.exp  -bnoentry -lpthreads -lc -lm -bE:Oracle.exp Oracle.o  dbdimp.o  oci8.o  -o

Re: DBD error

On 17/7/20 10:02 pm, Bala GANESH wrote: Hi Support, "Support" ? :) I am receiving following error while installing DBD Perl module on IBM AIX 7.1 .Please help me to solve this.. bash-3.2# perl Makefile.PL

DBD error

Hi Support, I am receiving following error while installing DBD Perl module on IBM AIX 7.1 .Please help me to solve this.. bash-3.2# perl Makefile.PL * ld:

(Fwd) DBD:Oracle

- Forwarded message from Ajay Kumar - Date: Mon, 13 Jul 2020 15:32:55 + From: Ajay Kumar To: Tim Bunce Subject: DBD:Oracle Hi Tim, Hope, you are sound and safe with your loved ones. I am trying to install the ORA2PG tool which migrates Oracle data into PostgreSQL

DBI NULLs Test

Using DBI:mysql:database=mysql;hostname=localhost, db version: 5.5.5-10.1.41-MariaDB-0ubuntu0.18.04.1 => Drop table 'dbi__null_test_tmp', if it already exists... => Create table 'dbi__null_test_tmp'... => Insert 4 rows into the table...    Inserting values (1, 'Homer')    Inserting values (2,

Re: DBD::Oracle 1.80 & Oracle client 19c Segfaults on Destroy

Actually, I did exactly this a few years ago. Only problem: NULLs show up as blanks ... Apart from that, it works like a charm! -- Peter Vanroose. Op 23 jun. 2020 22:10, om 22:10, "Fennell, Brian" schreef: >Another idea . . . > >You could also wrap Oracle SQLPlus in perl using qx > >How-to

Re: DBD::Oracle 1.80 & Oracle client 19c Segfaults on Destroy

Another idea . . . You could also wrap Oracle SQLPlus in perl using qx How-to SQLPLUS and XML here: https://asktom.oracle.com/pls/apex/f?p=100:11:0P11_QUESTION_ID:3512822500346787661 That and a little perl text parsing could get you a long way - split , grep, map, s and tr. This

RE: [EXTERNAL] Re: DBD::Oracle 1.80 & Oracle client 19c Segfaults on Destroy

FYI The Oracle DBD driver is hard to build, it requires Oracle C Libraries and Header files. It also requires Oracle Development files described by Oracle as Examples, but which are really templates for building any C client. All Oracle C Clients are hard to build. If I recall sometimes a

  1   2   3   4   5   6   7   8   9   10   >