Revision 899
Added by berkley about 22 years ago
DBSAXNode.java | ||
---|---|---|
389 | 389 |
"INSERT INTO xml_index (nodeid, path, docid, doctype, " + |
390 | 390 |
"parentnodeid) " + |
391 | 391 |
"VALUES (?, ?, ?, ?, ?)"); |
392 |
//((OraclePreparedStatement)pstmt).setExecuteBatch(counter); |
|
393 | 392 |
|
394 | 393 |
pstmt.setString(3, docid); |
395 | 394 |
pstmt.setString(4, doctype); |
... | ... | |
402 | 401 |
Long nodeid = (Long)pathlist.get(path); |
403 | 402 |
pstmt.setLong(1, nodeid.longValue()); |
404 | 403 |
pstmt.setString(2, path); |
404 |
|
|
405 | 405 |
pstmt.executeUpdate(); |
406 |
|
|
407 |
//System.out.println(nodeid + " ==> " + path); |
|
408 | 406 |
} |
409 |
|
|
410 | 407 |
// Close the database statement |
411 | 408 |
pstmt.close(); |
412 | 409 |
} catch (SQLException sqe) { |
413 | 410 |
System.err.println("SQL Exception while inserting path to index in " + |
414 |
"DBSAXNode.updateNodeIndex");
|
|
411 |
"DBSAXNode.updateNodeIndex for document " + docid);
|
|
415 | 412 |
System.err.println(sqe.getMessage()); |
416 | 413 |
throw new SAXException(sqe.getMessage()); |
417 | 414 |
} |
Also available in: Unified diff
made a ton of changes related to keeping oracle SQL code out of the main classes. fixed a bug where the timing of the index thread was off so when it went to index a document, the document was not already in xml_documents thus breaking the FK relation between xml_documents and xml_index. I think that bug might be the reason for the blank resultset screens in morpho. made the postgres implementation much more robust.