|
|||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectedu.ucsb.nceas.dbadapter.AbstractDatabase
edu.ucsb.nceas.dbadapter.OracleAdapter
The Oracle db adapter implementation.
Constructor Summary | |
OracleAdapter()
|
Method Summary | |
java.lang.String |
getDateTimeFunction()
The Oracle's function name that gets the current date and time from the database server: "sysdate" |
java.lang.String |
getIsNULLFunction()
The Oracle's function name that is used to return non-NULL value |
java.lang.String |
getStringDelimiter()
The Oracles's string delimiter character: single quote (') |
long |
getUniqueID(java.sql.Connection conn,
java.lang.String tableName)
The Oracle unique ID generator through use of sequences The name of the sequence used to generate the unique id is made from the name of the table that uses the id by appending "_id_seq" to it. |
Methods inherited from class edu.ucsb.nceas.dbadapter.AbstractDatabase |
createObject, main, toDate |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
public OracleAdapter()
Method Detail |
public long getUniqueID(java.sql.Connection conn, java.lang.String tableName) throws java.sql.SQLException
getUniqueID
in class AbstractDatabase
conn
- db connection in which the unique id was generatedtableName
- the name of table which unique id was generate
java.sql.SQLException
- public java.lang.String getDateTimeFunction()
getDateTimeFunction
in class AbstractDatabase
public java.lang.String getIsNULLFunction()
getIsNULLFunction
in class AbstractDatabase
public java.lang.String getStringDelimiter()
getStringDelimiter
in class AbstractDatabase
|
|||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |