Try RMI::Client::ForkedPipes. Have the child process use one lib, and
the parent use the other. The child can give back with one DBI/DBD, and
the parent can produce handles from the other.
This is effectively the proxy solution, but you're just forking and
proxying to a private sub-process you created.
(Full disclosure: I wrote the RMI modules. If they break for you please
email me.)
Scott
jeff wrote:
You make an incorrect assumption :-(
Not trying to fool anyone or hide my identity, just hoping for further
input.
If you don't want to answer, then don't - but there is no need to be
nasty about it. You shouldn't view people so negatively.
As it turns out, the proxyserver is not a solution and database links
are not an option - Not allowed to create.
On Mon, 2009-12-14 at 20:54 +0100, Alexander Foken wrote:
OK, while you were busy creating new threads, I remembered that this
problem was discussed some time ago on this mailing list.
I was about to mail you a link to that discussion for further
information, like
<http://www.mail-archive.com/dbi-users@perl.org/msg32448.html>, but then
I saw that that therad was also started by you. We gave you several
pointers how to solve this problem, from using a specific oracle client
over proxy solutions to database links. We told you that it is
impossible to include two different Oracle client libraries into one
process. And we told you that you do not need to include two different
Oracle client libraries into one process.
Now, you ask basically the same question again, hoping that no body
remembered that thread startet two months ago. Well, I did, and it seems
you are resistant to consulting, both from Oracle experts and from
experienced DBI users.
So, why do you waste our time?
Alexander
On 14.12.2009 13:18, jeff wrote:
I need to connect simultaneously to both Oracle 8 and oracle 10 from the
same script using 'external' connection (ie, no username or password).
The Oracle libraries, from my experimentations, are not compatible for
external connections. Oracle 8 uses system ID and Oracle 10 uses wallet
and they do not overlap.
I need to stress that this is NOT an option. I have no say in this
regardless of how insecure it may sound.
Anyway, since Oracle DBD can only be built against 1 at a time , this
presents a problem. I have been trying to use DBI Proxy in a PAR
standalone for Oracle 8 connections and the usual setup for Oracle 10
connections with some limited success.
What would be ideal would be to have 2 different Oracle DBD connections
from within the same perl build. Any suggestions or ideas for potential
solutions out there ?
Thanks.
Jeff
