Re: DBD::Oracle DRCP_1.25

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