Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  dbadapter 757 over 23 years bojilova - new db adapter for MS SQL Server - changed th...
  metacat 771 over 23 years bojilova excluded revisionid from the insert statement f...
  protocols 668 almost 24 years Matt Jones Added License terms to source files, added more...

Latest revisions

# Date Author Comment
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....

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.

View revisions

Also available in: Atom