Hi Fernand,
> When opening a DatasourceBrowser with the dispatcher using
> loadComponentFromURL(".component:DB/DataSourceBrowser", "_beamer", 0,
> aProps)
> I have a connection opened with the database server.
>
> How can i find this "opened" connection and close it with the API ?
>
> I tried and found a "activeConnection" on the derivided rowset
>
> "orowset.activeconnection.dispose"
> or
> "orowset.activeConnection.close"
> does nothing the connection stays open on the server site, only closing
> OO closes this connection
Since you say in your other mail that disabling connection pooling
doesn't change the behavior, I can't think of any legitimate reason for
keeping the connection open - so, it sounds like a bug.
And yet more, there's no chance to iterate over opened connections, and
forcefully close them (as this would ... irritate a lot of other
components). Sorry to say.
Interesting question would be whether this also happens with MySQL over
JDBC, for instance. (One reason why this is interesting is because the
JDBC driver has built-in logging capabilities, see
http://wiki.services.openoffice.org/wiki/Logging_JDBC_Activity.)
Ciao
Frank
--
ORACLE
Frank Schönheit | Software Engineer | frank.schoenh...@sun.com
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org
