Re: [cx-oracle-users] Connection pooling for website
Brought to you by:
atuining
From: Anthony T. <ant...@gm...> - 2006-08-30 13:58:14
|
I am not aware of any way of sharing any Oracle connection between multiple processes. I'm not that familiar with coding in Apache but I do know that there are ways of indicating that you want one process to handle the request which would allow you to use a connection pool. Of course, then you are into threading which has its own set of issues.... :-) On 8/29/06, Bradley Lawrence <Bra...@ra...> wrote: > Is it possible to share an oracle connection pool between different > processes? regardless of whether using CGI, FastCGI, mod_python, I still > have to deal with multiple apache processes and it doesn't make sense to > have each one keep its own pool. I also want to avoid gutting my entire > database layer the way sqlrelay would require -- I like cx_Oracle. > > How do other people handle this? It doesn't seem to be possible with > cx_Oracle.SessionPool from what I can see, unless there is a way to > initialize it with an already-created poolname? > > -- > > Bradley Lawrence > Application Developer, RapiData > Rapid Technology Corporation > (403) 209-3000 ext. 237 > > > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > |