Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  com 71 over 24 years higgins Catalog files from arbortext added
  edu 757 over 23 years bojilova - new db adapter for MS SQL Server - changed th...
clear.sql 312 Bytes 704 almost 24 years berkley added removal of relations
loaddtd.sql 1.86 KB 743 over 23 years Matt Jones Modifications that change the package handling ...
loadstylesheets.sql 2.16 KB 724 over 23 years berkley removed download.xsl entry
showdoc.sql 340 Bytes 390 over 24 years Matt Jones Added new utility query to return all of the xm...
sqlcatlist.sql 253 Bytes 123 over 24 years Matt Jones Modifying storage model to use DOM TEXT nodes
sqldoclist.sql 209 Bytes 531 about 24 years Matt Jones Changed utility query to include the user_owner...
sqlnodeslist.sql 94 Bytes 108 over 24 years Matt Jones added utility files and queries
sqlnodesview.sql 358 Bytes 166 over 24 years Matt Jones minor modifications to fix problems introduced ...
sqlrevisions.sql 205 Bytes 203 over 24 years Matt Jones Merged in substantial changes to DBWriter and a...
xmlpackage.sql 1.94 KB 439 about 24 years berkley sql file defining the table structure for eml-p...
xmltables-sqlserver.sql 13 KB 755 over 23 years bojilova - made xmltables-sqlserver.sql from SQL Server ...
xmltables.sql 8.63 KB 755 over 23 years bojilova - made xmltables-sqlserver.sql from SQL Server ...
xmltables_postgres.sql 8.01 KB 755 over 23 years bojilova - made xmltables-sqlserver.sql from SQL Server ...

Latest revisions

# Date Author Comment
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()

751 05/24/2001 10:20 AM bojilova

change the method name getDateString() to getDateFunction()
return "now()::date" in the DBPostgresql implementation of that method

750 05/24/2001 09:01 AM harris

The Postgres implementation of the dbadapter package, still needs testing and
the getDate... method just returns the db function to return the date; to retreive the
current time is a second function so we may want to add a second method to return the
current time.

749 05/23/2001 03:28 PM bojilova

changed the db sequence name used for the accession# uniqueid
to xml_documents_id_seq.
All db sequences now are named of form <table_name>_id_seq

747 05/23/2001 03:19 PM bojilova

- changed to use the DBAdapter uniform interface for all apperance of "sysdate"
and uniqueid generation from sequence
MetaCatUtil:
- reads from metacat.properties the dbadapter class implemented the interface
and creates an instance of that class (in static public variable named dbAdapter) for use....

746 05/23/2001 03:06 PM bojilova

the abstract DBAdapter class and its Oracle implementation
for the new dbadapter package

View revisions

Also available in: Atom