Revision 771
Added by bojilova almost 23 years ago
| src/edu/ucsb/nceas/metacat/DocumentImpl.java | ||
|---|---|---|
| 1091 | 1091 |
// for that document as selected from xml_documents |
| 1092 | 1092 |
PreparedStatement pstmt = conn.prepareStatement( |
| 1093 | 1093 |
"INSERT INTO xml_revisions " + |
| 1094 |
"(revisionid, docid, rootnodeid, docname, doctype, " +
|
|
| 1094 |
"(docid, rootnodeid, docname, doctype, " + |
|
| 1095 | 1095 |
"user_owner, user_updated, date_created, date_updated, " + |
| 1096 | 1096 |
"server_location, rev, public_access, catalog_id) " + |
| 1097 |
"SELECT null, ?, rootnodeid, docname, doctype, " +
|
|
| 1097 |
"SELECT ?, rootnodeid, docname, doctype, " + |
|
| 1098 | 1098 |
"user_owner, ?, " + sysdate + ", " + sysdate + ", "+ |
| 1099 | 1099 |
"server_location, rev, public_access, catalog_id " + |
| 1100 | 1100 |
"FROM xml_documents " + |
Also available in: Unified diff
excluded revisionid from the insert statement for xml_revisions.
It is identity column for SQL Server or filled by sequence for db as Oracle or Postgres