Re: DBD::Oracle Release Candidate 1

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.

Martin
-- 
Martin J. Evans
Easysoft Limited
http://www.easysoft.com