Databases Reference
In-Depth Information
50,000 records. The JDBC application executes the SQL
Select
statement in the
following code:
PreparedStatement pstmt = con.prepareStatement(
"SELECT fname, lname, crimes, convictions, laddress, photo " +
"FROM FBI_most_wanted WHERE state=?");
pstmt.setString(1, "NC");
ResultSet rs = pstmt.executeQuery ();
// Display all rows
while (rs.next()) {
// Retrieve information and display the contents
}
rs.close();
Environment Details
The environment details are as follows:
•
The application is JDBC and is running on an application server.
•
The database is Microsoft SQL Server running on Windows XP.
•
The client machines are running a variety of Windows operating systems,
such as Windows XP and Windows Vista.
•
The application is deployed in a distributed WAN environment.
•
The application server is running J2SE 5.
•
The application is using a connection pool for connection management.
The Issue
Occasionally when a user exits the application, it closes very slowly (almost
appears to hang). What could be the cause?
Here are some questions to ask:
•
Why does this happen only upon closing the application, and why only occa-
sionally?
•
Which components in the environment affect the closing of the application?
•
What tasks must be performed when the application is closed?
•
What type of data is being returned?