Activity
From 05/28/2001 to 06/26/2001
06/21/2001
- 11:22 AM Revision 783 (metacat): cleared the text under the figure; should go in the Word text
- 09:17 AM Revision 782 (metacat): EPS files saved as AdobeIllustrator v7.0
06/20/2001
06/12/2001
- 02:56 PM Revision 780 (metacat): fixed error with exception handling in metacat servlet and added new dtds to the sql script
- 10:15 AM Revision 779 (metacat): changes according to bug# 234 - metacat accession # handling, done
06/08/2001
- 12:10 PM Revision 778 (metacat): changed all mentions of DBAdapter to the new name AbstractDatabase
- 12:02 PM Revision 777 (metacat): changed all mentions of DBAdapter to the new name AbstractDatabase
- 11:44 AM Revision 776 (metacat): changed dbAdapter property to edu...OracleAdapter
- 11:42 AM Revision 775 (metacat): rename the DB* classes to:
- AbstractDatabase
OracleAdapter
PostgresqlAdapter
SqlserverAdapter
06/06/2001
- 01:50 PM Revision 774 (metacat): use the non-null function name from db adapter
- 01:49 PM Revision 773 (metacat): included new function that returns db specific non-null function name
06/05/2001
- 12:24 PM Revision 772 (metacat): cleared the COLLATION specifiers on column definitions:
- it is new in SQL Server 2000 and not supported in its earlier versions
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
- 01:47 PM Revision 770 (metacat): changed like with =
06/01/2001
- 04:14 PM Revision 769 (metacat): changed ... WHERE ... LIKE ? ...
- to ... WHERE ... = ? ...
- 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
- 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... - 12:51 PM Revision 765 (metacat): changed
- SELECT ... WHERE LIKE ? ...
to:
SELECT ... WHERE = ? ...
It should be changed everywhere it is found - 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 - 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
- 12:08 PM Revision 762 (metacat): added
- INSERT INTO xml_replication (serverid, server, replicate) VALUES ('1', 'localhost', '0');
which was missing
05/31/2001
- 05:26 PM Revision 759 (metacat): several changes were needed related to the change of the unique id generation and use
- 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... - 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...
05/29/2001
- 05:17 PM Revision 756 (metacat): Updated pathquery.dtd to reflect new addition of filterdoctype element.
- 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
Also available in: Atom