Metacat

06/04/2001

02:07 PM Revision 771 (metacat): 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 bojilova

01:47 PM Revision 770 (metacat): changed like with =

bojilova

06/01/2001

04:14 PM Revision 769 (metacat): changed ... WHERE ... LIKE ? ...

to ... WHERE ... = ? ... bojilova

04:12 PM Revision 768 (metacat): MS SQL Server stores trailing spaces in varchar fields which shouldn't be

thus added docid.trim() in the Java code bojilova

01:26 PM Revision 766 (metacat): the ODBC multi-threading problem:

in DBQuery we open ResultSet in the db connection and we are trying to
open another Resultset by AccessControlList wh... bojilova

12:51 PM Revision 765 (metacat): changed

SELECT ... WHERE LIKE ? ...
to:
SELECT ... WHERE = ? ...
It should be changed everywhere it is found bojilova

12:14 PM Revision 764 (metacat): 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 bojilova

12:12 PM Revision 763 (metacat): 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 bojilova

12:08 PM Revision 762 (metacat): added

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

05/31/2001

05:26 PM Revision 759 (metacat): several changes were needed related to the change of the unique id generation and use

bojilova

05:24 PM Revision 758 (metacat): 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 gene... bojilova

05:18 PM Revision 757 (metacat): - 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 uni... bojilova

05/29/2001

05:17 PM Revision 756 (metacat): Updated pathquery.dtd to reflect new addition of filterdoctype element.

Matt Jones

12:54 PM Bug #183: Port metacat to PostgresSQL and other databases

I noticed that new classes that implement this functionality were checked in (by
Jivka). I have some file naming sug... Matt Jones

11:09 AM Revision 755 (metacat): - made xmltables-sqlserver.sql from SQL Server running here on rincon machine

- included db index on xml_nodes.nodename which was missing bojilova

05/24/2001

11:21 AM Revision 754 (metacat): change the call from getDateFunction() to getDateTimeFunction()

bojilova

11:07 AM Revision 753 (metacat): changed the getDate method to getDateTime and changed the return

string in the postgresql implementation to "now()" from now()::date harris

10:21 AM Revision 752 (metacat): change the call from getDateString() to getDateFunction()

bojilova

10:20 AM Revision 751 (metacat): change the method name getDateString() to getDateFunction()

return "now()::date" in the DBPostgresql implementation of that method bojilova

09:01 AM Revision 750 (metacat): 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 funct... harris

05/23/2001

03:28 PM Revision 749 (metacat): 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 bojilova

03:26 PM Revision 748 (metacat): added new property for the dbadapter class as:

dbAdapter=edu.ucsb.nceas.dbadapter.DBOracle
the installation procedure should change it to the appropriate class bojilova

03:19 PM Revision 747 (metacat): - 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 th... bojilova

03:06 PM Revision 746 (metacat): the abstract DBAdapter class and its Oracle implementation

for the new dbadapter package bojilova

05/22/2001

03:24 PM Revision 745 (metacat): 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... Matt Jones

05/21/2001

03:42 PM Bug #190: modify resultset to return all package information

Added ability to process multiple "returndoc" elements in
a pathquery document. Now, any query hit will be back trace... Matt Jones

02:46 PM Bug #190: modify resultset to return all package information

Modifications that change the package handling behavior of metacat. Package
membership is now determined by an identi... Matt Jones

02:30 PM Revision 744 (metacat): 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 o... Matt Jones

01:51 PM Revision 743 (metacat): 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 re... Matt Jones

05/16/2001

09:45 AM Revision 742 (metacat): fix in the return of the last revisionid on UPDATE instead of the previous one

bojilova

05/11/2001

11:42 AM Bug #233: authentication always succeeds with empty password

FIXED Jivka Bojilova

01:46 AM Bug #160: need resource restriction capability

Deferred indefinitely because SRB deployment is in question. Will reopen later
if we decide to deploy the SRB. Matt Jones

01:45 AM Bug #152: Port SRB1_1_8 changes to Linux x86

Deferred indefinitely because SRB deployment is in question. Will reopen later
if we decide to deploy the SRB. Matt Jones

01:44 AM Bug #137: need admin client for managing SRB systems

Deferred indefinitely because SRB deployment is in question. Will reopen later
if we decide to deploy the SRB. Matt Jones

05/10/2001

12:12 PM Bug #186: add web metadata entry form for Metacat

Rudolf -- could you check in your current metadata HTML form and the perl script
that processes its contents so Chris... Matt Jones

12:04 PM Bug #186: add web metadata entry form for Metacat

Added cjones to cc list because he has agreed to work onthis as well. Matt Jones

05/09/2001

04:44 PM Bug #233: authentication always succeeds with empty password

Fixed from Metacat
Ldap server seems to always allow access with empty password strings Jivka Bojilova

01:54 PM Revision 741 (metacat): 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 ... harris

01:49 PM Revision 740 (metacat): 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 lik... bojilova

05/08/2001

05:57 PM Bug #233 (Resolved): authentication always succeeds with empty password

If logging into metacat, providing an empty string for a password always results
in successful authentication. This... Matt Jones

02:40 PM Revision 739 (metacat): 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:
... bojilova

11:47 AM Bug #199: changes in Access Control mechanism

. Jivka Bojilova

11:45 AM Bug #199: changes in Access Control mechanism

1. No changes are required for "public" access. Any LDAP auth server can hold
a "public" entry as a user or a group.... Jivka Bojilova