Re: [Webware-discuss] dbpooling

2005-09-02 Thread Christoph Zwerschke
Ibrahim HIDIR wrote: > thanks for help, it looks like working, but in fact i don't use > servlet, and i have different users and passwords and databases > (oracle, mysql, mssql, pgsql) i need to connect all of them same time > with different users and pass , so if there is no session in my page,

Re: [Webware-discuss] dbpooling

2005-09-01 Thread Christoph Zwerschke
Hi Ibrahim, since cx_Oracle is DB API compliant, it should work with DBPool.py. The problem in your code is that you instantiate DBPool for every connection you want to make. You should only intantiate it once: import cx_Oracle from MiscUtils.DBPool import DBPool dbPool = DBPool(cx_Oracle, 5,

[Webware-discuss] dbpooling

2005-09-01 Thread Ibrahim HIDIR
hi i am ibrahim HIDIR from Turkey, Ankara 1. I need a connection pooling for any db, so i tried to use DBPool utilyty, but i got hundreds of connection in my oracle db, i think i did something wrong, the code i used is, file : con_ora.py import cx_Oracle from MiscUtils.DBPool import DBPool cla