Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  com 71 almost 24 years higgins Catalog files from arbortext added
  edu 764 almost 23 years bojilova seems that there are problem in JDBC-ODBC bridg...
clear.sql 312 Bytes 704 about 23 years berkley added removal of relations
loaddtd.sql 1.86 KB 743 almost 23 years Matt Jones Modifications that change the package handling ...
loadstylesheets.sql 2.16 KB 724 about 23 years berkley removed download.xsl entry
showdoc.sql 340 Bytes 390 over 23 years Matt Jones Added new utility query to return all of the xm...
sqlcatlist.sql 253 Bytes 123 almost 24 years Matt Jones Modifying storage model to use DOM TEXT nodes
sqldoclist.sql 209 Bytes 531 over 23 years Matt Jones Changed utility query to include the user_owner...
sqlnodeslist.sql 94 Bytes 108 almost 24 years Matt Jones added utility files and queries
sqlnodesview.sql 358 Bytes 166 almost 24 years Matt Jones minor modifications to fix problems introduced ...
sqlrevisions.sql 205 Bytes 203 almost 24 years Matt Jones Merged in substantial changes to DBWriter and a...
xmlpackage.sql 1.94 KB 439 over 23 years berkley sql file defining the table structure for eml-p...
xmltables-sqlserver.sql 9.84 KB 762 almost 23 years bojilova added INSERT INTO xml_replication (serverid, se...
xmltables.sql 9.42 KB 759 almost 23 years bojilova several changes were needed related to the chan...
xmltables_postgres.sql 8.49 KB 759 almost 23 years bojilova several changes were needed related to the chan...

Latest revisions

# Date Author Comment
764 06/01/2001 12:14 PM bojilova

seems that there are problem in JDBC-ODBC bridge used with SQL Server
when using sql statements like:
SELECT ...
WHERE LIKE ? ...
changed to:
SELECT ...
WHERE = ? ...
and now it works

763 06/01/2001 12:12 PM bojilova

commented out the use of oracle.jdbc.driver
this was harcoded use for batching the sql calls at once in order to speed up the insert of XML Index

762 06/01/2001 12:08 PM bojilova

added
INSERT INTO xml_replication (serverid, server, replicate) VALUES ('1', 'localhost', '0');
which was missing

759 05/31/2001 05:26 PM bojilova

several changes were needed related to the change of the unique id generation and use

758 05/31/2001 05:24 PM bojilova

Changed the order of generating and getting Unique ID for
xml_nodes.nodeid and for uniqueid part of the accession#
because of SQl Server capabilities:
first let the db to generate unique id on insert (by db trigger and sequence or by IDENTITY key),
then get that unique id for further use by the application....

757 05/31/2001 05:18 PM bojilova

- new db adapter for MS SQL Server
- changed the getUniqueID(conn, tableName) to return the last generated by the db unique ID
instead of generating unique ID first by the appl and then supplied to the insert,
because SQL Server doesn't have capabilities
unique ID to be generated on the client and then supplied to the insert.

755 05/29/2001 11:09 AM bojilova

- made xmltables-sqlserver.sql from SQL Server running here on rincon machine
- included db index on xml_nodes.nodename which was missing

754 05/24/2001 11:21 AM bojilova

change the call from getDateFunction() to getDateTimeFunction()

753 05/24/2001 11:07 AM harris

changed the getDate method to getDateTime and changed the return
string in the postgresql implementation to "now()" from now()::date

752 05/24/2001 10:21 AM bojilova

change the call from getDateString() to getDateFunction()

View revisions

Also available in: Atom