This is database dependent, so check your manuals. In Oracle:
SELECT * FROM SYS.V_$OPEN_CURSORS
(when logged in via an account with access to that particular view -
usually a DBA account) will give you a list of what's open, including SQL
statements. (Might be V_$OPEN_CURSOR...don't quite recall).
This really isn't a servlet question, though. There are lots of resources
on the web for answering database questions, and they should be your first
stop.
At 03:17 PM 8/28/2000 +0000, you wrote:
>Hi Gurus,
>
>I want to know before hand how many cursors are open at a given time to the
>data base.Can any body,SQL Gurus there,can help me how to do it?
>
>This way I want to be sure that my statement.close() is working.
>
>
>_________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>Share information about yourself, create your own public profile at
>http://profiles.msn.com.
>
>___________________________________________________________________________
>To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
>of the message "signoff SERVLET-INTEREST".
>
>Archives: http://archives.java.sun.com/archives/servlet-interest.html
>Resources: http://java.sun.com/products/servlet/external-resources.html
>LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
---
William Crawford + 01 617 577 7844
Invantage, Inc [EMAIL PROTECTED]
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
