/src/edu/ucsb/nceas/metacat/ContentTypeProvider.java - Diff - Metacat - Ecoinformatics Redmine

« Previous | Next »

Revision 6595

           return docId;
+        }
         // get sql command
         String sql = "SELECT doctype, docid from xml_documents where docid in (";
         String sql = "SELECT doctype, docid from xml_documents where docid in ( ";
         // the first element
         sql = sql + "'"+(String)list.elementAt(0) + "'";
         for (int i=1; i<list.size(); i++)
+        {
           String docid = (String) list.elementAt(i);
           sql = sql + ", '" + docid + "'";
         }//for
         // add parensis
         sql = sql + "?";
         // remaining values
         for (int i = 1; i < list.size(); i++) {
           sql = sql + ", ?";
+        }
         // add parentheses
         sql = sql + ")";
         logMetacat.info("SQL for select doctype: "+ sql);
         ResultSet rs = null;
-...
                                      ("ContentTypeProvider.setPhycialDocIdForBeta");
           serialNumber=conn.getCheckOutSerialNumber();
           pStmt = conn.prepareStatement(sql);
           // set the parameter values
           for (int i = 0; i < list.size(); i++) {
             String docid = (String) list.elementAt(i);
             pStmt.setString(i+1, docid);
+          }
           //execute query
           pStmt.execute();
           rs = pStmt.getResultSet();

Also available in: Unified diff