Re: ANNOUNCE: DBD::Oracle 1.22 Release Candidate 2

"H.Merijn Brand" <[email protected]>
Newsgroups gmane.comp.lang.perl.modules.dbi.sybase.devel
Message-ID <[email protected]> 
On Mon, 28 Jul 2008 12:06:47 -0400, John Scoles <[email protected]>
wrote:

> Ok hot off the press  RC2
> 
> I have fixed as much as I can of the different compiler warnings 
> hopefully this will be a little better.

Are you sure you didn't miss something?
I checked my patch, and you missed this one:

diff -pur DBD-Oracle-1.22-11591/Oracle.xs DBD-Oracle-1.22-11591a/Oracle.xs
--- DBD-Oracle-1.22-11591/Oracle.xs     2008-07-22 19:48:35 +0200
+++ DBD-Oracle-1.22-11591a/Oracle.xs    2008-07-28 14:50:59 +0200
@@ -249,7 +249,7 @@ ora_ping(dbh)
        CODE:
        /*simply does a call to OCIServerVersion which should make 1 round trip*/
     /*later I will replace this with the actual OCIPing command*/
-    /*This will work if the DB goes down, /*
+    /*This will work if the DB goes down, */
     /*If the listener goes down it is another case as the Listener is needed to establish the connection not maintain it*/
     /*so we should stay connected but we cannot get nay new connections*/
        {


Which still leaves me with this *error* in Oracle 9.2:

cc -c  -I/pro/oracle/v920/rdbms/public -I/pro/oracle/v920/rdbms/demo -I/pro/oracle/v920/rdbms/demo -I/pro/oracle/v920/rdbms/public -I/pro/oracle/v920/plsql/public -I/pro/oracle/v920/network/public -I/pro/lib/perl5/site_perl/5.8.7/IA64.ARCHREV_0-LP64/auto/DBI -Ae -DDEBUGGING +Z -z -D_HPUX_SOURCE -Wl,+vnocompatwarnings +DD64 -I/pro/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 +O2 +Onolimit   -DVERSION=\"1.22\" -DXS_VERSION=\"1.22\" +Z "-I/pro/lib/perl5/5.8.7/IA64.ARCHREV_0-LP64/CORE"  -DUTF8_SUPPORT -DNEW_OCI_INIT -DORA_OCI_VERSION=\"9.2.0.7\" oci8.c
"oci8.c", line 245: error #2020: identifier "OCI_MUTEX_TRY" is undefined
                case OCI_MUTEX_TRY:                return "MUTEX_TRY";    /* try and acquire mutex */
                     ^

Applying the first, commenting out the error-line, I get

CPAN/DBD-Oracle-1.22-RC2 138 > make test
PERL_DL_NONLAZY=1 /pro/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/01base................# Test loading DBI, DBD::Oracle and version
t/01base................ok
t/10general.............ok
t/12impdata.............ok
t/14threads.............skipped: this hpux perl 5.008007 not configured to support iThreads
t/15nls.................ok
t/20select..............ok
t/21nchar...............ok
t/22nchar_al32utf8......ok
t/22nchar_utf8..........ok
t/23wide_db.............skipped: Database character set is not Unicode
t/23wide_db_8bit........skipped: Database character set is not Unicode
t/23wide_db_al32utf8....skipped: Database character set is not Unicode
t/24implicit_utf8.......ok
t/25plsql...............ok
t/26exe_array...........ok
t/28array_bind..........ok
t/30long................ok
t/31lob.................ok
t/31lob_extended........ok
t/32xmltype.............3/4 Unsupported named object type for bind parameter at t/32xmltype.t line 71.
t/32xmltype............. Dubious, test returned 255 (wstat 65280, 0xff00)
 Failed 1/4 subtests
t/34pres_lobs...........ok
t/40ph_type.............1/19  Placeholder behaviour for ora_type=1 VARCHAR2 (the default) varies with Oracle version.
 Oracle 7 didn't strip trailing spaces, Oracle 8 did, until 9.2.x
 Your system doesn't. If that seems odd, let us know.
t/40ph_type.............ok
t/50cursor..............ok
t/51scroll..............ok
t/55nested..............ok
t/56embbeded............ok
t/60reauth..............skipped: ORACLE_USERID_2 not defined.
t/70meta................ok
t/80ora_charset.........1/14



t/80ora_charset......... Dubious, test returned 4 (wstat 1024, 0x400)
 Failed 4/14 subtests

Test Summary Report
-------------------
t/32xmltype         (Wstat: 65280 Tests: 3 Failed: 0)
  Non-zero exit status: 255
  Parse errors: Bad plan.  You planned 4 tests but ran 3.
t/80ora_charset     (Wstat: 1024 Tests: 14 Failed: 4)
  Failed tests:  9-10, 13-14
  Non-zero exit status: 4
Files=29, Tests=2061, 39 wallclock secs ( 0.79 usr  0.21 sys + 10.21 cusr  1.98 csys = 13.19 CPU)
Result: FAIL
Failed 2/29 test programs. 4/2061 subtests failed.

And for Oracle 10.2

CPAN/DBD-Oracle-1.22-RC2 104 > make test
PERL_DL_NONLAZY=1 /pro/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/01base................# Test loading DBI, DBD::Oracle and version
t/01base................ok
t/10general.............ok
t/12impdata.............ok
t/14threads.............skipped: this hpux perl 5.008007 not configured to support iThreads
t/15nls.................ok
t/20select..............ok
t/21nchar...............ok
t/22nchar_al32utf8......ok
t/22nchar_utf8..........ok
t/23wide_db.............skipped: Database character set is not Unicode
t/23wide_db_8bit........skipped: Database character set is not Unicode
t/23wide_db_al32utf8....skipped: Database character set is not Unicode
t/24implicit_utf8.......ok
t/25plsql...............ok
t/26exe_array...........ok
t/28array_bind..........ok
t/30long................ok
t/31lob.................ok
t/31lob_extended........ok
t/32xmltype.............3/4 Unsupported named object type for bind parameter at t/32xmltype.t line 71.
t/32xmltype............. Dubious, test returned 255 (wstat 65280, 0xff00)
 Failed 1/4 subtests
t/34pres_lobs...........ok
t/40ph_type.............1/19  Placeholder behaviour for ora_type=1 VARCHAR2 (the default) varies with Oracle version.
 Oracle 7 didn't strip trailing spaces, Oracle 8 did, until 9.2.x
 Your system doesn't. If that seems odd, let us know.
t/40ph_type.............ok
t/50cursor..............ok
t/51scroll..............ok
t/55nested..............ok
t/56embbeded............ok
t/60reauth..............skipped: ORACLE_USERID_2 not defined.
t/70meta................ok
t/80ora_charset.........1/14

t/80ora_charset.........11/14

t/80ora_charset......... Dubious, test returned 4 (wstat 1024, 0x400)
 Failed 4/14 subtests

Test Summary Report
-------------------
t/32xmltype         (Wstat: 65280 Tests: 3 Failed: 0)
  Non-zero exit status: 255
  Parse errors: Bad plan.  You planned 4 tests but ran 3.
t/80ora_charset     (Wstat: 1024 Tests: 14 Failed: 4)
  Failed tests:  9-10, 13-14
  Non-zero exit status: 4
Files=29, Tests=2061, 56 wallclock secs ( 0.79 usr  0.21 sys + 11.56 cusr  3.15 csys = 15.71 CPU)
Result: FAIL
Failed 2/29 test programs. 4/2061 subtests failed.

> You can find the RC here
> 
> 
> http://svn.perl.org/modules/dbd-oracle/trunk/DBD-Oracle-1.22-RC2.tar
> 
> Cheers and thanks for all the help guys
> 
> John Scoles
> 
> 


-- 
H.Merijn Brand          Amsterdam Perl Mongers  http://amsterdam.pm.org/
using & porting perl 5.6.2, 5.8.x, 5.10.x, 5.11.x on HP-UX 10.20, 11.00,
11.11, 11.23, and 11.31, SuSE 10.1, 10.2, and 10.3, AIX 5.2, and Cygwin.
http://mirrors.develooper.com/hpux/           http://www.test-smoke.org/
http://qa.perl.org      http://www.goldmark.org/jeff/stupid-disclaimers/
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.