Project

General

Profile

Revision 108

Added by Matt Jones over 20 years ago

added utility files and queries

View differences:

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