Re: Connection pooling

I have the same problem. We have several CORBA objects which make database connections to Informix and the connections are supposed to last until the objects deactivate. All clients need to access data through these objects and the Virtual portion of shared memory grows. I am still finding solution.... By the way, how do you implement connection pooling ? using JDBC 2.0? using some Application Server ? I am still evaulation on how to implement it. Deric ---------------------------------------------------------------------------- --------- Sunil Mathew wrote in message <7dh3pn$amd$1@newman.pcisys.net>... >Hi, >Has any one used JDBC and connection pooling with informix? >It appears that when using connection pooling, the Virtual portion of shared >memory grows even though the same connections are reused. >Tjhis causes us to run out of memory soon and results in really bad >performace. If we replace connection pooling and open and close connections >for each request, the database can support a lot more concurrent requests. > >Does any one know if this is a known issue? Also we do not have commits >after reads only after update/insert. >Thanks, >Sunil > >