Project

General

Profile

Statistics
| Revision:

metacat / src / edu / ucsb / nceas @ 773

Name Size Revision Age Author Comment
  dbadapter 773 almost 20 years bojilova included new function that returns db specific ...
  metacat 771 almost 20 years bojilova excluded revisionid from the insert statement f...
  protocols 668 over 20 years Matt Jones Added License terms to source files, added more...

Latest revisions

# Date Author Comment
773 06/06/2001 01:49 PM bojilova

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

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

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....

View revisions

Also available in: Atom