Re: Where to find all open DB connections and closes them

Now answers so far,
so wath's the problem:

I opened a DB connection using first the  dispatcher to have a 
Datasourcebrowser and then i fill the grid with data from a registered 
database connected to a MySQL over the native connector.
loadComponentFromURL(".component:DB/DataSourceBrowser", "_beamer", 0, 
aProps)
The resulting "activeconnection" can been disposed orclosed but the 
object is still there without any further use.(giving a "disposed exeption")
even after kiling the object the connection is still open as a "sleep" 
connection "on the Mysql server and stay there for ever....

- disabling or enabling the "pooling"  make no differences
- the connection stay there until i close OO

so: How can i "find" this half alive connection and kill it without 
closing OO

Thanks again

Fernand

> hallo all,
>
> 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
>
> Thanks for any hint
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]