Project

General

Profile

Statistics
| Revision:

metacat / src / edu / ucsb / nceas / dbadapter @ 773

Name Size Revision Age Author Comment
DBAdapter.java 4.24 KB 773 almost 20 years bojilova included new function that returns db specific ...
DBOracle.java 3.07 KB 773 almost 20 years bojilova included new function that returns db specific ...
DBPostgresql.java 3.14 KB 773 almost 20 years bojilova included new function that returns db specific ...
DBSqlServer.java 3.08 KB 773 almost 20 years bojilova included new function that returns db specific ...

Latest revisions

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

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

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.

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

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.

746 05/23/2001 03:06 PM bojilova

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

View revisions

Also available in: Atom