Project

General

Profile

Statistics
| Revision:

# Date Author Comment
825 09/12/2001 02:46 PM bojilova

added nodeprefix column to xml_nodes table for storing of namespace prefixes per nodes

822 08/16/2001 10:48 AM Matt Jones

Revised build.xml and metacat.properties to make it easier to
install alternative stylesheets for metacat. In the process,
replaced the deprecated copydir and copyfile commands in build.xml
with appropriate "copy" commands.

821 08/15/2001 01:38 PM bojilova

added support for Namespaces.
Metacat now can store and retrieve XML documents with Namespaces.
Namespace is stored as separate record in xml_nodes table with type "NAMESPACE"
where nodename is the prefix and nodedata is the uri of the namespace.

820 08/08/2001 05:07 PM bojilova

fixed an error of NullPointerException

819 08/08/2001 12:56 PM bojilova

- when the Access file goes first before the Package file (eml-dataset-2.0)
relations are not available in xml_relation, thus updated the code
to check and run ACL also after the Package file is saved.
- cut out the rev# from subject and object in xml_relation as needed by ACL...

818 08/02/2001 10:29 AM berkley

fixed error with out of cursors error because pstmts were not getting closed in DBQuery

815 07/31/2001 07:34 PM bojilova

look for relationship "isRelatedTo" b' that is the word that is used in the triples

812 07/31/2001 03:02 PM bojilova

updated with the new eml modules

809 07/25/2001 09:00 AM berkley

added new dtds

804 07/23/2001 09:28 AM bojilova

fixed the compilation bug about the change of group parameter in DocumentImpl.write()

802 07/20/2001 09:03 PM bojilova

added support for multiple group membership

801 07/20/2001 03:19 PM Matt Jones

Changed the constructors so that the nodeRecordList is automatically
retrieved by the DocumentImpl(Connection,String) constructor. this
restores its earlier behavior, but the implementation is totally
done by DocumentImpl(Connection,String,boolean).

800 07/20/2001 11:23 AM Matt Jones

Added fix to DocumentImpl that showed problems when the DocumentImpl(conn)
constructor was called. Now there is a new constructor:
DocumentImpl(Connection, String, boolean)
where the boolean value is used to determine if the nodeset should be
read a t the time the cosntructor is called. if false, then...

799 07/19/2001 02:20 AM Matt Jones

Completely removed the socket-server feature that used to provide
file upload. It is now replaced by multipart/form-data over http.

798 07/19/2001 01:52 AM Matt Jones

Modified Metacat to support large data file uploads. This is accomplished
by supporting a new content type for data sent to metacat:
multipart/form-data
which allows multiple files to be sent in a standard MIME format. The
MetacatServlet.handleGetOrPost() method now checks the incoming content...

797 07/17/2001 07:58 PM bojilova

Simplified ReplicationHandler:
It is run now in the same thread started from DBSAXHandler;
thus the same connection opened in that thread is used,
i.e. no need for new connection and no complains as "Connection is closed" in ReplicationHandler;
"Connection is closed" error happens when in the current thread there are try to use connection opened in another thread,...

795 07/17/2001 09:20 AM bojilova

support for the new terms included in pathquery.dtd

793 07/16/2001 12:32 PM bojilova

http://bugzilla.ecoinformatics.org/show_bug.cgi?id=248
Included utility function about gettig the latest docid for a user:
DBUtil.getLastDocid(username).
Metacat parameters:
action='getlastdocid'
username

792 07/13/2001 12:17 PM bojilova

don't need to override the old meta_file_id tags with docid without rev
since Morpho inserts docids before sending the docs to Metacat

791 07/06/2001 01:29 PM berkley

added the new software module

790 07/06/2001 11:58 AM bojilova

added constructor in DocumentImpl for use in DBQuery.findDocuments();
this new constructor is used with getDocumentInfo() to get the doc info only;
because the other constructor builds the whole xml doc which is not needed here and time consuming;
this happens on backtracking only.

789 07/06/2001 11:43 AM berkley

updated script with new eml20 dtds

788 07/05/2001 09:38 AM bojilova

fixed bug - hardcoded LDAP URL

787 07/02/2001 03:06 PM bojilova

made use of the new property for ldaps url;
it is used for secure connection to LDAP server listening on second port 636 by default with SSL sockets;
it is used from Metacat for the authetication process only;
all the rest communications with LDAP server are made on the default port 389 with plain sockets

