Project

General

Profile

Statistics
| Revision:

metacat / src @ 772

Name Size Revision Age Author Comment
  com 71 almost 21 years higgins Catalog files from arbortext added
  edu 771 almost 20 years bojilova excluded revisionid from the insert statement f...
clear.sql 312 Bytes 704 about 20 years berkley added removal of relations
loaddtd.sql 1.86 KB 743 almost 20 years Matt Jones Modifications that change the package handling ...
loadstylesheets.sql 2.16 KB 724 about 20 years berkley removed download.xsl entry
showdoc.sql 340 Bytes 390 over 20 years Matt Jones Added new utility query to return all of the xm...
sqlcatlist.sql 253 Bytes 123 almost 21 years Matt Jones Modifying storage model to use DOM TEXT nodes
sqldoclist.sql 209 Bytes 531 over 20 years Matt Jones Changed utility query to include the user_owner...
sqlnodeslist.sql 94 Bytes 108 almost 21 years Matt Jones added utility files and queries
sqlnodesview.sql 358 Bytes 166 almost 21 years Matt Jones minor modifications to fix problems introduced ...
sqlrevisions.sql 205 Bytes 203 almost 21 years Matt Jones Merged in substantial changes to DBWriter and a...
xmlpackage.sql 1.94 KB 439 over 20 years berkley sql file defining the table structure for eml-p...
xmltables-sqlserver.sql 8.63 KB 772 almost 20 years bojilova cleared the COLLATION specifiers on column defi...
xmltables.sql 9.42 KB 759 almost 20 years bojilova several changes were needed related to the chan...
xmltables_postgres.sql 8.49 KB 759 almost 20 years bojilova several changes were needed related to the chan...

Latest revisions

# Date Author Comment
772 06/05/2001 12:24 PM bojilova

cleared the COLLATION specifiers on column definitions:
it is new in SQL Server 2000 and not supported in its earlier versions

771 06/04/2001 02:07 PM bojilova

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

770 06/04/2001 01:47 PM bojilova

changed like with =

769 06/01/2001 04:14 PM bojilova

changed ... WHERE ... LIKE ? ...
to ... WHERE ... = ? ...

768 06/01/2001 04:12 PM bojilova

MS SQL Server stores trailing spaces in varchar fields which shouldn't be
thus added docid.trim() in the Java code

766 06/01/2001 01:26 PM bojilova

the ODBC multi-threading problem:
in DBQuery we open ResultSet in the db connection and we are trying to
open another Resultset by AccessControlList which does not work
thus open separate connection for use by AccessControlList.

765 06/01/2001 12:51 PM bojilova

changed
SELECT ... WHERE LIKE ? ...
to:
SELECT ... WHERE = ? ...

It should be changed everywhere it is found

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

View revisions

Also available in: Atom