[EMAIL PROTECTED] wrote:
> I have to implement a SOAP service with a lot of database queries to a Oracle DB. - Has anybody
> already played around with the options available for connection pooling across SOAP-requests
> (e.g. the first SOAP-request opens up a connection, and all subsequent requests reuse the same
> physical connection)? There are lots of samples in the Oracle JDBC directory, but which is the
> most efficient?
I'm using Oracle's connection cache: oracle.jdbc.pool.OracleConnectionCacheImpl. Seems to work great.
And I initialize it with a javax.servlet.ServletContextListener. This way it is initialized as soon
as Tomcat starts the webapp.
-rob
--
To unsubscribe, e-mail: <mailto:soap-user-unsubscribe@;xml.apache.org>
For additional commands, e-mail: <mailto:soap-user-help@;xml.apache.org>
- Caching data for SOAP applications soap
- Robert Dietrick