Revision 108
Added by Matt Jones over 24 years ago
| sqldoclist.sql | ||
|---|---|---|
| 1 |
set pagesize 100 |
|
| 2 |
column docid format 999 |
|
| 3 |
column docname format a15 |
|
| 4 |
column doctype format a25 |
|
| 5 |
column doctitle format a20 |
|
| 6 |
select docid,docname,doctype,rootnodeid,doctitle from xml_documents; |
|
| 0 | 7 | |
| sqlcatlist.sql | ||
|---|---|---|
| 1 |
set pagesize 100 |
|
| 2 |
column entity_name format a10 |
|
| 3 |
column entity_type format a5 |
|
| 4 |
column source_doctype format a15 |
|
| 5 |
column target_doctype format a15 |
|
| 6 |
column public_id format a20 |
|
| 7 |
column system_id format a20 |
|
| 8 |
select entity_type,source_doctype,target_doctype,public_id,system_id |
|
| 9 |
from xml_catalog; |
|
| 0 | 10 | |
| sqlnodeslist.sql | ||
|---|---|---|
| 1 |
column nodedata format a60 |
|
| 2 |
select nodeid,nodedata from xml_nodes where nodedata like '&qstr'; |
|
| 0 | 3 | |
| src/sqldoclist.sql | ||
|---|---|---|
| 1 |
set pagesize 100 |
|
| 2 |
column docid format 999 |
|
| 3 |
column docname format a15 |
|
| 4 |
column doctype format a25 |
|
| 5 |
column doctitle format a20 |
|
| 6 |
select docid,docname,doctype,rootnodeid,doctitle from xml_documents; |
|
| 0 | 7 | |
| src/sqlcatlist.sql | ||
|---|---|---|
| 1 |
set pagesize 100 |
|
| 2 |
column entity_name format a10 |
|
| 3 |
column entity_type format a5 |
|
| 4 |
column source_doctype format a15 |
|
| 5 |
column target_doctype format a15 |
|
| 6 |
column public_id format a20 |
|
| 7 |
column system_id format a20 |
|
| 8 |
select entity_type,source_doctype,target_doctype,public_id,system_id |
|
| 9 |
from xml_catalog; |
|
| 0 | 10 | |
| src/sqlnodeslist.sql | ||
|---|---|---|
| 1 |
column nodedata format a60 |
|
| 2 |
select nodeid,nodedata from xml_nodes where nodedata like '&qstr'; |
|
| 0 | 3 | |
| src/loadstylesheets.sql | ||
|---|---|---|
| 1 |
INSERT INTO xml_catalog (entity_type, source_doctype, target_doctype, |
|
| 2 |
public_id, system_id) |
|
| 3 |
VALUES ('XSL', '-//NCEAS//eml-dataset//EN', '-//W3C//HTML//EN',
|
|
| 4 |
'-//NCEAS//eml-dataset-display.xsl', |
|
| 5 |
'file:///home/httpd/html/xmltodb/xsqltest/eml-dataset-display.xsl'); |
|
| 6 |
INSERT INTO xml_catalog (entity_type, source_doctype, target_doctype, |
|
| 7 |
public_id, system_id) |
|
| 8 |
VALUES ('XSL', '-//NCEAS//eml-variable//EN', '-//W3C//HTML//EN',
|
|
| 9 |
'-//NCEAS//eml-variable-display.xsl', |
|
| 10 |
'file:///home/httpd/html/xmltodb/xsqltest/eml-variable-display.xsl'); |
|
| 11 |
INSERT INTO xml_catalog (entity_type, source_doctype, target_doctype, |
|
| 12 |
public_id, system_id) |
|
| 13 |
VALUES ('XSL', '-//NCEAS//eml-file//EN', '-//W3C//HTML//EN',
|
|
| 14 |
'-//NCEAS//eml-file-display.xsl', |
|
| 15 |
'file:///home/httpd/html/xmltodb/xsqltest/eml-file-display.xsl'); |
|
| 0 | 16 | |
| bin/loadxml | ||
|---|---|---|
| 1 |
#!/bin/sh |
|
| 2 |
export CPATH=/home/httpd/servlets/xsql/lib/xmlparserv2.jar:${ORACLE_HOME}/jdbc/lib/classes111.zip:/usr/lib/apache/ApacheJServ.jar:/home/httpd/classes/servlet-2.0.jar:./classes
|
|
| 3 |
export USER=jones |
|
| 4 |
export PW=your-pw-goes-here |
|
| 5 |
export DBC=jdbc:oracle:thin:@localhost:1521:test |
|
| 6 |
|
|
| 7 |
java -cp ${CPATH} edu.ucsb.nceas.metacat.DBSAXWriter $1 $USER $PW $DBC
|
|
| 0 | 8 | |
| loadstylesheets.sql | ||
|---|---|---|
| 1 |
INSERT INTO xml_catalog (entity_type, source_doctype, target_doctype, |
|
| 2 |
public_id, system_id) |
|
| 3 |
VALUES ('XSL', '-//NCEAS//eml-dataset//EN', '-//W3C//HTML//EN',
|
|
| 4 |
'-//NCEAS//eml-dataset-display.xsl', |
|
| 5 |
'file:///home/httpd/html/xmltodb/xsqltest/eml-dataset-display.xsl'); |
|
| 6 |
INSERT INTO xml_catalog (entity_type, source_doctype, target_doctype, |
|
| 7 |
public_id, system_id) |
|
| 8 |
VALUES ('XSL', '-//NCEAS//eml-variable//EN', '-//W3C//HTML//EN',
|
|
| 9 |
'-//NCEAS//eml-variable-display.xsl', |
|
| 10 |
'file:///home/httpd/html/xmltodb/xsqltest/eml-variable-display.xsl'); |
|
| 11 |
INSERT INTO xml_catalog (entity_type, source_doctype, target_doctype, |
|
| 12 |
public_id, system_id) |
|
| 13 |
VALUES ('XSL', '-//NCEAS//eml-file//EN', '-//W3C//HTML//EN',
|
|
| 14 |
'-//NCEAS//eml-file-display.xsl', |
|
| 15 |
'file:///home/httpd/html/xmltodb/xsqltest/eml-file-display.xsl'); |
|
| 0 | 16 | |
| loadxml | ||
|---|---|---|
| 1 |
#!/bin/sh |
|
| 2 |
export CPATH=/home/httpd/servlets/xsql/lib/xmlparserv2.jar:${ORACLE_HOME}/jdbc/lib/classes111.zip:/usr/lib/apache/ApacheJServ.jar:/home/httpd/classes/servlet-2.0.jar:./classes
|
|
| 3 |
export USER=jones |
|
| 4 |
export PW=your-pw-goes-here |
|
| 5 |
export DBC=jdbc:oracle:thin:@localhost:1521:test |
|
| 6 |
|
|
| 7 |
java -cp ${CPATH} edu.ucsb.nceas.metacat.DBSAXWriter $1 $USER $PW $DBC
|
|
| 0 | 8 | |
Also available in: Unified diff
added utility files and queries