Way to get open database cursors?

2 次查看（过去 30 天）
David Goldsmith
David Goldsmith 2012-9-5
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 个评论
显示 2更早的评论
David Goldsmith
David Goldsmith 2012-9-6
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 2012-9-7
I've submitted "enhancement requests" for a cursor.isopen method and a connection.getOpenCursors method. They've been acknowledged, time will tell...

请先登录，再进行评论。

请先登录，再回答此问题。

回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by