Pooling

[jestep]

Ok, here it is:
I have an HTTP server using DOA 3.4.6.4 and using pooling of spInternal...

I create sessions withing the thread.

If I have connections one at a time everything is fine, but once multiples hit things hang. I have one master Oracle Session...

Can someone so me an example or tell me 'exactly' how to make this work correctly since the help file does not show examples.

Thanks

 

[jpickup]

Each thread must have its own session. This must be a real Oracle Session and not just a TOracleSession component that is sharing another component's session (i.e. no use of the Share method or the Externalxxx properties)

 

[jestep]

Uh huh..... I know that, but apparently the older version did not require this... But I have always freed my sessions at the end of the HTTP request, but with this version it causes a hang, I assume from using a session that was being freed.

Anyway, I added in SessionPool.Release for each session and everything is rolling along fine now...

 

[jestep]

I spoke too soon it seems....
Somewhere along the line sessions are not getting disconnected.

So I end up getting too many sessions error from Oracle.

I can hit refresh 100 times on the browser and it works fine... I can see in my log that half of these get processed around the same time...

Has anyone had to deal with this??