differences connection pooling versus session pooling occi/oci
- From: Jeroen van Sluisdam <jeroen.van.sluisdam@xxxxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <Oracle-L@xxxxxxxxxxxxx>
- Date: Wed, 2 Aug 2006 17:42:25 +0200
> Hi,
>
> We are setting up a new library for access to the database where we want
> to replace the old, still oci 7
> interface by occi
> When we create a connectionpool with min 3 session max 5, we see 3
> sessions in the database
> and then we issue a connectionPool->createConnection. Expected behaviour
> would be that 1 of 3 sesions
> will be used. Suprise we got a fourth session in the database according to
> v$session.
>
> I found some posts that explain that this might be the case because
> session pooling is used instead of
> connection pooling. I don't understand this completely because why would
> the connectionPool->createConnection
> get a new connection and not use the pool? Can this behaviour be
> influenced somehow to get the expected behaviour?
>
> In the occi manuals there is no reference to sessionPooling but in the oci
> manuals there is.
> Details: Oracle 9.2.0.6, OCCI, HPUX 11.11,
>
> Regards,
>
> Jeroen
>
>
>
Other related posts:
- » differences connection pooling versus session pooling occi/oci
