Re: [EXTERNAL] Re: DBI.pm - Memoryfault(coredump)
[email protected] (Jared Still) Thu, 26 Nov 2020 09:11:08 -0800
| Newsgroups | perl.dbi.users |
|---|---|
| Message-ID | <CAORjz=PTrrKaO9yFehwcY+7sEq-LBQb5qcDUVH2v78SbTm9eWA@mail.gmail.com> |
--000000000000e810ae05b505a15f Content-Type: text/plain; charset="UTF-8" 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 <[email protected]> wrote: > 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 custom > perl module which we are using for Oracle connection. I am using the perl > module one which is using the 2nd method below and after that I am not > finding the Memory core dump error. > > $connection_hash{$dbname} = DBI->connect( $sid, $user, $pass, {AutoCommit > => $autocommit_flag}); -- Not working > my $dbh = DBI->connect("dbi:$db_driver:$db", $user, $pass, { RaiseError => > 1, AutoCommit => 1 }) or die ("failed to login $db_user"); -- Working > > *Regards* > *Srikantha* > > > > On Tue, Oct 27, 2020 at 2:52 AM Fennell, Brian <[email protected]> > wrote: > >> 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 is possibly a tangent: >> The last time I dug into this I couldn't figure out how to build >> DBD::Oracle from source using a Git source (in place of CPAN) >> There is very brief mention the cpanm support for git here >> https://metacpan.org/pod/distribution/App-cpanminus/bin/cpanm >> (search the page for "git" ) >> There is better documentation (sort of) hidden in the closed issues here >> - several uri formats can be used: >> https://metacpan.org/pod/distribution/App-cpanminus/bin/cpanm >> https://github.com/miyagawa/cpanminus/issues/296 >> >> https://github.com/miyagawa/cpanminus/commit/cf9a72038123a2f721508f17ec8d314cae03245a >> >> https://github.com/miyagawa/cpanminus/pull/165 >> >> https://github.com/miyagawa/cpanminus/commit/8d82465cc0dde2bd35cd7b454f06f7fba9f205f8 >> >> https://github.com/miyagawa/cpanminus/pull/230 >> >> https://github.com/miyagawa/cpanminus/commit/c588cd7f5fa3fa6c9dcc30d1f4c958c4d45680c1 >> >> >> I found two github repos with incidents - the second seems most active >> https://github.com/sergadin/dbd-oracle >> https://github.com/gitpan/DBD-Oracle >> >> >> >> This is also helpful: >> https://metacpan.org/pod/DBI#trace >> https://metacpan.org/pod/DBI#TRACING >> >> >> >> >> >> >> 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 are hereby notified that any disclosure, copying or distribution of the >> contents of this transmission is strictly prohibited and that you should >> delete the contents of this transmission from your system immediately. Any >> comments or statements contained in this transmission do not necessarily >> reflect the views or position of Radial or its subsidiaries and/or >> affiliates. >> >> >> -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist Principal Consultant at Pythian Oracle ACE Alumni Pythian Blog http://www.pythian.com/blog/author/still/ Github: https://github.com/jkstill --000000000000e810ae05b505a15f Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"auto">These connection strings are not the same.</div><div dir= =3D"auto"><br></div><div dir=3D"auto">There really is not much to say about= them without code samples that include variable definitions.</div><div dir= =3D"auto"><br></div><div dir=3D"auto"><br></div><div><br><div class=3D"gmai= l_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, Oct 28, 2020 at 13:0= 6 Srikantha <<a href=3D"mailto:[email protected]">srikanthatn@gmail.= com</a>> wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"marg= in:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr"= ><div class=3D"gmail_default" style=3D"font-family:georgia,serif">Hello Fen= nel & David,</div><div class=3D"gmail_default" style=3D"font-family:geo= rgia,serif">Thanks a lot for your response. FInally I could sort out the se= gmentation fault/Memory dump error after too many rounds of debugging.=C2= =A0</div><div class=3D"gmail_default" style=3D"font-family:georgia,serif">B= asically=C2=A0I 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 custom= perl module which we are using for Oracle connection. I am using the perl = module one which is using the 2nd method below and after that I am not find= ing the Memory core dump error.=C2=A0</div><div class=3D"gmail_default" sty= le=3D"font-family:georgia,serif"><br></div><div class=3D"gmail_default" sty= le=3D"font-family:georgia,serif">$connection_hash{$dbname} =3D DBI->conn= ect( $sid, $user, $pass, {AutoCommit =3D> $autocommit_flag}); -- <span s= tyle=3D"background-color:rgb(255,153,0)">Not working</span><br>my $dbh =3D = DBI->connect("dbi:$db_driver:$db", $user, $pass, { RaiseError = =3D> 1, AutoCommit =3D> 1 }) or die ("failed to login $db_user&q= uot;); -- <span style=3D"background-color:rgb(0,255,0)">Working</span><br><= /div><div class=3D"gmail_default" style=3D"font-family:georgia,serif"><br><= /div><div><div dir=3D"ltr" data-smartmail=3D"gmail_signature"><div dir=3D"l= tr"><div dir=3D"ltr"><i><b>Regards</b></i></div></div></div></div></div><di= v dir=3D"ltr"><div><div dir=3D"ltr" data-smartmail=3D"gmail_signature"><div= dir=3D"ltr"><div dir=3D"ltr"><div><i><b>Srikantha</b></i></div><div><br></= div></div></div></div></div><br></div><br><div class=3D"gmail_quote"><div d= ir=3D"ltr" class=3D"gmail_attr">On Tue, Oct 27, 2020 at 2:52 AM Fennell, Br= ian <<a href=3D"mailto:[email protected]" target=3D"_blank">fennellb@r= adial.com</a>> wrote:<br></div><blockquote class=3D"gmail_quote" style= =3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding= -left:1ex"> <div dir=3D"ltr"> <div style=3D"font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt= ;color:rgb(0,0,0)"> I think the following links should cover all the pieces needed for Perl/JDB= C/Oracle</div> <div style=3D"font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt= ;color:rgb(0,0,0)"> <br> </div> <div style=3D"font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt= ;color:rgb(0,0,0)"> <a href=3D"https://www.oracle.com/database/technologies/appdev/jdbc.html" i= d=3D"m_-8015409148471072627gmail-m_-3299087847785135721gmail-m_-74321526053= 30080232LPlnk321308" target=3D"_blank">https://www.oracle.com/database/tech= nologies/appdev/jdbc.html</a>=C2=A0 <div><a href=3D"https://metacpan.org/pod/distribution/DBD-JDBC/JDBC.pod" id= =3D"m_-8015409148471072627gmail-m_-3299087847785135721gmail-m_-743215260533= 0080232LPlnk468882" target=3D"_blank">https://metacpan.org/pod/distribution= /DBD-JDBC/JDBC.pod</a>=C2=A0</div> <div><a href=3D"https://sdkman.io/" id=3D"m_-8015409148471072627gmail-m_-32= 99087847785135721gmail-m_-7432152605330080232LPlnk752219" target=3D"_blank"= >https://sdkman.io/</a></div> <div>Perl can launch the java server using qx:</div> <div><a href=3D"https://perlmaven.com/qx" id=3D"m_-8015409148471072627gmail= -m_-3299087847785135721gmail-m_-7432152605330080232LPlnk342726" target=3D"_= blank">https://perlmaven.com/qx</a>=C2=A0</div> <div><br> </div> <div><br> </div> <div>This is possibly a tangent:</div> <div>The last time I dug into this I couldn't figure out how to build D= BD::Oracle from source using a Git source (in place of CPAN)=C2=A0</div> <div>There is very brief mention the cpanm support for git here</div> <div><a href=3D"https://metacpan.org/pod/distribution/App-cpanminus/bin/cpa= nm" id=3D"m_-8015409148471072627gmail-m_-3299087847785135721gmail-m_-743215= 2605330080232LPlnk" target=3D"_blank">https://metacpan.org/pod/distribution= /App-cpanminus/bin/cpanm</a><br> </div> <div>(search the page for "git" )</div> <div></div> There is better documentation (sort of) hidden in the closed issues here - = several uri formats can be used:<br> <div><a href=3D"https://metacpan.org/pod/distribution/App-cpanminus/bin/cpa= nm" id=3D"m_-8015409148471072627gmail-m_-3299087847785135721gmail-m_-743215= 2605330080232LPlnk752419" target=3D"_blank">https://metacpan.org/pod/distri= bution/App-cpanminus/bin/cpanm</a>=C2=A0 <div><a href=3D"https://github.com/miyagawa/cpanminus/issues/296" id=3D"m_-= 8015409148471072627gmail-m_-3299087847785135721gmail-m_-7432152605330080232= LPlnk204524" target=3D"_blank">https://github.com/miyagawa/cpanminus/issues= /296</a>=C2=A0</div> <div><a href=3D"https://github.com/miyagawa/cpanminus/commit/cf9a72038123a2= f721508f17ec8d314cae03245a" id=3D"m_-8015409148471072627gmail-m_-3299087847= 785135721gmail-m_-7432152605330080232LPlnk568719" target=3D"_blank">https:/= /github.com/miyagawa/cpanminus/commit/cf9a72038123a2f721508f17ec8d314cae032= 45a</a>=C2=A0</div> <div><a href=3D"https://github.com/miyagawa/cpanminus/pull/165" id=3D"m_-80= 15409148471072627gmail-m_-3299087847785135721gmail-m_-7432152605330080232LP= lnk522979" target=3D"_blank">https://github.com/miyagawa/cpanminus/pull/165= </a>=C2=A0</div> <div><a href=3D"https://github.com/miyagawa/cpanminus/commit/8d82465cc0dde2= bd35cd7b454f06f7fba9f205f8" id=3D"m_-8015409148471072627gmail-m_-3299087847= 785135721gmail-m_-7432152605330080232LPlnk299657" target=3D"_blank">https:/= /github.com/miyagawa/cpanminus/commit/8d82465cc0dde2bd35cd7b454f06f7fba9f20= 5f8</a>=C2=A0</div> <div><a href=3D"https://github.com/miyagawa/cpanminus/pull/230" id=3D"m_-80= 15409148471072627gmail-m_-3299087847785135721gmail-m_-7432152605330080232LP= lnk995498" target=3D"_blank">https://github.com/miyagawa/cpanminus/pull/230= </a>=C2=A0</div> <div><a href=3D"https://github.com/miyagawa/cpanminus/commit/c588cd7f5fa3fa= 6c9dcc30d1f4c958c4d45680c1" id=3D"m_-8015409148471072627gmail-m_-3299087847= 785135721gmail-m_-7432152605330080232LPlnk537993" target=3D"_blank">https:/= /github.com/miyagawa/cpanminus/commit/c588cd7f5fa3fa6c9dcc30d1f4c958c4d4568= 0c1</a>=C2=A0</div> <div><br> </div> <div>I found two github repos with incidents - the second seems most active= </div> <div><a href=3D"https://github.com/sergadin/dbd-oracle" id=3D"m_-8015409148= 471072627gmail-m_-3299087847785135721gmail-m_-7432152605330080232LPlnk71249= 4" target=3D"_blank">https://github.com/sergadin/dbd-oracle</a>=C2=A0 <div><a href=3D"https://github.com/gitpan/DBD-Oracle" id=3D"m_-801540914847= 1072627gmail-m_-3299087847785135721gmail-m_-7432152605330080232LPlnk334590"= target=3D"_blank">https://github.com/gitpan/DBD-Oracle</a>=C2=A0</div> <br> <br> </div> <br> This is also helpful:=C2=A0</div> <div><a href=3D"https://metacpan.org/pod/DBI#trace" id=3D"m_-80154091484710= 72627gmail-m_-3299087847785135721gmail-m_-7432152605330080232LPlnk283632" t= arget=3D"_blank">https://metacpan.org/pod/DBI#trace</a>=C2=A0 <div><a href=3D"https://metacpan.org/pod/DBI#TRACING" id=3D"m_-801540914847= 1072627gmail-m_-3299087847785135721gmail-m_-7432152605330080232LPlnk957460"= target=3D"_blank">https://metacpan.org/pod/DBI#TRACING</a>=C2=A0</div> <br> <br> </div> <div><br> </div> <div><br> </div> </div> =C2=A0<br> <span style=3D"font-size:12pt;font-family:Cambria,"times new roman&quo= t;,garamond,serif;color:rgb(255,0,0)"></span><br> <p style=3D"font-size:8pt;line-height:10pt;font-family:Cambria,"times = roman",serif"> 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 are hereby no= tified that any disclosure, copying or distribution of the contents of this transmission is strictly prohibite= d and that you should delete the contents of this transmission from your sy= stem immediately. Any comments or statements contained in this transmission= do not necessarily reflect the views or position of Radial or its subsidiaries and/or affiliates. </p> <br> <br> <div></div> </div> </blockquote></div> </blockquote></div></div>-- <br><div dir=3D"ltr" class=3D"gmail_signature" = data-smartmail=3D"gmail_signature"><div dir=3D"ltr"><div><div dir=3D"ltr"><= div><div dir=3D"ltr"><div dir=3D"ltr">Jared Still<br>Certifiable Oracle DBA= and Part Time Perl Evangelist<div>Principal Consultant at Pythian</div><di= v>Oracle ACE Alumni<br><div>Pythian Blog=C2=A0<a href=3D"http://www.pythian= .com/blog/author/still/" target=3D"_blank">http://www.pythian.com/blog/auth= or/still/</a></div><div>Github:=C2=A0<a href=3D"https://github.com/jkstill"= target=3D"_blank">https://github.com/jkstill</a><br><br><br></div></div></= div></div></div></div></div></div></div> --000000000000e810ae05b505a15f--