Re: DBD::Oracle 1.25 and DRCP

Hey Cliff and John,

on Sept 22, 2010 you posted about issues you were having with getting
Oracle DRCP working using the ora_drcp_class. I am running into
similar issues and was wondering if you got DRCP to work and have it
share the connection. We are using oracle 11.2.0.2 and I have perl
v5.8.8, DBI 1.602 and DBD::Oracle 1.28.

here is my Tnsnames and basic connect string(DRCP is setup at the Listener):

$sid = (DESCRIPTION = (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = $host)(PORT = 1521)))
    (CONNECT_DATA = (SERVICE_NAME = $service)(SERVER=POOLED)))


    $self->{dbh} = DBI->connect("dbi:Oracle:$config->{sid}",
$config->{user}, $config->{pass},
                        { AutoCommit => 0, ora_drcp_class =>
"feedAutomation" } );

yet I am not seeing the $user.feedAutomation CClass and I see no
increase in Num_hits for any class that is there:

  1* select * from v$cpool_cc_stats

CCLASS_NAME
--------------------------------------------------------------------------------
NUM_REQUESTS   NUM_HITS NUM_MISSES  NUM_WAITS  WAIT_TIME CLIENT_REQ_TIMEOUTS
------------ ---------- ---------- ---------- ---------- -------------------
NUM_AUTHENTICATIONS
-------------------

$user.SHARED
     1346245          0    1346245      61582          0                   0
            1346245

Everything runs fine, it just doesn't share the connections and
increase Num_hits.

any thoughts?

thanks!
-Rob