/ - Diff - Metacat - Ecoinformatics Redmine

« Previous | Next »

Revision 6549

make sure we close the prepared statement always

     		                        " where nodeid = " + nodeid);
     		                    pstmt.setTimestamp(1, dataTimestamp);
     		                    pstmt.execute();
     		                    pstmt.close();
     		                    //pstmt.close();
     		                    System.out.println("processed: " + nodedata);
     		                    count++;
-...
+    		                    }
+    		                }
     		            } catch (SQLException sqle) {
     		            	pstmt.close();
     		            } catch (Exception e) {
     		            	// do nothing, was not a valid date
     		            	//e.printStackTrace();
+    		            }
     		            } finally {
     		            	pstmt.close();
+    		            }
+    		        }
     		        System.out.println("Table: " + tableName + " complete. " + count + " values converted.");

Also available in: Unified diff