Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  ucsb 765 almost 23 years bojilova changed SELECT ... WHERE LIKE ? ... to: SELECT ...

Latest revisions

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

754 05/24/2001 11:21 AM bojilova

change the call from getDateFunction() to getDateTimeFunction()

753 05/24/2001 11:07 AM harris

changed the getDate method to getDateTime and changed the return
string in the postgresql implementation to "now()" from now()::date

752 05/24/2001 10:21 AM bojilova

change the call from getDateString() to getDateFunction()

751 05/24/2001 10:20 AM bojilova

change the method name getDateString() to getDateFunction()
return "now()::date" in the DBPostgresql implementation of that method

750 05/24/2001 09:01 AM harris

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 function so we may want to add a second method to return the
current time.

View revisions

Also available in: Atom