DBI->connect() fails, Proxy, Oracle
am 30.11.2005 16:50:07 von claude.bHi,
I am new to DBI, and that may explain my question.
Using DBI::Proxy, I am trying to connect remotely to an Oracle
database whose datasource looks like this:
'jdbc:oracle:thin:@127.0.0.1:1521:abc'
I tried passing a string to the call DBI->connect($ds, ..):
$ds=DBI:Proxy:hostname=host.com;port=1521;dsn=
Now that call always fails for a reason that I don't understand, with
the following error(s):
---- clip --------------------------------------
Argument " " isn't numeric in repeat (x) at
/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi/DBD /Proxy.pm line 63 (#1)
(W numeric) The indicated string was fed as an argument to an operator
that expected a numeric value instead. If you're fortunate the message
will identify which operator was so unfortunate.
Uncaught exception from user code:
DBI connect('hostname=host.com;port=1521;dsn=DBI:jdbc:oracle:thi n:@127.0.0.1:1521:isc','batman',...) failed: Cannot log in to DBI::ProxyServer: Unexpected EOF from server at /usr/lib/perl5/vendor_perl/5.8.0/RPC/PlClient.pm line 79.
at ./test0.pl line 39
DBI::connect('DBI','DBI:Proxy:hostname=host.com;port=1521;ds n=DBI:jdbc...','batman','secret','HASH(0x82d7e38)') called at ./test0.pl line 39
---- clip --------------------------------------
The first error (warning?) points to the following line:
my ($err,$state) =
($errmsg =~ s/ \[err=(.*?),state=(.*?)\]//) ? ($1,$2) : (1,5 x ' ');
Can I ignore this error?
Am I using the wrong driver (DBI::Proxy), should I installed another
driver?
Thanks for your time!
--
Claude