Package edu.ucsb.nceas.dbadapter

Class SqlserverAdapter

java.lang.Object

edu.ucsb.nceas.dbadapter.AbstractDatabase

edu.ucsb.nceas.dbadapter.SqlserverAdapter

public class SqlserverAdapter
extends AbstractDatabase

The MS SQL Server db adapter implementation.

Constructor Summary

Constructors

Constructor	Description
SqlserverAdapter()

Method Summary

Modifier and Type	Method	Description
String	getDateTimeFunction()	The SQL Server's function name that gets the current date and time from the database server: "getdate()"
String	getIsNULLFunction()	The SQL Server's function name that is used to return non-NULL value
String	getLeftJoinQuery(String selectFields, String tableA, String tableB, String joinCriteria, 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
String	getPagedQuery(String queryFieldsWithOrderBy, Integer start, Integer count)	for generating a query for paging
String	getReplicationDocumentListSQL()	Return a hard code string to get xml_document list in timed replcation
String	getStringDelimiter()	The SQL Server's string delimiter character: single quote (')
long	getUniqueID(Connection conn, String tableName)	The SQL Server unique ID generator through use of IDENTITY key The IDENTITY key is a column in the table.
String	toDate(String dateString, 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 Details

SqlserverAdapter

public SqlserverAdapter()

Method Details

getUniqueID

public long getUniqueID(Connection conn,
 String tableName)
                 throws SQLException

The SQL Server unique ID generator through use of IDENTITY key The IDENTITY key is a column in the table. When record is inserted in the table, SELECT @@IDENTITY can return the key generated in that IDENTITY column in the same db connection. This is the only way to get unique id: let the SQL Server assign a value in IDENTITY column and get it afterwards for use in the application.

Specified by:

getUniqueID in class AbstractDatabase

Parameters:

conn - db connection in which to generate the unique id

tableName - the name of table which unique id to generate

Returns:

return the generated unique id as a long type

Throws:

SQLException -
any SQLException that can be thrown during the db operation

getDateTimeFunction

public String getDateTimeFunction()

The SQL Server's function name that gets the current date and time from the database server: "getdate()"

Specified by:

getDateTimeFunction in class AbstractDatabase

Returns:

return the current date and time function name: "getdate()"

getIsNULLFunction

public String getIsNULLFunction()

The SQL Server's function name that is used to return non-NULL value

Specified by:

getIsNULLFunction in class AbstractDatabase

Returns:

return the non-NULL function name: "isnull"

getStringDelimiter

public String getStringDelimiter()

The SQL Server's string delimiter character: single quote (')

Specified by:

getStringDelimiter in class AbstractDatabase

Returns:

return the string delimiter: single quote (')

toDate

public String toDate(String dateString,
 String format)

MSSQL doesn't support the to_date function, so we transfer text directly. This method will overwrite the method in AbstarctDatabase class

Overrides:

toDate in class AbstractDatabase

getLeftJoinQuery

public String getLeftJoinQuery(String selectFields,
 String tableA,
 String tableB,
 String joinCriteria,
 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

Specified by:

getLeftJoinQuery in class AbstractDatabase

Parameters:

selectFields - fields that you want to be selected

tableA - first table in the join

tableB - second table in the join

joinCriteria - the criteria based on which the join will be made

nonJoinCriteria - all other criterias

Returns:

return the string for teh select query

getReplicationDocumentListSQL

public String getReplicationDocumentListSQL()

Return a hard code string to get xml_document list in timed replcation

Specified by:

getReplicationDocumentListSQL in class AbstractDatabase

Returns:

getPagedQuery

public String getPagedQuery(String queryFieldsWithOrderBy,
 Integer start,
 Integer count)

Description copied from class: AbstractDatabase

for generating a query for paging

Specified by:

getPagedQuery in class AbstractDatabase

Parameters:

queryFieldsWithOrderBy - - the complete query with SELECT, FROM, WHERE and ORDER BY clauses

start - the row number to start from

count - the number of records from start to return

Returns:

query specific to the RDBMS in use