Project

General

Profile

« Previous | Next » 

Revision 763

Added by bojilova over 23 years ago

commented out the use of oracle.jdbc.driver
this was harcoded use for batching the sql calls at once in order to speed up the insert of XML Index

View differences:

src/edu/ucsb/nceas/metacat/DBSAXNode.java
31 31
import java.io.IOException;
32 32
import java.util.Hashtable;
33 33
import java.util.Enumeration;
34
import oracle.jdbc.driver.*;
34
//import oracle.jdbc.driver.*;
35 35
import org.xml.sax.SAXException;
36 36

  
37 37
import edu.ucsb.nceas.dbadapter.DBAdapter;
......
300 300
              "INSERT INTO xml_index (nodeid, path, docid, doctype, " + 
301 301
               "parentnodeid) " + 
302 302
              "VALUES (?, ?, ?, ?, ?)");
303
      ((OraclePreparedStatement)pstmt).setExecuteBatch(counter);
303
      //((OraclePreparedStatement)pstmt).setExecuteBatch(counter);
304 304
  
305 305
      pstmt.setString(3, docid);
306 306
      pstmt.setString(4, doctype);
......
378 378
              "INSERT INTO xml_index (nodeid, path, docid, doctype, " + 
379 379
               "parentnodeid) " + 
380 380
              "VALUES (?, ?, ?, ?, ?)");
381
      ((OraclePreparedStatement)pstmt).setExecuteBatch(counter);
381
      //((OraclePreparedStatement)pstmt).setExecuteBatch(counter);
382 382
  
383 383
      pstmt.setString(3, docid);
384 384
      pstmt.setString(4, doctype);

Also available in: Unified diff