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
class conect(DBPool):
def __init__(self):
self.conn = None
self.cur = None
def try_connect(self,guser='B2MSYS',gpasswd='B2MSYS',gdb='DUNYA_SRV'):
dbPool = DBPool(cx_Oracle, 5, user=guser, password=gpasswd,
dsn=gdb)
self.conn = dbPool.getConnection()
self.cur = self.conn.cursor()
def run(self,sqls=''):
self.cur.execute(sqls)
don = self.cur.fetchall()
return don
def run_dml(self):
self.cur.execute(sqls)
def commit(self):
self.conn.commit()
def cls_conn(self):
self.conn.close()
2. but i want to open connections during appserver load, is this
possible to open connections with pool and used it in py or psp
files?
-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
Webware-discuss mailing list
Webware-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/webware-discuss
