RE: JDBC connections not closing

From: Carb Simien [MSFT] (CarbinoS_at_online.microsoft.com)
Date: 11/04/04

  • Next message: Carb Simien [MSFT]: "RE: 'Statements that produce result sets are not allowed in batch commands.' Error" 
    Date: Thu, 04 Nov 2004 22:25:03 GMT

    --------------------
    | Thread-Topic: JDBC connections not closing
    | thread-index: AcTB1nv3W8xh6wDJQIK0wY6q4fuFig==
    | X-WBNR-Posting-Host: 64.165.213.162
    | From: =?Utf-8?B?Um9iZXJ0IEJ1cmRpY2sgW2VNVlBd?=
    <RobertBurdickeMVP@discussions.microsoft.com>
    | Subject: JDBC connections not closing
    | Date: Wed, 3 Nov 2004 10:54:02 -0800
    | Lines: 9
    | Message-ID: <9190757E-F9CF-4597-B497-15BBD8E01259@microsoft.com>
    | MIME-Version: 1.0
    | Content-Type: text/plain;
    | charset="Utf-8"
    | Content-Transfer-Encoding: 7bit
    | X-Newsreader: Microsoft CDO for Windows 2000
    | Content-Class: urn:content-classes:message
    | Importance: normal
    | Priority: normal
    | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
    | Newsgroups: microsoft.public.sqlserver.jdbcdriver
    | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
    | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
    | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.jdbcdriver:6442
    | X-Tomcat-NG: microsoft.public.sqlserver.jdbcdriver
    |
    | Hello All:
    |
    | I am using JDBC to connect to SQL Server 2000. In Java, I close my
    | statement and connection objects, but when I do a select @@connections in
    | query analyzer, the connection I opened is still there. Can anyone tell
    me
    | if there are issues with the MSFT JDBC driver SP2 closing SQL Server 2000
    | connections?
    |
    | Robert
    |

    >From the SQL Server 2000 Books Online documentation, @@CONNECTIONS will
    return all connection "attempts" since the DBMS was started. So this
    number will continue to increase, and it will only get reset when the DBMS
    is restarted. I recommend that you use the stored procedures sp_who or
    sp_who2 to monitor current processes. You can also run the command "SELECT
    * FROM master..sysprocesses" to view the process information, or by using
    Enterprise Manager. In Enterprise Manager, expand your server and navigate
    to Management -> Current Activity -> Process Info.

    Carb Simien, MCSE MCDBA MCAD
    Microsoft Developer Support - Web Data

    Please reply only to the newsgroups.
    This posting is provided "AS IS" with no warranties, and confers no rights.

    Are you secure? For information about the Strategic Technology Protection
    Program and to order your FREE Security Tool Kit, please visit
    http://www.microsoft.com/security.

  • Next message: Carb Simien [MSFT]: "RE: 'Statements that produce result sets are not allowed in batch commands.' Error"
    Loading