Connector/MXJ commit: r20 - trunk/connector-mxj/src

[eherman]

Modified:
   trunk/connector-mxj/src/TestDb.java
Log:
close statement

Modified: trunk/connector-mxj/src/TestDb.java
===================================================================
--- trunk/connector-mxj/src/TestDb.java	2006-03-17 14:32:12 UTC (rev 19)
+++ trunk/connector-mxj/src/TestDb.java	2006-03-17 15:20:36 UTC (rev 20)
@@ -35,8 +35,9 @@
         out.println();
         Connection conn = connection();
         ResultSet rs = null;
+        Statement stmt = null;
         try {
-            Statement stmt = conn.createStatement();
+            stmt = conn.createStatement();
             rs = stmt.executeQuery(query);
             int columns = rs.getMetaData().getColumnCount();
             while (rs.next()) {
@@ -53,6 +54,13 @@
                     e.printStackTrace();
                 }
             }
+            if (stmt != null) {
+                try {
+                    stmt.close();
+                } catch (SQLException e) {
+                    e.printStackTrace();
+                }
+            }
             conn.close();
         }
     }