I started on some tests but didn't come to any conclusions.
You might want to check that the application code is closing connections and ending transactions promptly.
I'm not sure what adapter you are using, or if Oracle actually supplies an adapter themselves (there appear to be some adapter classes in the 10g jar). You might consider using the tranql Oracle adapter and using Oracle internal datasource pooling instead of Geronimo pooling. We haven't actually tried this significantly yet, so if you try it please let us know how it works.
The tranql adapter:
cvs.openejb.org:/home/projects/tranql/scm
You need both the connector and vendor cvs modules.
You also need the maven rar plugin which is released by maven but not yet in a distro. I'm not sure if it is downloaded automatically or if you need to install it by
maven plugin:download -DartifactId=maven-rar-plugin -DgroupId=maven -Dversion=1.0
I'm quite interested in whatever you come up with.
Thanks david jencks
On Thursday, June 24, 2004, at 12:40 PM, Hamilton Verissimo de Oliveira (Engenharia - SPO) wrote:
Hi there,
Has anyone made some stress tests on connection pool's implementation under
Connector? I know its code, and I don't think I've seen bottlenecks, but
people from the QA team here raised this issue.
My environment:
- Oracle database - Pool with 20 connection at maximum - Through JMeter, 50 threads requesting some page.
I am working on it saturday, but I'd like to have some feelings about it.
Cheers, hammett
