| Revision:
Name Size Revision Age Author Comment
  ucsb 758 over 22 years bojilova Changed the order of generating and getting Uni...

Latest revisions

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

747 05/23/2001 03:19 PM bojilova

- changed to use the DBAdapter uniform interface for all apperance of "sysdate"
and uniqueid generation from sequence
- reads from the dbadapter class implemented the interface
and creates an instance of that class (in static public variable named dbAdapter) for use....

746 05/23/2001 03:06 PM bojilova

the abstract DBAdapter class and its Oracle implementation
for the new dbadapter package

745 05/22/2001 03:24 PM Matt Jones

Fixed bug in metacat where return doctypes were not being properly
back traced. Changed DBQuery.findDocuments() so that it no longer
takes a returndoc array, but instead retrieves the returndoc array
fromthe QUERYSpecification. The QuerySpecification was augmented...

View revisions

Also available in: Atom