---

Closing the network connection (after you finish !)

---

• Network connection to the SQL server
  • Important note:

    The network connection to the SQL server will use some resources at the server computer:

  ---

  ---

  ---

  ---

• Closing the connections to the DBMS server

  • After you have finish, you must free up the computing resources using these methods:

    SQLstatement.close(); // Free Statement buffer SQLconnection.close(); // Free Connection buffer

    ---

    ---

  • Graphical illustration of the effect of the methods:

    Initially we are using the following resources: Buffer space in a Statement object (to store the data sent/received Network connection resource in the SQL connection object Graphically: After the SQLStatement.close( ) call: The buffer is de-allocated After the SQLconnection.close( ) call: The network connection is closed