|
||||||||||
| 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.SqlserverAdapter
public class SqlserverAdapter
The MS SQL Server db adapter implementation.
| Constructor Summary | |
|---|---|
SqlserverAdapter()
|
|
| Method Summary | |
|---|---|
java.lang.String |
getDateTimeFunction()
The SQL Server's function name that gets the current date and time from the database server: "getdate()" |
java.lang.String |
getIsNULLFunction()
The SQL Server's function name that is used to return non-NULL value |
java.lang.String |
getLeftJoinQuery(java.lang.String selectFields,
java.lang.String tableA,
java.lang.String tableB,
java.lang.String joinCriteria,
java.lang.String nonJoinCriteria)
MSSQL's syntax for doing a left join Add 'a.' in front of the fields for first table and 'b.' in front of the fields for the second table |
java.lang.String |
getReplicationDocumentListSQL()
Return a hard code string to get xml_document list in timed replcation |
java.lang.String |
getStringDelimiter()
The SQL Server's string delimiter character: single quote (') |
long |
getUniqueID(java.sql.Connection conn,
java.lang.String tableName)
The SQL Server unique ID generator through use of IDENTITY key The IDENTITY key is a column in the table. |
java.lang.String |
toDate(java.lang.String dateString,
java.lang.String format)
MSSQL doesn't support the to_date function, so we transfer text directly. |
| Methods inherited from class edu.ucsb.nceas.dbadapter.AbstractDatabase |
|---|
createObject, main |
| Methods inherited from class java.lang.Object |
|---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
| Constructor Detail |
|---|
public SqlserverAdapter()
| Method Detail |
|---|
public long getUniqueID(java.sql.Connection conn,
java.lang.String tableName)
throws java.sql.SQLException
getUniqueID in class AbstractDatabaseconn - db connection in which to generate the unique idtableName - the name of table which unique id to generate
java.sql.SQLException - public java.lang.String getDateTimeFunction()
getDateTimeFunction in class AbstractDatabasepublic java.lang.String getIsNULLFunction()
getIsNULLFunction in class AbstractDatabasepublic java.lang.String getStringDelimiter()
getStringDelimiter in class AbstractDatabase
public java.lang.String toDate(java.lang.String dateString,
java.lang.String format)
toDate in class AbstractDatabase
public java.lang.String getLeftJoinQuery(java.lang.String selectFields,
java.lang.String tableA,
java.lang.String tableB,
java.lang.String joinCriteria,
java.lang.String nonJoinCriteria)
getLeftJoinQuery in class AbstractDatabaseselectFields - fields that you want to be selectedtableA - first table in the jointableB - second table in the joinjoinCriteria - the criteria based on which the join will be madenonJoinCriteria - all other criterias
public java.lang.String getReplicationDocumentListSQL()
getReplicationDocumentListSQL in class AbstractDatabase
|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||