785 07/02/2001 11:24 AM bojilova

moved delete from xml_relation before delete from xml_documents
because of the parent-child relation b/w these 2 tables

780 06/12/2001 02:56 PM berkley

fixed error with exception handling in metacat servlet and added new dtds to the sql script

779 06/12/2001 10:15 AM bojilova

changes according to bug# 234 - metacat accession # handling, done

778 06/08/2001 12:10 PM bojilova

changed all mentions of DBAdapter to the new name AbstractDatabase

777 06/08/2001 12:02 PM bojilova

changed all mentions of DBAdapter to the new name AbstractDatabase

775 06/08/2001 11:42 AM bojilova

rename the DB* classes to:
AbstractDatabase
OracleAdapter
PostgresqlAdapter
SqlserverAdapter

774 06/06/2001 01:50 PM bojilova

use the non-null function name from db adapter

773 06/06/2001 01:49 PM bojilova

included new function that returns db specific non-null function name

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

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()

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

745 05/22/2001 03:24 PM Matt Jones

Fixed bug in metacat where return doctypes were not being properly
back traced. Changed DBQuery.findDocuments() so that it no longer
takes a returndoc array, but instead retrieves the returndoc array
fromthe QUERYSpecification. The QuerySpecification was augmented...

744 05/21/2001 02:30 PM Matt Jones

Added ability to process multiple "returndoc" elements in
a pathquery document. Now, any query hit will be back traced to an
associated package if that package is listed in one of the
"returndoctype" elements.

743 05/21/2001 01:51 PM Matt Jones

Modifications that change the package handling behavior of metacat. Package
membership is now determined by an identifier being used as either the subject
or object in a triple. One can not request arbitrary returndocs -- only
those types that have package information embedded can be "returndoctype"...

742 05/16/2001 09:45 AM bojilova

fix in the return of the last revisionid on UPDATE instead of the previous one

741 05/09/2001 01:54 PM harris

this is sql script does the same as the sql script named
xmltables.sql except that this script is to be use to
create the database tables on a Postgresql backend rather
than an Oracle Backend

the foreign-key constraints still need to be fixed

740 05/09/2001 01:49 PM bojilova

fixed the problem with empy password authentication.
Ldap somehow allows DirContext to be created
when empty password is provided as in our case
instead of comlaining like with wrong password string.
So included a check for empty password in order to reject the login.

739 05/08/2001 02:40 PM bojilova

as John were testing Metacat on postgres,
he discovered that Connection needs more precise check
whether it is open because of db timing outs.
So used to be:
if ( conn null ) { get new connection from db; }
Now changed to:
if ( conn null || conn.isClosed() ) { get new connection from db; }...

738 05/04/2001 02:30 PM bojilova

fix to view abstract only when abstractpath parameter was specified

736 05/04/2001 11:12 AM bojilova

put exception handler messages when acc# is not in the correct format as:
<sitecode>.<uniqueid>.[<revisionid>]

735 05/04/2001 09:16 AM bojilova

fix - added back generate(docid, action) method called from DataFileServer.java where rev is defaulted to 1

734 05/03/2001 05:12 PM bojilova

- changes to expect revisionid to come from the client on INSERT/UPDATE/DELETE;
now the client should send accession# as:
sitecode.uniqueid.revisionid
INSERT checks if sitecode.uniqueid part does not exist in xml_documents and xml_revisions and revisionid=1...

733 05/02/2001 02:52 PM bojilova

Tomcat has got configurated mime type mappings, but some are
missing. Thus added support for them in MetaCatServlet as:
File type > MIME type
-------------
----------------
.xml -> "text/xml"
.xsd -> "text/xml"
.dtd -> "text/plain"
.css -> "text/css"...

731 05/01/2001 04:42 PM bojilova

- merged "getabstract" and "getdatadoc" actions to "read" action;
- put MIME types everywhere for the returned data;
- zip when more than one doc/files were requested or when specified by qformat="zip" parameter;
- get rid of "relation" parameter, instead use "docid" parameter name only - when more that one docid - zip them;...

730 04/17/2001 09:32 AM bojilova

Changes related to running LDAP servers referred each other in one tree modeling the KNB tree.
Currently there are running LDAP server on dev that holds the KNB root and the NCEAS' s subtree.
It also refers to a subtree modeling the LTER's tree which is held by another LDAP server runnig on alpha .

