Re: DBD::Oracle 1.72 fail
On 2014-04-15, 7:38 AM, H.Merijn Brand wrote: Builds fail on Linux with OIC-12.1 Is 1.70 faring any better? If I read the logs correctly, the problem is dbdimp.h:311:27: error: âimp_dbhâ undeclared (first use in this function) ((csform==SQLCS_NCHAR) ? imp_dbh-ncharsetid : imp_dbh-charsetid) and that didn't change since last December, so it should be in 1.70, but not 1.68. Cheers, `/anick -- Yanick Champoux Solutions Architect Pythian - Love your data champ...@pythian.com Tel: +1 613 565 8696 x 274 www.pythian.com -- --
Re: DBD::Oracle 1.72 fail
On 2014-04-15, 11:18 AM, H.Merijn Brand wrote: Is 1.70 faring any better? Thanks, that help a lot! The culprit seems to be https://github.com/pythian/DBD-Oracle/commit/957f54750ba8c1972beabd1dcd305bd6c47c4586 I'll check with Martin, as he wrote the code and has much, much higher chances to understand what is going there. :-) Cheers, `/anick -- Yanick Champoux Solutions Architect Pythian - Love your data champ...@pythian.com Tel: +1 613 565 8696 x 274 www.pythian.com -- --
Re: What identity do you want in the DBI commit history?
On 13-04-03 10:14 AM, Tim Bunce wrote: ASAP please! (Else your attribution above will be cast in digital stone.) Fwiw: mostly stone. For later changes of heart, git can deal with changing details / aggregate identities via a .mailmap file (see https://www.kernel.org/pub/software/scm/git/docs/git-shortlog.html section 'Mapping Authors'). Joy, `/anick -- --
Re: Moving to git - (Fwd) svn.perl.org shutdown
On 13-03-31 02:07 PM, Yanick Champoux wrote: And while we are talking of repos and DBD::Oracle, Pythian serendipitously created a GitHub account a few days ago (https://github.com/pythian), so I would expect that the main repo would eventually migrate there. When/if that happens, I'll make sure to propagate the news in all pertinent mailing lists. FYI: I've got poked this morning by the Power That Is to indeed move the GitHub home of DBD-Oracle under the Pythian umbrella. So I did just that and released a new version of the distribution with all the pertinent META fields updated to its new home. Joy, `/anick -- Yanick Champoux Senior Perl Developer Pythian - Love your data champ...@pythian.com Tel: +1 613 565 8696 x 274 www.pythian.com -- --
Re: Moving to git - (Fwd) svn.perl.org shutdown
On 13-04-01 01:58 PM, Steffen Winkler wrote: Perl DBI development in a P y t h o n like named repository, is that a declaration of war for Perl? And that announced on April first, no less. Great, now nobody will actually believe it. Good timing, Yanick, well done. ==b ^.^ d== Joy, `/anick -- Yanick Champoux Senior Perl Developer Pythian - Love your data champ...@pythian.com Tel: +1 613 565 8696 x 274 www.pythian.com -- --
Re: Moving to git - (Fwd) svn.perl.org shutdown
On 13-03-31 03:28 AM, Tim Bunce wrote: Any driver authors using svn.perl.org have presumably also got an email. I didn't yet, but it's okay: DBD-Oracle has been running with a dual svn / git repo for some time, now. As long as I remember to do a 'git svn fetch' on April 26th, all should be well. :-) Thanks for the heads up! `/anick
Re: Moving to git - (Fwd) svn.perl.org shutdown
On 13-03-31 01:32 PM, Tim Bunce wrote: I didn't yet, but it's okay: DBD-Oracle has been running with a dual svn / git repo for some time, now. As long as I remember to do a 'git svn fetch' on April 26th, all should be well.:-) Grand. Thanks Yanick. Pleasure is all mine. :-) And while we are talking of repos and DBD::Oracle, Pythian serendipitously created a GitHub account a few days ago (https://github.com/pythian), so I would expect that the main repo would eventually migrate there. When/if that happens, I'll make sure to propagate the news in all pertinent mailing lists. Joy, `/anick
Re: Moving DBI to github - and the perl5-dbi organization
On 13-03-31 02:02 PM, Tim Bunce wrote: I've created a perl5-dbi Organization on github. ... or DBD::Oracle's main repo could be moved there, which make even more sense. :-) I'm thinking that driver authors might like to become team admins within the perl5-dbi organization to foster the creation of teams of contributors for their drivers. Sure. I never say no to more power. ;-) Joy, `/anick
dev release DBD::Oracle 1.57_00 is on its way to CPAN
DBD::Oracle version 1.57_00 is on its way to CPAN. This release is small, but should make some Win32 users happy. The changelog is pasted below. As usual, the dev release will be promoted to general use in two weeks, assuming no problem is found. Enjoy, `/anick 1.57_00 2013-02-07 [BUG FIXES] - fix RT46628 - bind_param_inout ORA_RSET causes MSWin32 access violation and RT82663 - Errors if a returned SYS_REFCURSOR is not opened (Martin J. Evans) If a procedure/function returns a SYS_REFCURSOR which was never opened DBD::Oracle magics a DBI statement handle into existence and attempts to describe it (which fails). This change examines a returned SYS_REFCURSOR and if it it is initialised but not executed does not create a DBI statement handle and returns undef instead. So now if you have a procedure/function which returns a SYS_REFCURSOR and never open it you'll get undef back instead of a useless statement handle. Extended 50cursor.t test to check the above fix. [DOCUMENTATION] - Update Lion instructions for 64-bit Instant Client. (GH#37, patch by theory) -- --
DBD::Oracle v1.54 on its way to CPAN
Hi all, DBD::Oracle v1.54 is on its way to CPAN. In this iteration, no new feature, but a large amount of bug fixes. (see full changelog below) As usual, a big thank to the peeps who actually reported the bugs and did the work: Pierre-Alain Blanc, Alexandr Ciornii, Joe Crotty, Rob Davies, Dave Mitchell, and John Scoles, with a special shout-out to Steffen Goeldner and Martin J. Evans, who are indisputably patching kings. Joy, `/anick 1.54 2013-01-03 [BUG FIXES] - Fix RT69350 - 31lob.t was using $lob after destroying its parent $sth (Rob Davies) - Fix memory leak in execute_array (John Scoles, Pierre-Alain Blanc) - Fix RT80349 - The error message in execute_for_fetch when a row fails can contain the wrong error count. Thanks to Steffen Goeldner for RT and patch. - Fix RT80375 - no exception when execute_for_fetch fails and ArrayTupleStatus is not specified. Also the tuple count calculation resulted in an undefined warning. Thanks to Steffen Goeldner for RT and patch. - Fix RT80487. Skip XMLType tests if Oracle less than V9. Thanks to Steffen Goeldner for RT and patch. - Fix RT80486 for 31lob_extended.t. In old old Oracle8, SYS_REFCURSOR is not defined. Instead of CREATE/DROP PROCEDURE, use anonymous block. Thanks to Steffen Goeldner for RT and patch. - Fix bug in 39attr.t which could fail if using an Oracle Client 11 but not = 11.2 (Martin J. Evans) - ora_server_version was not documented. - Fix RT80566. 70meta.t test fails with Oracle 8 because ALL_TAB_COLUMNS.CHAR_LENGTH is new in Oracle 9. Use DATA_LENGTH instead on pre-9 versions. Thanks to Steffen Goeldner for RT and patch. - Fix RT80704. 51scroll.t test checks scrollable cursors but assumes all Oracles support them (only 9 and above). Thanks to Steffen Goeldner for RT and patch. - Fix RT81067. 58object.t has some subtype tests and subtypes were introduced in Oracle 9. Skip if Oracle 9. Thanks to Steffen Goeldner for RT and patch. - Fix RT81317. 34pres_lobs.t uses the Data Interface for Persistent LOBs which is new in Oracle 9. Skip if Oracle 9. Thanks to Steffen Goeldner for RT and patch. [MISCELLANEOUS] - The original 26exe_array test was replaced some time ago with a copy of the one from DBD::ODBC. Since then I've fixed issues in the DBD::ODBC one and added more tests (like tests for some RTs above). To make keeping them in synch easier I've modularised the tests. Hence new ExecuteArray.pm. (Martin J. Evans) - simple code clean up, replacing 3 uses of safemalloc with Newz (John Scoles) - Add DBI as a configure prereq for the META* files (thanks to Joe Crotty) - New FAQ entry on Solaris and setting linker library path (Martin J. Evans) - Removed ineffective commit in 34pres_lobs.t (Martin J. Evans) - Remove dead README link in Win32 documentation. (pointed out by Alexandr Ciornii, RT#82040) - Changed any use of if SvUPGRADE to remove the if test as per email from Dave Mitchell and posting at http://www.xray.mpe.mpg.de/mailing-lists/perl5-porters/2012-12/msg00424.html (Martin J. Evans) -- Yanick Champoux, Senior Perl Developer The Pythian Group - love your data http://www.pythian.com -- --
DBD::oracle v1.52 is on CPAN
Hi everyone, Nothing bad or funky was reported for v1.51_00, so it was promoted to the all new and shiny v1.52. I'm pasting the changelog below for convenience, but this release is basically Martin Evans heroically making TAF work, with some additional awesomeness sprinkled by Merijn, Douglas and David. All of you guys rock. :-) Enjoy! `/anick 1.52 [BUG FIXES] - fix serious memory corruption in TAF support (Martin J. Evans) - fix finding client in situation where client and server both installed but different architectures (patch by H.Merijn Brand) - fix memory leak in TAF handling - the TAF function was leaked (Martin J. Evans) - fix issue with taf_function being set to a scalar which goes out of scope before the callback is made (Martin J. Evans) - fix RT46739 if a connection breaks the environment handle is not thrown away (Martin J. Evans) - ora_driver_name was not defaulted to the correct DBD::Oracle version (Martin J. Evans) - ora_driver_name, ora_client_info, ora_client_identifier, ora_action and ora_oci_success_warn were set twice (if specified) on connect as they were not deleted from the connect attributes once handled. Code now leaves the setting to the later STORE DBI calls (Martin J. Evans) - fixed some compiler warnings for %lf (Martin J. Evans) - fixed RT78700 - column_info reports wrong size for char semantic char type columns (Douglas Wilson). [CHANGE IN BEHAVIOUR] - ora_taf and ora_taf_sleep were redundant and have been removed. To enable/disable TAF simply set ora_taf_function and if you want to sleep do it in your callback (Martin J. Evans) - ora_taf_function can now be a code reference as well as a string (Martin J. Evans) [ENHANCEMENTS] - the ora_can_taf method was virtually useless since you can only call it after connecting and to enable TAF you had to do it in the connect call. Now you can enable and disable TAF at any time by simply setting or clearing the ora_taf_function (see RT78811) (Martin J. Evans) - the ora_taf_function is now passed a third argument of the connection handle (Martin J. Evans) - RT78987 - removed Oraperl.pm and oraperl.ph; these files will be available in a separate distribution named Oraperl (David Perry) [MISCELLANEOUS] - hide dr, db and st packages from PAUSE (Martin J. Evans) - added a few more simple TAF tests (Martin J. Evans) -- Yanick Champoux, Senior Perl Developer The Pythian Group - love your data http://www.pythian.com -- --
DBD::Oracle v1.51_00 is on CPAN
Hi everyone, DBD::Oracle v1.51_00 is on CPAN, on the ready for your testing pleasure. The full changelog is below, but the main thing for this release is TAF. The previous state of TAF in DBD::Oracle was... suboptimal (or, if you prefer, balefully b0rked). Thanks to Martin, it got better. So, anyway, as usual, I'll let the new candidate release simmer for at least 2 weeks, and then -- if no issue is found -- promote it for general consumption. Cheers, `/anick 1.51_00 [BUG FIXES] - fix serious memory corruption in TAF support (Martin J. Evans) - fix finding client in situation where client and server both installed but different architectures (patch by H.Merijn Brand) - fix memory leak in TAF handling - the TAF function was leaked (Martin J. Evans) - fix issue with taf_function being set to a scalar which goes out of scope before the callback is made (Martin J. Evans) - fix RT46739 if a connection breaks the environment handle is not thrown away (Martin J. Evans) - ora_driver_name was not defaulted to the correct DBD::Oracle version (Martin J. Evans) - ora_driver_name, ora_client_info, ora_client_identifier, ora_action and ora_oci_success_warn were set twice (if specified) on connect as they were not deleted from the connect attributes once handled. Code now leaves the setting to the later STORE DBI calls (Martin J. Evans) - fixed some compiler warnings for %lf (Martin J. Evans) - fixed RT78700 - column_info reports wrong size for char semantic char type columns (Douglas Wilson). [CHANGE IN BEHAVIOUR] - ora_taf and ora_taf_sleep were redundant and have been removed. To enable/disable TAF simply set ora_taf_function and if you want to sleep do it in your callback (Martin J. Evans) - ora_taf_function can now be a code reference as well as a string (Martin J. Evans) [ENHANCEMENTS] - the ora_can_taf method was virtually useless since you can only call it after connecting and to enable TAF you had to do it in the connect call. Now you can enable and disable TAF at any time by simply setting or clearing the ora_taf_function (see RT78811) (Martin J. Evans) - the ora_taf_function is now passed a third argument of the connection handle (Martin J. Evans) - RT78987 - removed Oraperl.pm and oraperl.ph; these files will be available in a separate distribution named Oraperl (David Perry) [MISCELLANEOUS] - hide dr, db and st packages from PAUSE (Martin J. Evans) - added a few more simple TAF tests (Martin J. Evans) -- Yanick Champoux, Senior Perl Developer The Pythian Group - love your data http://www.pythian.com -- -- Attending Oracle OpenWorld? Be sure to watch out for the Pythian team and to catch one of our many speaking sessions bit.ly/OOW12sessions
Re: DBD::Oracle v1.45_00 on its way to CPAN
On 12-06-22 12:15 PM, Jared Still wrote: Wow! Awesome effort by Martin. No kidding. He's a machine. Even possibly the answer to that age-old question: what would be the result of downloading an OCI API to a T-800 memory dataset. Pure relentless awesomeness, that's what results. :-) Joy, `/anick
DBD::Oracle v1.45_00 on its way to CPAN
After a little bout of hibernation, a new trial version of DBD::Oracle has been churned out. This release is mostly about Martin J. Evans going all ninjawesome on minor bug fixes, as well as paving the way for an upcoming refactoring / speed boost of /ora_verbose/. As usual, the new version will be soaked for at least 2 weeks before it will turn into its fit-for-general-consumption v1.46 incarnation. Testers, please give this baby a whirl. And, also as usual, the full changelog follows for the curious minded. |1.45_00 2012-06-21| |||[CHANGE IN BEHAVIOUR]| |||- In future versions of DBD::Oracle ora_verbose will be changed| |||so that it is simply a switch to turn DBI's DBD tracing on or off.| |||A true value will turn it on and a false value will turn it off.| |||DBI's DBD tracing was not available when ora_verbose was created| |||and ora_verbose adds an additional test to every trace test.| |||[BUG FIXES]| |||- Fixed RT76695 - offset passed to ora_fetch_scroll should not affect| |||normal fetches (Martin J. Evans)| |||- Fixed RT76410 - fetch after fetch absolute always returns| |||the same row (Martin J. Evans);| |||- Fixed RT75721 - does not build with Oracle 9.2 (Martin J. Evans)| |||- Fixed RT71343 - Oracle 9i does not have OCI_ATTR_TAF_ENABLED| |||or OCI_ATTR_RESERVED_15/16 so cannot build (Martin J. Evans)| |||- skip 24implicit_utf8.t if chr set is not UTF-8 (Martin J. Evans)| |||- Fixed RT76268 - ora_taf_sleep was documented as taf_sleep by| |||accident. There was no way to stop the TAF reconnect attempts.| |||If you want to try another connect attempt in your taf handler you| |||now need to return OCI_FO_RETRY from it. (Martin J. Evans)| |||[MISCELLANEOUS]| |||- minor change to confusing debug output for input parameters| |||(Martin J. Evans)| |||- RT72989 - add note to trouble shooting guide re this RT and| |||Module::Runtime (Martin J. Evans)| Enjoy, `/anick -- Yanick Champoux, Senior Perl Developer The Pythian Group - love your data http://www.pythian.com -- -- Try Pythian managed services risk-free for operational support, upgrades/migrations, special projects or increased performance.
DBD::Oracle trial version v1.43_00 in its way to CPAN
Hi all, A new trial version of DBD::Oracle is on its way to CPAN. The complete change delta is reported below, but the pièce de résistance of this release is Martin's hunting down of all uses of DBIS. While those changes are boosting DBD::Oracle's performance (mostly for threaded perls), which is awesome, they are also extensives. We therefore need as much exposure and testing on as many Oracle platforms as we can. If you have time, please consider giving this release a whirl. Pretty please. :-) Enjoy! `/anick 1.43_00 2012-03-30 [BUG FIXES] - Applied patch from Rafael Kitover (Caelum) to column_info to handle DEFAULT columns greater in length than the DBI default of 80. The DEFAULT column is a long and it is a PITA to have to set LongReadLen which you can only do on a connection handle in DBD::Oracle. The default maximum size is now 1Mb; above that you will still have to set LongReadLen (Martin J. Evans) - Fixed 70meta and rt74753-utf8-encoded to not die if you cannot connect to Oracle or you cannot install from CPAN if you have not set up a valid Oracle connection. - Fixed 75163. Bfile lobs were not being opened before fetching if ora_auto_lobs was disabled (Martin J. Evans). Note: this has a minor impact on non bfile lobs when ora_auto_lobs is not in force as an additional call to OCILobFileIsOpen will be made. - Removed all DBIS usage fixing and speeding up threaded Perls (Martin J. Evans). - Minor fix to avoid use of uninitialised variable in 31lob.t (Martin J. Evans) [DOCUMENTATION] - clarification of when StrictlyTyped/DiscardString can be used and LongReadLen (Martin J. Evans) - Documented the 3rd type of placeholder and rewrote the existing pod for placeholders (Martin J. Evans). -- Yanick Champoux, Senior Perl Developer The Pythian Group - love your data http://www.pythian.com -- -- Pythian proud winner of Oracle North America Titan Award for Exadata Solution...watch the video on pythian.com
Re: DBD::Pg, DBD::Oracle and others are slow with threads due to DBIS
On 12-03-16 10:18 AM, Martin J. Evans wrote: Last night I finished changing DBD::Oracle to eradicate all DBIS usage. Holy schmollee, you're a beast. I've synced the Git repo with your work (branch master with the raw goodness, branch DBIS-less for a version that can be directly be installed from the checkout). Joy, `/anick
Re: DBD::Pg, DBD::Oracle and others are slow with threads due to DBIS
On 03/14/12 07:37, Martin J. Evans wrote: I'll try and find time to sort Oracle out unless Yanick steps in. I'll see if I can give it a go, but as of now that's more a pledge of goodwill than decent skills. The deep guts of DBI are still very murky to me. But I'll do my best. :-) Joy, `/anick
Re: DBD-Oracle 1.40
On 12-03-11 11:48 AM, H.Merijn Brand wrote: On Sun, 11 Mar 2012 11:27:44 -0400, Yanick Champoux yan...@babyl.dyndns.org wrote: On 12-03-11 06:01 AM, H.Merijn Brand wrote: t/rt74753-utf8-encoded.t (Wstat: 512 Tests: 3 Failed: 2) Failed tests: 2-3 Non-zero exit status: 2 Files=1, Tests=3, 1 wallclock secs ( 0.02 usr 0.00 sys + 0.05 cusr 0.01 csys = 0.08 CPU) That's not good. I'll issue a patch Monday, and try to narrow down on which versions of Oracle the fix for rt-74753 isn't working. Note these: t/23wide_db.t . skipped: Database character set is not Unicode t/23wide_db_8bit.t skipped: Database character set is not Unicode t/23wide_db_al32utf8.t skipped: Database character set is not Unicode I have a new trial version changing the test so that it doesn't run if the db character set is not unicode. I'm at home today, so I can't run my battery of tests before releasing, but if anyone feel like giving it a whirl, the new version is at svn repo: http://svn.perl.org/modules/dbd-oracle/branches/DBD-Oracle-1.41_00 git repo: https://github.com/yanick/DBD-Oracle/tree/cand-v1.41 FWIW, DBD::Oracle-1.27 is the last to work on Oracle-9.2.0.8 All beyond 1.27 fail :-( I'll open a ticket on RT about that one. Joy, `/anick
Re: DBD-Oracle 1.40
On 12-03-11 06:01 AM, H.Merijn Brand wrote: t/rt74753-utf8-encoded.t (Wstat: 512 Tests: 3 Failed: 2) Failed tests: 2-3 Non-zero exit status: 2 Files=1, Tests=3, 1 wallclock secs ( 0.02 usr 0.00 sys + 0.05 cusr 0.01 csys = 0.08 CPU) That's not good. I'll issue a patch Monday, and try to narrow down on which versions of Oracle the fix for rt-74753 isn't working. Joy, `/anick
Re: DBD::Oracle v1.39_00 is out
On 02/27/12 02:02, H.Merijn Brand wrote: On Fri, 24 Feb 2012 16:50:37 -0500, Yanick Champoux champ...@pythian.com wrote: [OTHERS] - change the shebang line of examples to the more modern '/usr/bin/env perl' Personally I really really hate this change Fair enough. This being said, I have to point out that the change is only on the scripts in the 'examples/' directory, which are not installed as part of the distro. Perl has been configured to use $Config{startperl}. Use it! I'm not sure I understand how you would like me to use it. I know that, if we ask nicely, MakeMaker and Module::Build will change the shebang of scripts that are to be installed to the local location of perl, but typically things that are not to be installed are left alone. Do you propose that the example directory get munged as part of the 'perl Makefile.PL' stage? Or do you know of a static shebang that goes straight for $Config{startperl} ? Joy, `/anick -- Yanick Champoux, Senior Perl Developer The Pythian Group - love your data http://www.pythian.com -- -- Pythian proud winner of Oracle North America Titan Award for Exadata Solution...watch the video on pythian.com
Re: DBD::Oracle v1.39_00 is out
A new DBD::Oracle trial version is out and on its way to CPAN. It's a maintenance release with fairly minor bug fixes (full changelog below). As usual, the trial version will be soaked for 2 weeks and, pending issues, will be promoted to v1.40 for general consumption. Joy, `/anick 1.39_00 2012-02-24 [BUG FIXES] - TAF supports now conditional to presence of OCI_ATTR_TAF_ENABLED [RT73798] - detect broken Win32::TieRegistry (patch by Rafael Kitover (Caelum)) [RT74544] - PL/SQL out values were not utf8 encoded [RT74753] (Steve Baldwin + Martin J. Evans) [DOCUMENTATION] - Mention the release of Oracle Instant Client 64 bit which does not work on Lion. (Martin J. Evans) - fix DBD::Oracle::GetInfo blurb (patch by Julián Moreno Patiño) [rt74000] - fix typos. (patch by Julián Moreno Patiño) [rt73999] - add troubleshoot doc and diag for error with bequeather. [rt75263] [OTHERS] - change the shebang line of examples to the more modern '/usr/bin/env perl' [RT74001] -- -- Pythian proud winner of Oracle North America Titan Award for Exadata Solution...watch the video on pythian.com
Re: DBD::Oracle
On 02/10/12 09:30, Charles Jardine wrote: t/10general.t Dubious, test returned 2 (wstat 512, 0x200) This symptom indicates that the system built-in function is not working. Try perl -e 'print system(exit 1;), \n' Hmmm... The test that is failing is is system(exit 1;), 18, 'system exit 1 should return 256'; which should be okay, but I'm suddenly thinking: on some shells 'exit' might not do what we would expect. Indeed, I just tried: $ perl -E'say system exit 1' -1 And yet the tests usually pass on my machine. I have to look at that in more details... Joy, `/anick
Re: DBD::Oracle
On 02/10/12 09:56, Yanick Champoux wrote: which should be okay, but I'm suddenly thinking: on some shells 'exit' might not do what we would expect. Indeed, I just tried: $ perl -E'say system exit 1' -1 And just to keep things interesting, I've noticed that I forgot the ending semi-colon that is in the test. But surely that won't-- $ perl -E'say system exit 1; say system exit 1;' -1 256 --make a difference... Uuuh, okay, I need to brush up my shell syntax skills. And should probably look into making that test slightly less shell-dependent. Joy, `/anick
Re: Removal of Oraperl from DBD::Oracle?
On 12-01-10 03:25 AM, Tim Bunce wrote: I wouldn't mention a specific timeframe. Just say that Oraperl was deprecated years ago, will be removed in a near-future release, and any scripts using it should be rewritten to use DBI calls. Then forget about it. There's no reason to actually remove it soon and the longer it's not removed the more likely the message is to reach its intended audience (who tend to upgrade rarely). I can do that, no problem. The only thing I'm afraid of, is that by not giving a specific timeframe, human psychology will do what human psychology does and people will tend to disregard the deprecation notice. :-) But you are right, there is no rush to actually remove the module itself, and perhaps the warning alone will do its job of nudging most of the last stragglers toward DBI. Joy, `/anick
Re: Removal of Oraperl from DBD::Oracle?
On 12-01-10 09:47 PM, Darren Duncan wrote: After the first release of Oraperl in a separate distro, as long as you don't change something in DBD::Oracle that breaks the API that Oraperl depends on, you never have to release another version of Oraperl itself again. I thought about that option as well, but I don't think it buys us anything. For as long as DBD::Oracle doesn't break Oraperl, to have the latter bundled with the former doesn't require any additional work, and doesn't hurt. And when DBD::Oracle will finally break Oraperl, having Oraperl in its own distribution means that for it to work you'll have to manually install a non-latest version of Oracle for it to work -- if it's still bundled with DBD::Oracle, 'cpanm Oraperl' will do the right thing and fetch the last version of DBD::Oracle that includes, and supports Oraperl. Joy, `/anick
Re: Removal of Oraperl from DBD::Oracle?
On 01/04/12 14:33, Jared Still wrote: I would think being forced to quit using Oraperl would be a good thing? :) I tend to agree. But I had to ask before I pull that rug off from everyone's feet, just in case someone is still actually standing on it. :-) But seriously, when was the last time anyone of heard of someone using Oraperl, or asking questions about it? I googled a little bit, and from what I can see, people were already told that Oraperl is old and deprecated in... 2001. Didn't get any better after that. :-) I have some really old (good) stuff that uses Oraperl. Should I ever want to use it again I would most definitely convert to DBD::Oracle. At the time I wrote those scripts (1995!) , DBD::Oracle was new and scary. :) Well, it's still scary aplenty, but I daresay that by now, we have the 'new' mitigated. :-) Joy, `/anick -- Pythian proud winner of Oracle North America Titan Award for Exadata Solution...watch the video on pythian.com
Removal of Oraperl from DBD::Oracle?
Hi all, For a long time now, the documentation of DBD::Oracle had been warning that Oraperl is deprecated. A few releases back, I ratcheted up the warning and mentioned that Oraperl would be dropped from the DBD::Oracle distro in the new year, after v1.38. And now that the new year and v1.38 are upon us, I'm thinking on acting on the promise. But before I do, wisdom begs me to consult the dbi hivemind. Sooo... Can anybody know of anyone/anything who would be impacted (negatively) by the removal of said Oraperl? Joy, `/anick
DBD::Oracle v1.37_00 is out
Hi (and happy new year!) everyone, The trial version of DBD::Oracle v1.37_00 is on CPAN. Changelog details below. As usual, unless problems surface, the version will be promoted for general consumption in two week(ish). Enjoy! `/anick |1.37_00 2011-12-30| |||[ENHANCEMENTS]| |||-| |added SYSASM session mode. [RT651211] (patch from | |||Anthony DeRobertis, reported by Julián Moreno Patiño)| |||[BUG FIXES]| |||-| |applied patch from Charles Jardine avoiding undefined values| |||warnings in ora_server_version when the database is not open| |||[RT72623]| |(Martin J. Evans)| |||-| |TNS_ADMIN was ignored [RT73456]| |||[DOCUMENTATION]| |||-| |Document possible problem with| |||ora_connect_with_default_signals and connect_cached| |||[RT72716]| |(Martin J. Evans)| |||-| |Fix documentation for 'ora_fetch_scroll()'| -- Pythian proud winner of Oracle North America Titan Award for Exadata Solution...watch the video on pythian.com
DBD::Oracle v1.32 and v1.33_00 on their way to CPAN
Hi all, As no issue has been found with DBD::Oracle v1.31_00, it has been promoted to v1.32 and is on its way to CPAN. Also, the next trial version v1.33_00 is also to appear in a few instants. The changelog is small and deal mostly with doc changes: Changes in DBD-Oracle 1.33_00 (18-10-2011) [BUG FIXES] - COLUMN_SIZE of VARCHAR2 returns size in chars, not bytes. [RT#13865] (reported by Stefano and Laurent Dami) [DOCUMENTATION] - add mention of the github mirror of the subversion repository - add 'resources' info to META.yml - fixed broken link to Oracle DRCP doc in POD (John Scoles) As usual, if you are so inclined, please test and provide feedback. Unless issues are found, this load should be promoted for general consumption in 2 weeks. Joy, `/anick -- Pythian proud winner of Oracle North America Titan Award for Exadata Solution... Read more see us at OpenWorld bit.ly/pythianoow11
DBD::Oracle 1.31_00 has been released
Hi all, Just to say that the next dev release for DBD::Oracle is already on CPAN. This release mostly has documentation and Makefile.Pl changes, and doesn't bring anything major: Changes in DBD-Oracle 1.31_00 [ENHANCEMENTS] - Makefile.PL's options are now documented - move 'explain' to '/examples' directory [BUG FIXES] - support development release versions in GetInfo (Martin J. Evans) - don't gag diag() on the tests by default - SKIP condition in 10general.t was reversed (reported by Alois) [RT#46761] - Check for LD_LIBRARY_PATH_(32|64) as well for solaris [RT#46761] - convert a symbolically linked ORACLE_HOME to an absolute path (patch by H.Merijn Brand, applied by Martin J. Evans) [rt70785] [DOCUMENTATION] - announce that Oraperl will be removed from the dist by v1.38. - add Mac OS instructions for Lion (patch by David Wheeler) [rt71109] - fixed minor typo in POD (John Scoles) If you have the time, software and inclination, please give the dist a whirl, and let me know of any test failure (or any other funny behavior). If nothing bad is reported, the release will be promoted for general consumption in 2 weeks. Joy, `/anick
DBD::Oracle 1.30 released
Hi all, Just a quick word to say that DBD::Oracle 1.30 is on its way to CPAN mirrors as we speak. There are no real change from v1.29_1, the previous developer release. The changes since 1.28 are [DOCUMENTATION] - add warning about RT#69350 in documentation [ENHANCEMENTS] - added support for TAF callback - now trap OCIServerAttach errors - added installation notes for MAC Snow Leopard - added '/etc' to the search paths for tnsnames.ora - removed support for ProcC connections - added ora_db_shutdown and ora_db_startup private functions - added Test::Simple 0.90 to build_requires as we use note etc [BUG FIXES] - fixed bug in bind_col which was broken in 1.27 and stopped anyone using a string as a column number. - removed obsolete oparse_lang - fixed some compiler warnings in dbdimp.c and oci8.c - added missing OCIServerRelease to oci.def - fixed up the POD based on DBD::Pg - POD review rephrasing, fixing typos and spelling mistakes up to Placeholder Binding Attributes - rt 56824 - add META_MERGE mentioning DBI required version Enjoy, `/anick -- Yanick Champoux, Senior Perl Developer The Pythian Group - love your data http://www.pythian.com -- The best compliment you could give Pythian for our service is a referral.
ANNOUNCE: DBD::Oracle 1.29_1 now on CPAN
Hi everybody, I'm happy to announce that DBD::Oracle v1.29_1 is now on CPAN, eagerly awaiting to be downloaded and tested by fearless beta testers. (changelog given below) If you have an Oracle instance near by and some cycles to spare, please consider giving this new version a whirl. If everything goes well, this release should be promoted to a non-developer release in 2 weeks. Enjoy, `/anick == Changes in DBD-Oracle 1.29_1 [ENHANCEMENTS] - added support for TAF callback (John Scoles) - now trap OCIServerAttach errors (patch by Marc Fielding, applied by Martin J. Evans) [rt68958] - added installation notes for MAC Snow Leopard (Martin J. Evans) - added '/etc' to the search paths for tnsnames.ora (Martin J. Evans, Jay Senseman) [rt67942] - removed support for ProcC connections (John Scoles) - added ora_db_shutdown and ora_db_startup private functions (Steffen Goeldner) - added Test::Simple 0.90 to build_requires as we use note etc (Martin J. Evans) [BUG FIXES] - fixed bug in bind_col which was broken in 1.27 and stopped anyone using a string as a column number. E.g., '1' (Martin J. Evans, Alexander Foken) - removed obsolete oparse_lang (John Scoles) - fixed some compiler warnings in dbdimp.c and oci8.c (Martin J. Evans) - added missing OCIServerRelease to oci.def (Martin J. Evans) [rt68172] - fixed up the POD based on DBD::Pg (John Scoles) - POD review rephrasing, fixing typos and spelling mistakes up to Placeholder Binding Attributes (Martin J. Evans)
DBD::Oracle github repo and mailing list
Hi all, I don't think I broadcasted those particular small bits of news on this mailing list (if I did, sorry for the spam): * I've created a github copy of the DBD::Oracle repo on svn.perl.org at https://github.com/yanick/DBD-Oracle For now, the true mothership repo will stay the one on svn.perl.org, but hopefully having a git alternative will make submitting patches easier for the general population. * As we have a few new enthusiast potential contributors desiring to jump aboard the DBD::Oracle wagon, I've also created a dbd-oracle mailing list (https://groups.google.com/group/dbd-oracle). The goal being to continue to use this forum as the discussion platform for general stuff, but to move the maintainer minutia away so not as to general too much noise. Of course, everybody is more than welcome to fork the former, and subscribe to the latter. :-) Joy, `/anick
Re: new user question: Oracle RAC support
On 11-06-10 08:46 AM, Dave Barnes wrote: Is there a document/link anywhere that details what Oracle client attributes are supported and which are not for Oracle 11g and interacting with a RAC and using things like TAF, FAN, etc... Above and beyond the POD of DBD::Oracle, not yet. But I'll make a note and we'll try to have that soonishingly. Support for TAF, incidentally, is supposed to appear in the next release of DBD::Oracle, which should go beta in a week or two. So stay tuned! :-) Joy, `/anick