RE: Test t/24implicit_utf8.t fails when compiling DBD-Oracle-1.17
First of all, appreciate your prompt
response.
Perl: 5.8.8DBI:
1.5.1DBD::Oracle: 1.17OS:Solaris 10
Oracle server:9.2.0.5Oracle client:9.2.0.5Oracle database charset:WE8ISO8850P1Oracle nchar charset:AL32UTF16NLS_LANG env var:AMERICAN_AMERICA.WE8ISO8850P1
While not exactly a workaround, I am planning
to use DBD 1.15 instead of DBD 1.17 with the rest of the configuration
unchanged.
Regards
==
Shiva Subramaniam
Systems Architect/Team Leader, ARBOR-XACCT
(Unix DBA
Teams)
:email [EMAIL PROTECTED])Mobile 0412 405
690
"All appears to change when we change " -
Henry Amiel
From: John Scoles [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 19 July 2006 1:07 AMTo: Shiva
Subramaniam; dbi-users@perl.orgSubject: Re: Test t/24implicit_utf8.t
fails when compiling DBD-Oracle-1.17
Yes we have seen that one before there is an
open bug report for it here
http://rt.cpan.org/Public/Bug/Display.html?id=18012
can you fill in the rest of this table for
me
Perl: 5.8.8DBI: 1.5.1DBD::Oracle:
1.17OS: ?Oracle server: ?Oracle client: ?Oracle database
charset: ?Oracle nchar charset: ?NLS_LANG env var: ?
so I can compare it to other bugs people are
reporting.
As well you will find a work around for this bug
on the error report.
Most likely a fix for this will not get in the
next release as I am having some problem recreating it locally and then
tracking it down as it is deep within the code. I suspect it may be an Oracle
bug but I cant' prove that yet either.
CheersJohn ScolesMaintainer
Oracle:DBD
- Original Message -
From:
Shiva Subramaniam
To: dbi-users@perl.org
Sent: Tuesday, July 18, 2006 4:25
AM
Subject: Test t/24implicit_utf8.t fails
when compiling DBD-Oracle-1.17
I am getting the following error when I am
trying to make test. The environment is Solaris 10 using PERL 5.8.8, DBI 1.51
and DBD 1.17.
t/24implicit_utf8...NOK 33# Failed
test 'byte_string test of row 4: column: nch (uft8) smiley
face'# in t/nchar_test_lib.pl at line
341.# got:
'38|58'# expected:
'226|152|186'
# Failed test 'nice_string test of row 4:
column: nch (uft8) smiley face'# in t/nchar_test_lib.pl
at line 344.t/24implicit_utf8...NOK
34# got:
':'# expected:
'\x{263A}'# row 4: DUMP(nch) = Typ=1 Len=4:
0,38,0,58
t/24implicit_utf8...NOK 70# Failed
test 'byte_string test of row 4: column: nch (uft8) smiley
face'# in t/nchar_test_lib.pl at line
341.# got:
'38|58'# expected:
'226|152|186'
# Failed test 'nice_string test of row 4:
column: nch (uft8) smiley face'# in t/nchar_test_lib.pl
at line 344.t/24implicit_utf8...NOK
71# got:
':'# expected:
'\x{263A}'# row 4: DUMP(nch) = Typ=1 Len=4:
0,38,0,58# Looks like you failed 4 tests of
74.t/24implicit_utf8...dubious
Test returned status 4 (wstat 1024, 0x400)DIED. FAILED tests 33-34,
70-71 Failed 4/74 tests, 94.59%
okayt/25plsql...okt/30longok
122/470 skipped: various
reasonst/31lob.okt/40ph_type.ok 1/19
Placeholder behaviour for ora_type=1 (the default) varies with Oracle
version.Oracle 7 didn't strip trailing spaces, Oracle 8 did, until
9.2.xYour system doesn't. If that seems odd, let us
know.t/40ph_type.okt/50cursor..okt/55nested..okt/60reauth..okt/70metaokFailed
Test Stat Wstat Total
Fail Failed List of
Failed---t/24implicit_utf8.t
4 1024 74 4 5.41%
33-34 70-71
HAVE U ENCOUNTERED THE SAME
Regards
==
Shiva Subramaniam
Re: DBD-Oracle 1.17 gives install_driver(Oracle) failed
Can't load Oracle.dll is often a symptom for a missing OCIW32.DLL. Oracle.dll loads OCIW32.DLL at startup, if that fails, loading Oracle.DLL fails, hence the error message. OCIW32.DLL is provided by the Oracle client software, newer Versions of Oracle install this DLL only(?) when you choose to install the Oracle ODBC drivers. The directory containing OCIW32.DLL must be listed in the PATH environment variable. Unfortunately, some third party software comes with a very ancient version of OCIW32.DLL, often installed into the windows\system32 or windows\system directory. Rename or remove that DLL. Alexander On 18.07.2006 18:39, Rohit V Bhute wrote: I was using Perl 5.6.x (ActiveState Windows port) to connect to Oracle 9i. The modules used then were DBI 1.48 and DBD-Oracle 1.16. I have now upgraded to Perl 5.8.8 with DBI 1.50 and DBD-Oracle 1.17. The upgrade was necessitated by the WWW::Babelfish module. Now while I'm able to use Babelfish properly, my Perl scripts are not able to connect to the Oracle database. The message send to the browser is as follows: cut install_driver(Oracle) failed: Can't load 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:The specified module could not be found at C:/Perl/lib/DynaLoader.pm line 230. at (eval 19) line 3 Compilation failed in require at (eval 19) line 3. Perhaps a required shared library or dll isn't installed where expected at C:/Program Files/Apache Group/Apache2/cgi-bin/iLCLP/iLP_Lgn.pl line 270 /cut While this is a frequent problem as seen by Google results, solutions are rare. Any hints would be welcome. TIA. -- Alexander Foken mailto:[EMAIL PROTECTED] http://www.foken.de/alexander/
RE: DBI-installed_drivers() usage
Paul Griffin wrote:
I'm running Win XP with Perl 5.8.8.
If I try and run the following code :
use DBI;
my %drivers = DBI-installed_drivers();
foreach (keys( %drivers)) {
print $_ uses $drivers{$_}\n;
}
Nothing is returned. Yet if I use :
my @drivers = DBI-available_drivers();
I get a list of drivers that I can then access with :
@dataSources = DBI-data_sources($_);
Am I using DBI-installed_drivers() incorrectly?
DBI-installed_drivers returns only the drivers that are actually loaded
into the current process. Installed in this case means installed into
memory.
This code will load all the drivers (generally not a good thing) and
then list them with installed_drivers():
use DBI;
eval { DBI-install_driver($_) }
foreach DBI-available_drivers;
my %drivers = DBI-installed_drivers;
print $_: $drivers{$_}\n foreach sort keys %drivers;
Philip
Re: DBI-installed_drivers() usage
On Wed, Jul 19, 2006 at 09:24:53AM -0400, Garrett, Philip (MAN-Corporate) wrote:
Paul Griffin wrote:
I'm running Win XP with Perl 5.8.8.
If I try and run the following code :
use DBI;
my %drivers = DBI-installed_drivers();
foreach (keys( %drivers)) {
print $_ uses $drivers{$_}\n;
}
Nothing is returned. Yet if I use :
my @drivers = DBI-available_drivers();
I get a list of drivers that I can then access with :
@dataSources = DBI-data_sources($_);
Am I using DBI-installed_drivers() incorrectly?
DBI-installed_drivers returns only the drivers that are actually loaded
into the current process. Installed in this case means installed into
memory.
Ah. The docs weren't clear:
--- DBI.pm (revision 6618)
+++ DBI.pm (working copy)
@@ -2753,10 +2753,15 @@
%drivers = DBI-installed_drivers();
-Returns a list of driver name and driver handle pairs for all
-installed drivers. The driver name does not include the 'DBD::'
-prefix. Added in DBI 1.49.
+Returns a list of driver name and driver handle pairs for all drivers
+'installed' (loaded) into the current process. The driver name does not
+include the 'DBD::' prefix.
+To get a list of all drivers available in your perl instalation you can use
+L/available_drivers.
+
+Added in DBI 1.49.
+
=item Cinstalled_versions
DBI-installed_versions;
Tim.
RE: DBI-installed_drivers() usage
Tim,
Many thanks.
Regards Paul...
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 20, 2006 1:37 AM
To: Garrett, Philip (MAN-Corporate)
Cc: Paul Griffin; dbi-users@perl.org
Subject: Re: DBI-installed_drivers() usage
On Wed, Jul 19, 2006 at 09:24:53AM -0400, Garrett, Philip (MAN-Corporate)
wrote:
Paul Griffin wrote:
I'm running Win XP with Perl 5.8.8.
If I try and run the following code :
use DBI;
my %drivers = DBI-installed_drivers();
foreach (keys( %drivers)) {
print $_ uses $drivers{$_}\n;
}
Nothing is returned. Yet if I use :
my @drivers = DBI-available_drivers();
I get a list of drivers that I can then access with :
@dataSources = DBI-data_sources($_);
Am I using DBI-installed_drivers() incorrectly?
DBI-installed_drivers returns only the drivers that are actually loaded
into the current process. Installed in this case means installed into
memory.
Ah. The docs weren't clear:
--- DBI.pm (revision 6618)
+++ DBI.pm (working copy)
@@ -2753,10 +2753,15 @@
%drivers = DBI-installed_drivers();
-Returns a list of driver name and driver handle pairs for all
-installed drivers. The driver name does not include the 'DBD::'
-prefix. Added in DBI 1.49.
+Returns a list of driver name and driver handle pairs for all drivers
+'installed' (loaded) into the current process. The driver name does not
+include the 'DBD::' prefix.
+To get a list of all drivers available in your perl instalation you can use
+L/available_drivers.
+
+Added in DBI 1.49.
+
=item Cinstalled_versions
DBI-installed_versions;
Tim.
(Fwd) dbh handle in forked processes
- Forwarded message from Gene Zhang [EMAIL PROTECTED] - Date: Wed, 19 Jul 2006 14:47:53 -0700 From: Gene Zhang [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: dbh handle in forked processes DKIM-Signature: a=rsa-sha1; q=dns; l=618; t=1153345674; x=1154209674; c=relaxed/simple; s=sjdkim7002; h=Content-Type:From:Subject:Content-Transfer-Encoding:MIME-Version; d=cisco.com; [EMAIL PROTECTED]; z=From:Gene=20Zhang=20[EMAIL PROTECTED] |Subject:dbh=20handle=20in=20forked=20processes; X=v=3Dcisco.com=3B=20h=3DsD7xL/pn9TnBNQkdD6zrgC2K+Go=3D; b=CU2g8mhzDcuD8ZtwRrKWRFLn3lqy8vcCE+x7mbeK2yFOKJJi520TdFyxw9/xo8zDN9IYDhyD b19OICV/RztAqyyEZlJcK2ggl8ph4rHv/p7O/mSPfQ4YPR/ZnNV3+jeD; Authentication-Results: sj-dkim-7.cisco.com; [EMAIL PROTECTED]; dkim=pass ( sig from cisco.com verified; ); Hi mr. bunce, I've an issue with programming DBI and could not find a solution in either your DBI slideshow: http://search.cpan.org/src/TIMB/DBI_AdvancedTalk_2004/index.htm or your book Programming the Perl DBI; was hoping you could provide some guidance: I have a program that establishes a $dbh, but then forks multiple child processes, all of which use the same $dbh for queries and then terminate (the process). I'd like to use the same $dbh connection handle for each child process but as soon as one child exits, the handle is lost. Is the best solution to use connect_cached? -gene - End forwarded message -
(Fwd) dbd-oracle-1.16
- Forwarded message from Oscar Gomez [EMAIL PROTECTED] -
X-Pobox-Antispam: require_ptr/ returned deny: 200.13.228.34 has no PTR record,
or PTR and A records do not match
From: Oscar Gomez [EMAIL PROTECTED]
To: Tim Bunce [EMAIL PROTECTED]
Subject: dbd-oracle-1.16
Date: Wed, 19 Jul 2006 16:54:32 -0500
X-OriginatingIP: 10.0.1.50 (ogomez)
Tim
I have the following error when execute program in apache-cgi-oracle
[Wed Jul 19 17:08:18 2006] [error] [client 10.0.1.50] install_driver(Oracle)
failed: Can't load
'/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so'
for module DBD::Oracle: libclntsh.so.8.0: cannot open shared object file: No
such file or directory at
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230., referer:
http://10.0.0.6/cgi-bin/FGI?py6110
[Wed Jul 19 17:08:18 2006] [error] [client 10.0.1.50] at (eval 1) line 3,
referer: http://10.0.0.6/cgi-bin/FGI?py6110
[Wed Jul 19 17:08:18 2006] [error] [client 10.0.1.50] Compilation failed in
require at (eval 1) line 3., referer: http://10.0.0.6/cgi-bin/FGI?py6110
[Wed Jul 19 17:08:18 2006] [error] [client 10.0.1.50] Perhaps a required
shared library or dll isn't installed where expected, referer:
http://10.0.0.6/cgi-bin/FGI?py6110
perl version 5.8.5
lunux enterprise ES 4
DBD-Oracle-1.16
DBI-1.30
Thanks
--
Open WebMail Project (http://openwebmail.org)
-- Original Message ---
From: Tim Bunce [EMAIL PROTECTED]
To: Garrett, Philip (MAN-Corporate) [EMAIL PROTECTED]
Sent: Wed, 19 Jul 2006 08:37:27 -0700
Subject: Re: DBI-installed_drivers() usage
On Wed, Jul 19, 2006 at 09:24:53AM -0400, Garrett, Philip (MAN-
Corporate) wrote:
Paul Griffin wrote:
I'm running Win XP with Perl 5.8.8.
If I try and run the following code :
use DBI;
my %drivers = DBI-installed_drivers();
foreach (keys( %drivers)) {
print $_ uses $drivers{$_}\n;
}
Nothing is returned. Yet if I use :
my @drivers = DBI-available_drivers();
I get a list of drivers that I can then access with :
@dataSources = DBI-data_sources($_);
Am I using DBI-installed_drivers() incorrectly?
DBI-installed_drivers returns only the drivers that are actually loaded
into the current process. Installed in this case means installed into
memory.
Ah. The docs weren't clear:
--- DBI.pm (revision 6618)
+++ DBI.pm (working copy)
@@ -2753,10 +2753,15 @@
%drivers = DBI-installed_drivers();
-Returns a list of driver name and driver handle pairs for all
-installed drivers. The driver name does not include the 'DBD::'
-prefix. Added in DBI 1.49.
+Returns a list of driver name and driver handle pairs for all
drivers +'installed' (loaded) into the current process. The driver
name does not +include the 'DBD::' prefix.
+To get a list of all drivers available in your perl instalation you
can use +L/available_drivers. + +Added in DBI 1.49. + =item
Cinstalled_versions
DBI-installed_versions;
Tim.
--- End of Original Message ---
- End forwarded message -
