Berglas, Anthony wrote:
I am trying to set up 0racle connection pooling. Some of the parameters are reflected normally, but some are specified via a property lists. How do I set the property list properties using Tomcat/JNDI? I can set up the basic DataSource, but I cannot set the maxLimit parameter on the max number of connections because they are in the setConnectionCacheProperties property map, not reflected.
Been there, done that. Unfortunately I cannot share the details (as in code), but I had to write a custom resource factory to build the Oracle connection pools for me. That went pretty much as per the Tomcat documentation in http://tomcat.apache.org/tomcat-5.5-doc/jndi-resources-howto.html#Adding%20Custom%20Resource%20Factories A side note for this is that Oracle JDBC library (at least as shipped with 10gRel2) is somewhat fussy about the order in which you set the various properties. What's worse, if you get the order wrong, the settings are just silently ignored (and the significance of correct ordering is not documented, either). I did file a bug report about this with Oracle, but haven't heard of it since. -- ..Juha --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
