Package net.sourceforge.jtds.jdbc
Class DefaultProperties
java.lang.Object
net.sourceforge.jtds.jdbc.DefaultProperties
Container for default property constants.
This class also provides static utility methods for
Properties and Settings objects.
To add new properties to the jTDS driver, do the following:
- Add
prop.fooandprop.desc.fooproperties toMessages.properties. - Add a
static finaldefault field toDefaultProperties. - Update
addDefaultProperties(java.util.Properties)to set the default. - Update
Driver.createChoicesMap()andDriverUnitTest.test_getPropertyInfo_Choices()if the property has a specific set of inputs, e.g., "true" and "false", or "1" and "2". - Update
Driver.createRequiredTrueMap()andDriverUnitTest.test_getPropertyInfo_Required()if the property is required. - Add a new test to
DefaultPropertiesTestLibraryfor the new property.
- Version:
- $Id: DefaultProperties.java,v 1.32.2.1 2009-08-07 14:02:09 ickzon Exp $
- Author:
- David D. Kilzer
-
Field Summary
FieldsModifier and TypeFieldDescriptionstatic final StringDefaultappNameproperty.static final StringDefaultautoCommitproperty.static final StringDefaultbatchSizeproperty for SQL Server.static final StringDefaultbatchSizeproperty for Sybase.private static final HashMapDefault max batch size based on server typestatic final StringDefaultbindAddressproperty.static final StringDefaulttmpDirproperty.static final StringDefaultbufferMaxMemoryproperty.static final StringDefaultbufferMinPacketsproperty.static final StringDefaultcacheMetaDataproperty.static final StringDefaultcharsetproperty.static final StringDefaultdatabaseNameproperty.static final StringDefaultdomainproperty.static final StringDefaultinstanceproperty.static final StringDefaultlanguageproperty.static final StringDefaultlastUpdateCountproperty.static final StringDefaultlobBufferSizeproperty.static final StringDefaultlogfileproperty.static final StringDefaultloginTimeoutproperty.static final StringDefaultmacAddressproperty.static final StringDefaultmaxStatementsproperty.static final StringDefaultnamedPipeproperty.static final StringDefaultnamedPipePathproperty for SQL Server.static final StringDefaultnamedPipePathproperty for Sybase.static final StringDefaultpacketSizeproperty for TDS 4.2.static final StringDefaultpacketSizeproperty for TDS 5.0.static final StringDefaultpacketSizeproperty for TDS 7.0 and TDS 8.0.private static final HashMapDefault packet size based on TDS versionstatic final StringDefaultpasswordproperty.static final StringDefaultportNumberproperty for SQL Server.static final StringDefaultportNumberproperty for Sybase.private static final HashMapDefault port number based on server typestatic final StringDefaultprepareSqlproperty for SQL Server.static final StringDefaultprepareSqlproperty for Sybase.private static final HashMapDefault prepare SQL mode based on server typestatic final StringDefaultprocessIdproperty.static final StringDefaultprogNameproperty.static final StringDefaultserverTypeproperty for SQL Server.static final StringDefaultserverTypeproperty for Sybase.static final StringDefaultsocketKeepAliveproperty.static final StringDefaultsockeTimeoutproperty.static final StringDefaultsslproperty.static final StringDefaulttcpNoDelayproperty.static final StringDefaulttdsproperty for TDS 4.2.static final StringDefaulttdsproperty for TDS 5.0.static final StringDefaulttdsproperty for TDS 7.0.static final StringDefaulttdsproperty for TDS 8.0.static final StringDefaulttdsproperty for TDS 9.0.private static final HashMapDefault TDS version based on server typestatic final StringDefaultsendStringParametersAsUnicodeproperty.static final StringDefaultuseCursorsproperty.static final StringDefaultuseJCIFSproperty.static final StringDefaultuseKerberosproperty.static final StringDefaultuseLOBsproperty.static final StringDefaultuseNTLMv2property.static final StringDefaultuserproperty.static final StringDefaultwsidproperty.static final StringDefaultXaEmulationproperty. -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionstatic PropertiesaddDefaultProperties(Properties props) Add default properties to thepropsproperties object.private static voidaddDefaultPropertyIfNotSet(Properties props, String key, String defaultValue) Sets a default property if the property is not already set.private static voidaddDefaultPropertyIfNotSet(Properties props, String key, String defaultKey, Map defaults) Sets a default property if the property is not already set, using thedefaultKeyand thedefaultsmap to determine the correct value.static StringgetNamedPipePath(int serverType) Returns the default path for the named pipe for a given serverType.static StringgetServerType(int serverType) Converts an integer server type to its string representation.static IntegergetServerType(String serverType) Converts a string server type to its integer representation.static StringgetServerTypeWithDefault(int serverType) Same asgetServerType(int), only it returns the default server type ("sqlserver") ifserverTypeis 0.static IntegergetTdsVersion(String tdsVersion) Converts a string TDS version to its integer representation.
-
Field Details
-
APP_NAME
DefaultappNameproperty.- See Also:
-
AUTO_COMMIT
DefaultautoCommitproperty.- See Also:
-
BATCH_SIZE_SQLSERVER
DefaultbatchSizeproperty for SQL Server.- See Also:
-
BATCH_SIZE_SYBASE
DefaultbatchSizeproperty for Sybase.- See Also:
-
BIND_ADDRESS
DefaultbindAddressproperty.- See Also:
-
BUFFER_MAX_MEMORY
DefaultbufferMaxMemoryproperty.- See Also:
-
BUFFER_MIN_PACKETS
DefaultbufferMinPacketsproperty.- See Also:
-
CACHEMETA
DefaultcacheMetaDataproperty.- See Also:
-
CHARSET
Defaultcharsetproperty.- See Also:
-
DATABASE_NAME
DefaultdatabaseNameproperty.- See Also:
-
INSTANCE
Defaultinstanceproperty.- See Also:
-
DOMAIN
Defaultdomainproperty.- See Also:
-
LAST_UPDATE_COUNT
DefaultlastUpdateCountproperty.- See Also:
-
LOB_BUFFER_SIZE
DefaultlobBufferSizeproperty.- See Also:
-
LOGIN_TIMEOUT
DefaultloginTimeoutproperty.- See Also:
-
MAC_ADDRESS
DefaultmacAddressproperty.- See Also:
-
MAX_STATEMENTS
DefaultmaxStatementsproperty.- See Also:
-
NAMED_PIPE
DefaultnamedPipeproperty.- See Also:
-
NAMED_PIPE_PATH_SQLSERVER
DefaultnamedPipePathproperty for SQL Server.- See Also:
-
NAMED_PIPE_PATH_SYBASE
DefaultnamedPipePathproperty for Sybase.- See Also:
-
PACKET_SIZE_42
DefaultpacketSizeproperty for TDS 4.2. -
PACKET_SIZE_50
DefaultpacketSizeproperty for TDS 5.0.- See Also:
-
PACKET_SIZE_70_80
DefaultpacketSizeproperty for TDS 7.0 and TDS 8.0.- See Also:
-
PASSWORD
Defaultpasswordproperty.- See Also:
-
PORT_NUMBER_SQLSERVER
DefaultportNumberproperty for SQL Server.- See Also:
-
PORT_NUMBER_SYBASE
DefaultportNumberproperty for Sybase.- See Also:
-
LANGUAGE
Defaultlanguageproperty.- See Also:
-
PREPARE_SQLSERVER
DefaultprepareSqlproperty for SQL Server. -
PREPARE_SYBASE
DefaultprepareSqlproperty for Sybase. -
PROG_NAME
DefaultprogNameproperty.- See Also:
-
TCP_NODELAY
DefaulttcpNoDelayproperty.- See Also:
-
BUFFER_DIR
DefaulttmpDirproperty. -
USE_UNICODE
DefaultsendStringParametersAsUnicodeproperty.- See Also:
-
USECURSORS
DefaultuseCursorsproperty.- See Also:
-
USEJCIFS
DefaultuseJCIFSproperty.- See Also:
-
USELOBS
DefaultuseLOBsproperty.- See Also:
-
USENTLMV2
DefaultuseNTLMv2property.- See Also:
-
USEKERBEROS
DefaultuseKerberosproperty.- See Also:
-
USER
Defaultuserproperty.- See Also:
-
WSID
Defaultwsidproperty.- See Also:
-
XAEMULATION
DefaultXaEmulationproperty.- See Also:
-
LOGFILE
Defaultlogfileproperty.- See Also:
-
SOCKET_TIMEOUT
DefaultsockeTimeoutproperty.- See Also:
-
SOCKET_KEEPALIVE
DefaultsocketKeepAliveproperty.- See Also:
-
PROCESS_ID
DefaultprocessIdproperty.- See Also:
-
SERVER_TYPE_SQLSERVER
DefaultserverTypeproperty for SQL Server.- See Also:
-
SERVER_TYPE_SYBASE
DefaultserverTypeproperty for Sybase.- See Also:
-
TDS_VERSION_42
Defaulttdsproperty for TDS 4.2.- See Also:
-
TDS_VERSION_50
Defaulttdsproperty for TDS 5.0.- See Also:
-
TDS_VERSION_70
Defaulttdsproperty for TDS 7.0.- See Also:
-
TDS_VERSION_80
Defaulttdsproperty for TDS 8.0.- See Also:
-
TDS_VERSION_90
Defaulttdsproperty for TDS 9.0.- See Also:
-
SSL
Defaultsslproperty.- See Also:
-
tdsDefaults
Default TDS version based on server type -
portNumberDefaults
Default port number based on server type -
packetSizeDefaults
Default packet size based on TDS version -
batchSizeDefaults
Default max batch size based on server type -
prepareSQLDefaults
Default prepare SQL mode based on server type
-
-
Constructor Details
-
DefaultProperties
public DefaultProperties()
-
-
Method Details
-
addDefaultProperties
Add default properties to thepropsproperties object.- Parameters:
props- The properties object.- Returns:
- The updated
propsobject, ornullif theserverTypeproperty is not set.
-
addDefaultPropertyIfNotSet
Sets a default property if the property is not already set.- Parameters:
props- The properties object.key- The message key to set.defaultValue- The default value to set.
-
addDefaultPropertyIfNotSet
private static void addDefaultPropertyIfNotSet(Properties props, String key, String defaultKey, Map defaults) Sets a default property if the property is not already set, using thedefaultKeyand thedefaultsmap to determine the correct value.- Parameters:
props- The properties object.key- The message key to set.defaultKey- The key whose value determines which default value to set fromdefaults.defaults- The mapping ofdefaultKeyvalues to the correctkeyvalue to set.
-
getNamedPipePath
Returns the default path for the named pipe for a given serverType.- Parameters:
serverType-Driver.SQLSERVERorDriver.SYBASEor0(default)- Returns:
- default named pipe path
- Throws:
IllegalArgumentException- if an invalid serverType is given
-
getServerType
Converts an integer server type to its string representation.- Parameters:
serverType- the server type as anint- Returns:
- the server type as a string if known, or
nullif unknown
-
getServerType
Converts a string server type to its integer representation.- Parameters:
serverType- the server type as a string- Returns:
- the server type as an integer if known or
nullif unknown
-
getServerTypeWithDefault
Same asgetServerType(int), only it returns the default server type ("sqlserver") ifserverTypeis 0.- Parameters:
serverType- integer server type or 0 for default- Returns:
- the server type as a string if known or
"sqlserver"if unknown
-
getTdsVersion
Converts a string TDS version to its integer representation.- Parameters:
tdsVersion- The TDS version as a string.- Returns:
- The TDS version as an integer if known, or
nullif unknown.
-