Way to get open database cursors?

1 vue (au cours des 30 derniers jours)
David Goldsmith
David Goldsmith le 5 Sep 2012
Database toolbox Q here--if that ain't your kuleana, please ignore.
Say I've been "lazy" and/or "forgetful" and haven't been closing my cursors before wanting to close my database connection--is there a generic way to retrieve all open cursors so I can close them before attempting to close the connection?
Also, while I have "you" on the line: what's the difference between an "open" connection and a "valid" connection, i.e., the difference between a "false" result from isconnection and an error result from ping?
Thanks!
  4 commentaires
David Goldsmith
David Goldsmith le 6 Sep 2012
OK, but that still leaves me wondering, then: is a close(conn) failure the only way to detect a close(curs) failure? Thanks.
David Goldsmith
David Goldsmith le 7 Sep 2012
I've submitted "enhancement requests" for a cursor.isopen method and a connection.getOpenCursors method. They've been acknowledged, time will tell...

Connectez-vous pour commenter.

Réponses (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by