Re: DBD::Oracle Release Candidate 1

On Wed, Feb 16, 2011 at 5:45 AM, Martin J. Evans
<[email protected]> wrote:
> On 11/02/11 18:43, John Scoles wrote:
>>
>> Here is the latest and greatest DBD::Oracle for your programming pleasure.
>>
>> You can find the Zip file here
>>
>> <a
>> href="http://www.pythian.com/news/wp-content/uploads/DBD-Oracle-1.28_RC_1.zip">DBD-Oracle-1.28-RC1.zip</A>
>>
>> This is a long overdue maintenance release that fixes a large number of
>> bug and issues which are detailed below in the Changes.
>>
>> Don't worry there are some new goodies in this release namely I have added
>> in 4 new
>> server side tracing/debugging attributes
>>
>> <strong>ora_driver_name</strong>
>> For 11g and later you can now set the name of the driver layer using OCI.
>> PERL, PERL5, ApachePerl so on. Names starting with "ORA" are reserved. You
>> can enter up to 8 characters. If none is enter then this will default to
>> DBDOxxxx where xxxx is the current version number. This value can be
>> retrieved on the server side using V$SESSION_CONNECT_INFO or
>> GV$SESSION_CONNECT_INFO
>>
>> <strong>ora_client_info</strong>
>> When passed in on the connection attributes it can specify any info you
>> want
>> onto the session up t0 64 bytes. This value can be
>> retrieved on the server side using V$SESSION view.
>>
>> <strong>ora_client_identifier</strong>
>> When passed in on the connection attributes it specifies the user
>> identifier
>> in the session handle. Most useful for web app as it can pass in the
>> session
>> user name which might be different than the connection user name. Can be
>> up
>> to 64 bytes long do not to include the password for security reasons and
>> the
>> first character of the identifier should not be ':'. This value can be
>> retrieved on the server side using V$SESSION view.
>>
>> <strong>ora_action</strong>
>> You can set this value to anything you want up to 32byes.This value can be
>> retrieved on the server side using V$SESSION view.
>>
>> We have also added in the connection attribute
>>
>> <strong>ora_connect_with_default_signals</strong>
>>
>> Whit this attribute you can localize the $SIG{} so this should solve the
>> problems with $SIG{} events that sometimes occur when using DBD::Oracle
>>
>>
>> Finally I would like to thank Martin Evans for volunteering to be another
>> co-maintainer of DBD::Oracle
>>
>>
>>
>> Cheers
>> John Scoles
>>
>>
>> Changes
>> Added connection attribute 'ora_connect_with_default_signals' that will
>> localize Perl's $SIG{INT} handler from Brian Phillips and T. Bunce
>> Fix in execute_array to stop possible endless loop when using a fetch sub
>> by Martin J. Evans
>> Adapted Martin J. Evans' ODBC 70execute_array.t into t/26exe_array.t by
>> John Scoles
>> Fix for execute_array to bring it up to spec. by Martin J. Evans and John
>> Scoles
>> Marked ProC, Oraperl.pm, ora_explain.pl, ora_context,
>> ora_use_proc_connection and ora_parse_lang as deprecated to be removed in
>> 1.29
>> Added in 4 new server side debug/trace attributes, ora_driver_name,
>> ora_client_info, ora_session_user and ora_action on the connection handle
>> from John Scoles
>> Cleaned up the pod a little by John Scoles
>> Fix for function name length, Some function names are over 31char long
>> which may cause problems for some OS/Compilers (VMS IA64 box.) from Jakob
>> Snoer
>> Fix for OCIPing in case where a 10 client tries to ping a &lt;10 DB from
>> Tim Oertel
>> Fix for DBD-Oracle stored proc with array bug where second call array size
>> is unchanged from Tim Oertel
>> Fix for rt.cpan.org Ticket #=63332: Spelling error in POD from jonasbn
>> Fix for rt.cpan.org Ticket #=62152: t/28array_bind.t and t/31lob.t may
>> call plan() twice and others do not fail on not connect from John Scoles
>> Fix for rt.cpan.org Ticket #=61511 ORA-00942 when inserting into a table
>> with a LOB column over a synonym on HP-UX from Kris Lemaire
>> Fix for rt.cpan.org Ticket #=42842 Test 31lob fails with 64-bit Instant
>> Client by John Scoles
>> Fix for support for objects on big endian platforms from Charles Jardine,
>> John R Pierce
>> Fix for rt.cpan.org Ticket #=61225 Windows install (Stawberry Perl) fails
>> on long path names from David Tulloh
>> Fix for rt.cpan.org Ticket #=rt64524 Memory Leak when Oracle connection
>> fails by Martin J. Evans
>> Added all the missing ora_drcp values to dbh private_attribute_info by
>> Martin J. Evans
>> Removed a load of attributes from sth private_attribute_info which are not
>> handle attributes but attributes to bind_param/prepare by Martin J. Evans
>> Fix for rt.cpan.org Ticket #=64244 - don&#039;t bail out, skip tests when
>> we cannot connect by Martin J. Evans and John Scoles
>> Added DBI to PREREQ_PM in Makefile.PL by Martin J. Evans
>> Added build_requires in Makefile.PL by Martin J. Evans
>> Added workaround for ExtUtils::MakeMaker problems by Martin J. Evans
>> Added LICENSE to Makefile.PL by Martin J. Evans
>>
>> Cheers John Scoles
>
> Thanks John.
>
> I haven't had a chance to play with this release candidate properly until
> today - sorry.
>
> On the platforms I've tested on so far (a few Linuxes) I am getting 100%
> test success.
> I will upgrade our test system to this RC later to see if it finds any
> problems.
>
> The only problems I've found so far:
>
> o the META.yml has not been generated properly (e.g., it is missing
> build_required, configure_requires etc
>
> o the version is still 1.27 instead of 1.28 - perhaps you intended that.
>

Yep at this stage it is just a simple dump to a zip.  Funny I did
create the Dir with make disdir I guess that does not generate the
META file.

I think any one we send up to CPAN gets deleted then recreated by the
CPAN process not 100% sure on that thouhg

> Martin
> --
> Martin J. Evans
> Easysoft Limited
> http://www.easysoft.com
>
--
The best compliment you could give Pythian for our service is a referral.