Re: How to obtain db connection from pool ?

[Mariusz Sieraczkiewicz]

Suggested using flowscript, then try sth like this:

    try {
        var dbSelector = 
cocoon.getComponent(Packages.org.apache.avalon.excalibur.datasource.DataSourceComponent.ROLE 
+ "Selector");
        var dataSrc = dbSelector.select("your counnection");
        conn = dataSrc.getConnection();

          // your stuff
    }
    catch (e) {
        e.toString();
    }
    finally {
        if (conn != null) {
            conn.close();
            conn = null;
        }
        if (dbSelector != null) {
            cocoon.releaseComponent(dbSelector);
            dbSelector = null;
        }
    }
But if you write Avalon Component, just look at database actions sources.

Regards

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]