Package com.illumon.iris.pqimport.gui.jdbc

Class SqlServerDriverWrapper

java.lang.Object

com.illumon.iris.pqimport.gui.jdbc.SqlServerDriverWrapper

All Implemented Interfaces:

com.illumon.iris.jdbc.IDriverWrapper

public class SqlServerDriverWrapper
extends Object
implements com.illumon.iris.jdbc.IDriverWrapper

Nested Class Summary

Nested classes/interfaces inherited from interface com.illumon.iris.jdbc.IDriverWrapper

com.illumon.iris.jdbc.IDriverWrapper.DisplayInfo, com.illumon.iris.jdbc.IDriverWrapper.DriverWrapperException, com.illumon.iris.jdbc.IDriverWrapper.Factory

Field Summary

Fields

Modifier and Type	Field	Description
static final String	CATALOG_NAME
static final String	DEFAULT_URL
static final String	DRIVER_CLASS
static final String	FRIENDLY_NAME

Constructor Summary

Constructors

Constructor	Description
SqlServerDriverWrapper(com.fishlib.io.logger.Logger log)

Method Summary

Modifier and Type	Method	Description
String	catalogName()
String	defaultUrl()
String	driverClass()
String	friendlyName()
String[]	getCatalogNames(Connection connection)
TimeZone	getServerTimeZone(Connection connection)
String[]	getTableNames(Connection connection, String catalogName)
boolean	hasScrollableCursors()
boolean	isValidUrl(String url)
String	quoteEscapeColumnName(String columnName)	Quote and escape a column name in accordance with SQL Server, for use in a query.
String	quoteEscapeTableName(String schemaName, String tableName)	Quote and escape a table name in accordance with SQL Server convention, for use in a query.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface com.illumon.iris.jdbc.IDriverWrapper

displayInfo, load

Field Details

FRIENDLY_NAME

public static final String FRIENDLY_NAME

See Also:

• Constant Field Values

CATALOG_NAME

public static final String CATALOG_NAME

See Also:

• Constant Field Values

DEFAULT_URL

public static final String DEFAULT_URL

See Also:

• Constant Field Values

DRIVER_CLASS

public static final String DRIVER_CLASS

See Also:

• Constant Field Values

Constructor Details

SqlServerDriverWrapper

public SqlServerDriverWrapper(com.fishlib.io.logger.Logger log)

Method Details

friendlyName

public String friendlyName()

Specified by:

friendlyName in interface com.illumon.iris.jdbc.IDriverWrapper

catalogName

public String catalogName()

Specified by:

catalogName in interface com.illumon.iris.jdbc.IDriverWrapper

defaultUrl

public String defaultUrl()

Specified by:

defaultUrl in interface com.illumon.iris.jdbc.IDriverWrapper

driverClass

public String driverClass()

Specified by:

driverClass in interface com.illumon.iris.jdbc.IDriverWrapper

isValidUrl

public boolean isValidUrl(String url)

Specified by:

isValidUrl in interface com.illumon.iris.jdbc.IDriverWrapper

hasScrollableCursors

public boolean hasScrollableCursors()

Specified by:

hasScrollableCursors in interface com.illumon.iris.jdbc.IDriverWrapper

getCatalogNames

public String[] getCatalogNames(Connection connection)
                         throws SQLException

Specified by:

getCatalogNames in interface com.illumon.iris.jdbc.IDriverWrapper

Throws:

SQLException

getTableNames

public String[] getTableNames(Connection connection,
 String catalogName)
                       throws SQLException

Specified by:

getTableNames in interface com.illumon.iris.jdbc.IDriverWrapper

Throws:

SQLException

getServerTimeZone

public TimeZone getServerTimeZone(Connection connection)
                           throws SQLException

Specified by:

getServerTimeZone in interface com.illumon.iris.jdbc.IDriverWrapper

Throws:

SQLException

quoteEscapeTableName

public String quoteEscapeTableName(String schemaName,
 String tableName)

Quote and escape a table name in accordance with SQL Server convention, for use in a query. This quotes the given schema (if given) and table name with square brackets escapes embedded closing brackets appropriately.

Specified by:

quoteEscapeTableName in interface com.illumon.iris.jdbc.IDriverWrapper

Parameters:

schemaName - the raw unquoted, unescaped schema name

tableName - the raw unquoted, unescaped table name

Returns:

the quoted, escaped table name

quoteEscapeColumnName

public String quoteEscapeColumnName(String columnName)

Quote and escape a column name in accordance with SQL Server, for use in a query. This quotes the column name with square brackets escapes embedded closing brackets appropriately.

Specified by:

quoteEscapeColumnName in interface com.illumon.iris.jdbc.IDriverWrapper

Parameters:

columnName - the raw unquoted, unescaped column name

Returns:

the quoted, escaped column name