729 04/12/2001 11:13 AM berkley

uncompleted script file to create DB on SQL server

728 03/22/2001 03:49 PM bojilova

fixes on getting information from LDAP services

727 03/14/2001 12:46 PM berkley

added check to see if a replication server's IP matched it's DNS entry and the entry in the replication table

726 03/09/2001 04:41 PM bojilova

fixes around getUsers and getGroups.
"getprincipals" action can now produce output like:

<principals>
<group>
<groupname>Administrators<groupname>
<user>
<username>uid=admin,o=NCEAS, c=US<username>
</user>
</group>...

725 03/05/2001 04:25 PM bojilova

Included back getting the list of users and groups stored in auth scheme
through new action="getprincipals". No extra parameters are needed.
Any logged in users are able to get this information

724 03/05/2001 09:57 AM berkley

removed download.xsl entry

723 03/02/2001 04:23 PM bojilova

included missing implementation of getUsers(), getGroups() interfaces

722 02/28/2001 10:19 AM bojilova

no message

721 02/28/2001 10:15 AM bojilova

no message

711 02/26/2001 04:45 PM Matt Jones

Modifications to allow printing of SQL with and without INDEX option.

710 02/26/2001 04:42 PM berkley

added print info and timing info

709 02/26/2001 11:12 AM bojilova

print the nested statements sql query

706 02/23/2001 02:14 PM bojilova

included flag in DBQuery to run pathqueries with or without the index,
but for the command line only.

705 02/23/2001 10:31 AM berkley

added timing info to main

704 02/23/2001 08:45 AM berkley

added removal of relations

703 02/22/2001 04:00 PM berkley

added new stylesheet for download

699 02/21/2001 02:29 PM bojilova

implemented interface for download of DTD or Schema file from Metacat file system
through the params:
action="getdtdschema"
doctype

698 02/07/2001 02:08 PM bojilova

- new attribute catalog_id added in xml_documents and xml_revisions
as a FK to xml_catalog

697 02/07/2001 02:07 PM bojilova

- fixed missing replication of public_access
- new attribute catalog_id added in xml_documents and xml_revisions
as a FK to xml_catalog; catalog_id is replicated also

695 02/06/2001 01:51 PM bojilova

Included check up for <!DOCTYPE ... PUBLIC/SYSTEM ... >
in order to set the validation parser at runtime
In case of:
- no DOCTYPE declaration
- <!DOCTYPE docname>
validation is turned "off"
In case of:
- <!DOCTYPE ... PUBLIC ...>
- <!DOCTYPE ... SYSTEM ...>...

694 02/05/2001 04:17 PM bojilova

reject writing DTD file if it already exists

692 02/01/2001 10:56 AM bojilova

there were more mentions of DOCTITLE attr - cleared them

691 01/31/2001 10:50 AM bojilova

cleared DOCTITLE attribute in xml_documents and xml_revisions
cleared all mentions of doctitle

690 01/31/2001 10:49 AM bojilova

cleared DOCTITLE attribute in xml_documents and xml_revisions

689 01/31/2001 10:28 AM bojilova

cleared the UNIQUE constraint in xml_access - moved in AccessControlList
added FOREIGN keys for xml_relation.docid and xml_access.accessfileid referencing xml_dociments.docid

688 01/31/2001 10:05 AM bojilova

added new "getaccesscontrol" action for a given docid

686 01/26/2001 09:37 AM berkley

fixed white space problem in toXML that was preventing in line end tags from being popped from the stack.

684 01/19/2001 04:12 PM bojilova

Solving the problem with relication of access file where access files were rejected from the replication servers.
In AccessControlList check for serverCode is included,
so only on the local server the connected user is checked for having "all" permissions on the resources specified in it...

683 01/19/2001 03:20 PM berkley

fixed some problems with database connections getting a time out error. Also updated some catch statements

682 01/19/2001 11:31 AM bojilova

fixed typo

680 01/19/2001 11:05 AM bojilova

included new servlet parameter "public" specifing public read access for the submitted document
the expected values are "yes" or "no"
public parameter is optional and if it is not specified, means "no"

679 01/19/2001 10:51 AM berkley

fixed bug that was accidentally introduced when the change from metacatURL to URL was done.