Project

General

Profile

« Previous | Next » 

Revision 344

Added by bojilova over 24 years ago

on "DELETE" added delete from xml_index table for a given docid
before delete from xml_documents, b' of foreign key in xml_index(docid)
to xml_documents(docid)

View differences:

src/edu/ucsb/nceas/metacat/DBWriter.java
242 242

  
243 243
    // Now delete it from the xml_documents table
244 244
    Statement stmt = conn.createStatement();
245
    stmt.execute("DELETE FROM xml_index WHERE docid LIKE '" + docid + "'");
245 246
    stmt.execute("DELETE FROM xml_documents WHERE docid LIKE '" + docid + "'");
246 247
    stmt.close();
247 248
    conn.commit();
......
250 251

  
251 252
/**
252 253
 * '$Log$
254
 * 'Revision 1.23  2000/06/29 23:27:08  jones
255
 * 'Fixed bug in DBEntityResolver so that it now properly delegates to
256
 * 'the system id found inthe database.
257
 * 'Changed DBValidate to use DBEntityResolver, rather than the OASIS
258
 * 'catalog, and to return validation results in XML format.
259
 * '
253 260
 * 'Revision 1.22  2000/06/27 04:31:07  jones
254 261
 * 'Fixed bugs associated with the new UPDATE and DELETE functions of
255 262
 * 'DBWriter.  There were problematic interactions between some static

Also available in: Unified diff