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/
