Project

Profile

Help

Forums » Help »

Using DB Connection Pool with sql:connect

Added by Anonymous over 18 years ago

Legacy ID: #3573516 Legacy Poster: jdoody1 (jdoody1)

Can database connection pooling be used in the sql:connect extension. Xalan does this via passing a parameter. Is the same thing possible with Saxon? If yes, can someone post an example? thanks.


Replies (2)

RE: Using DB Connection Pool with sql:connect - Added by Anonymous over 18 years ago

Legacy ID: #3573576 Legacy Poster: Michael Kay (mhkay)

It's not possible as far as I'm aware! But the SQL extension is really just a demonstration app, you're welcome to make the necessary enhancements and feed them back.

RE: Using DB Connection Pool with sql:connect - Added by Anonymous over 18 years ago

Legacy ID: #3573776 Legacy Poster: Roger Kovack (rkovack)

If you are using Tomcat, I have some classes that provide an extention function for Saxon. The connection is pooled using a Tomcat resource with the pooling config and other connection details set in Tomcat's web.xml, not in the stylesheet through the extension. That way the system administrator that installs your application, not the stylesheet author, is responsible for the connction and pooling details. The extension will send parameterized queries and also send batch updates which you produce using the native stylesheet constructs. HTH, Roger Kovack

    (1-2/2)

    Please register to reply