Re: How to obtain db connection from pool ?

[Marcin Okraszewski]

Hi,
And how about obtaining it outside a flow? How to get the instance of 
the component selector that I could run something similar to 
cocoon.getComponent() from the example below?

Regards,
Marcin Okraszewski
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]



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