luben wrote:
Gee didn't know anyone else was even interested in DRCP. good to see
there is some interest
Just to let you know that branch is in the very Beta stages so expect a
few things to be missing
Hello,
I have noticed and installed DRCP_1.25 branch from DBD::Oracle
repository. It seems to work fine but it's missing some essential
functionality in order to make it usefull. So I have made local
modifications (some of them are not essential) and all seems to work
fine here.
What I have done:
1. essential
- added ora_pool_class connection attribute that sets
OCI_ATTR_CONNECTION_CLASS on the obtained connection. It is essential
because without setting this attribute the pooled sessions are not
shared between processes. From oracle documentation:
> If no connection class is specified, the OCISessionPool’s name is
implicitly used
> as the connection class by all the requests using that
OCISessionPool, resulting in
> sharing only within a session pool, becoming equivalent to a plain
client-side
> session pooling application.
Ok would like to see the code for that/
2.non-essential
- Added ora_pool_min, ora_pool_max, ora_pool_incr connections
attributes that are used to set corresponding values for
OCISessionPoolCreate.
- Set default values for the above parameters to follow default values
of DBMS_CONNECTION_POOL package (principle of least surprise)
I have those stubbed in for now as I was deliberately using small min
and max for testing and will check them in soon I most likely. Part of
the plan was to use the default values.
I have some questions:
1. Do you have suggestions for different names of attributes? I was
considering ora_drcp_class etc. but I am not sure what will be the best.
ora_drcp_conn_class would be better so as not to get it confused with
any other thing that might be a 'class' of some sort
2. If my work is interesting for the further development of
DBD::Oracle, whom I should send a patch?
Just post it here on this thread or on DBI-users just make sure it is
patched from the DRCP branch.
Finally, if this work is accepted I will add proper documentation for
the new attributes.
That would save me some trouble.
Now I have a little favour to ask of you. Seems I am getting a problem
with 31lob.t test 8 the sql "BEGIN ? := DBMS_LOB.GETLENGTH( ? );
END;"; does not return the correct length when used with DRCP
If you have half a moment and can take a look at that one that would be
great.
Cheers
John Scoles
Best regards
luben karavelov
