Activity

30 days up to

User

From 05/24/2001 to 06/22/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 bojilova

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

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: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:17 PM Revision 756 (metacat): Updated pathquery.dtd to reflect new addition of filterdoctype element.: 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

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

Also available in: Atom

Metacat