Constant Field Values

net.sourceforge.*

• net.sourceforge.jtds.jdbc.CharsetInfo 

  Modifier and Type	Constant Field	Value
  private static final java.lang.String	CHARSETS_RESOURCE_NAME	"net/sourceforge/jtds/jdbc/Charsets.properties"

• net.sourceforge.jtds.jdbc.ClobImpl 

  Modifier and Type	Constant Field	Value
  private static final java.lang.String	EMPTY_CLOB	""

• net.sourceforge.jtds.jdbc.DateTime 

  Modifier and Type	Constant Field	Value
  static final int	DATE_NOT_USED	-2147483648
  static final int	TIME_NOT_USED	-2147483648

• net.sourceforge.jtds.jdbc.DefaultProperties 

  Modifier and Type	Constant Field	Value
  public static final java.lang.String	APP_NAME	"jTDS"
  public static final java.lang.String	AUTO_COMMIT	"true"
  public static final java.lang.String	BATCH_SIZE_SQLSERVER	"0"
  public static final java.lang.String	BATCH_SIZE_SYBASE	"1000"
  public static final java.lang.String	BIND_ADDRESS	""
  public static final java.lang.String	BUFFER_MAX_MEMORY	"1024"
  public static final java.lang.String	BUFFER_MIN_PACKETS	"8"
  public static final java.lang.String	CACHEMETA	"false"
  public static final java.lang.String	CHARSET	""
  public static final java.lang.String	DATABASE_NAME	""
  public static final java.lang.String	DOMAIN	""
  public static final java.lang.String	INSTANCE	""
  public static final java.lang.String	LANGUAGE	""
  public static final java.lang.String	LAST_UPDATE_COUNT	"true"
  public static final java.lang.String	LOB_BUFFER_SIZE	"32768"
  public static final java.lang.String	LOGFILE	""
  public static final java.lang.String	LOGIN_TIMEOUT	"0"
  public static final java.lang.String	MAC_ADDRESS	"000000000000"
  public static final java.lang.String	MAX_STATEMENTS	"500"
  public static final java.lang.String	NAMED_PIPE	"false"
  public static final java.lang.String	NAMED_PIPE_PATH_SQLSERVER	"/sql/query"
  public static final java.lang.String	NAMED_PIPE_PATH_SYBASE	"/sybase/query"
  public static final java.lang.String	PACKET_SIZE_50	"0"
  public static final java.lang.String	PACKET_SIZE_70_80	"0"
  public static final java.lang.String	PASSWORD	""
  public static final java.lang.String	PORT_NUMBER_SQLSERVER	"1433"
  public static final java.lang.String	PORT_NUMBER_SYBASE	"7100"
  public static final java.lang.String	PROCESS_ID	"123"
  public static final java.lang.String	PROG_NAME	"jTDS"
  public static final java.lang.String	SERVER_TYPE_SQLSERVER	"sqlserver"
  public static final java.lang.String	SERVER_TYPE_SYBASE	"sybase"
  public static final java.lang.String	SOCKET_KEEPALIVE	"false"
  public static final java.lang.String	SOCKET_TIMEOUT	"0"
  public static final java.lang.String	SSL	"off"
  public static final java.lang.String	TCP_NODELAY	"true"
  public static final java.lang.String	TDS_VERSION_42	"4.2"
  public static final java.lang.String	TDS_VERSION_50	"5.0"
  public static final java.lang.String	TDS_VERSION_70	"7.0"
  public static final java.lang.String	TDS_VERSION_80	"8.0"
  public static final java.lang.String	TDS_VERSION_90	"9.0"
  public static final java.lang.String	USE_UNICODE	"true"
  public static final java.lang.String	USECURSORS	"false"
  public static final java.lang.String	USEJCIFS	"false"
  public static final java.lang.String	USEKERBEROS	"false"
  public static final java.lang.String	USELOBS	"true"
  public static final java.lang.String	USENTLMV2	"false"
  public static final java.lang.String	USER	""
  public static final java.lang.String	WSID	""
  public static final java.lang.String	XAEMULATION	"true"

• net.sourceforge.jtds.jdbc.Driver 

  Modifier and Type	Constant Field	Value
  public static final java.lang.String	APPNAME	"prop.appname"
  public static final java.lang.String	AUTOCOMMIT	"prop.autocommit"
  public static final java.lang.String	BATCHSIZE	"prop.batchsize"
  public static final java.lang.String	BINDADDRESS	"prop.bindaddress"
  public static final java.lang.String	BUFFERDIR	"prop.bufferdir"
  public static final java.lang.String	BUFFERMAXMEMORY	"prop.buffermaxmemory"
  public static final java.lang.String	BUFFERMINPACKETS	"prop.bufferminpackets"
  public static final java.lang.String	CACHEMETA	"prop.cachemetadata"
  public static final java.lang.String	CHARSET	"prop.charset"
  public static final java.lang.String	DATABASENAME	"prop.databasename"
  public static final java.lang.String	DOMAIN	"prop.domain"
  public static final java.lang.String	INSTANCE	"prop.instance"
  public static final java.lang.String	LANGUAGE	"prop.language"
  public static final java.lang.String	LASTUPDATECOUNT	"prop.lastupdatecount"
  public static final java.lang.String	LOBBUFFER	"prop.lobbuffer"
  public static final java.lang.String	LOGFILE	"prop.logfile"
  public static final java.lang.String	LOGINTIMEOUT	"prop.logintimeout"
  public static final java.lang.String	MACADDRESS	"prop.macaddress"
  static final int	MAJOR_VERSION	1
  public static final java.lang.String	MAXSTATEMENTS	"prop.maxstatements"
  static final int	MINOR_VERSION	3
  static final java.lang.String	MISC_VERSION	".1"
  public static final java.lang.String	NAMEDPIPE	"prop.namedpipe"
  public static final java.lang.String	PACKETSIZE	"prop.packetsize"
  public static final java.lang.String	PASSWORD	"prop.password"
  public static final java.lang.String	PORTNUMBER	"prop.portnumber"
  public static final java.lang.String	PREPARESQL	"prop.preparesql"
  public static final java.lang.String	PROCESSID	"prop.processid"
  public static final java.lang.String	PROGNAME	"prop.progname"
  public static final java.lang.String	SENDSTRINGPARAMETERSASUNICODE	"prop.useunicode"
  public static final java.lang.String	SERVERNAME	"prop.servername"
  public static final java.lang.String	SERVERTYPE	"prop.servertype"
  public static final java.lang.String	SOKEEPALIVE	"prop.sokeepalive"
  public static final java.lang.String	SOTIMEOUT	"prop.sotimeout"
  public static final int	SQLSERVER	1
  public static final java.lang.String	SSL	"prop.ssl"
  public static final int	SYBASE	2
  public static final java.lang.String	TCPNODELAY	"prop.tcpnodelay"
  public static final java.lang.String	TDS	"prop.tds"
  public static final int	TDS42	1
  public static final int	TDS50	2
  public static final int	TDS70	3
  public static final int	TDS80	4
  public static final int	TDS81	5
  public static final int	TDS90	6
  public static final java.lang.String	USECURSORS	"prop.usecursors"
  public static final java.lang.String	USEJCIFS	"prop.usejcifs"
  public static final java.lang.String	USEKERBEROS	"prop.usekerberos"
  public static final java.lang.String	USELOBS	"prop.uselobs"
  public static final java.lang.String	USENTLMV2	"prop.usentlmv2"
  public static final java.lang.String	USER	"prop.user"
  public static final java.lang.String	WSID	"prop.wsid"
  public static final java.lang.String	XAEMULATION	"prop.xaemulation"

• net.sourceforge.jtds.jdbc.JtdsConnection 

  Modifier and Type	Constant Field	Value
  private static final java.lang.String	SQL_SERVER_65_CHARSET_QUERY	"select name from master.dbo.syscharsets where id = (select csid from master.dbo.syscharsets, master.dbo.sysconfigures where config=1123 and id = value)"
  private static final java.lang.String	SQL_SERVER_INITIAL_SQL	"SELECT @@MAX_PRECISION\r\nSET TRANSACTION ISOLATION LEVEL READ COMMITTED\r\nSET IMPLICIT_TRANSACTIONS OFF\r\nSET QUOTED_IDENTIFIER ON\r\nSET TEXTSIZE 2147483647"
  private static final java.lang.String	SYBASE_INITIAL_SQL	"SET TRANSACTION ISOLATION LEVEL 1\r\nSET CHAINED OFF\r\nSET QUOTED_IDENTIFIER ON\r\nSET TEXTSIZE 2147483647"
  private static final java.lang.String	SYBASE_SERVER_CHARSET_QUERY	"select name from master.dbo.syscharsets where id = (select value from master.dbo.sysconfigures where config=131)"
  public static final int	TRANSACTION_SNAPSHOT	4096

• net.sourceforge.jtds.jdbc.JtdsDatabaseMetaData 

  Modifier and Type	Constant Field	Value
  static final int	sqlStateXOpen	1

• net.sourceforge.jtds.jdbc.JtdsResultSet 

  Modifier and Type	Constant Field	Value
  static final int	CLOSE_CURSORS_AT_COMMIT	2
  static final int	HOLD_CURSORS_OVER_COMMIT	1
  protected static final int	INITIAL_ROW_COUNT	1000
  protected static final int	POS_AFTER_LAST	-1
  protected static final int	POS_BEFORE_FIRST	0

• net.sourceforge.jtds.jdbc.JtdsStatement 

  Modifier and Type	Constant Field	Value
  static final int	BOOLEAN	16
  static final int	CLOSE_ALL_RESULTS	3
  static final int	CLOSE_CURRENT_RESULT	1
  static final int	DATALINK	70
  static final int	DEFAULT_FETCH_SIZE	100
  static final java.lang.String	GENKEYCOL	"_JTDS_GENE_R_ATED_KEYS_"
  static final int	KEEP_CURRENT_RESULT	2
  static final int	NO_GENERATED_KEYS	2
  static final int	RETURN_GENERATED_KEYS	1

• net.sourceforge.jtds.jdbc.Messages 

  Modifier and Type	Constant Field	Value
  private static final java.lang.String	DEFAULT_RESOURCE	"net.sourceforge.jtds.jdbc.Messages"

• net.sourceforge.jtds.jdbc.MSCursorResultSet 

  Modifier and Type	Constant Field	Value
  private static final int	CURSOR_CONCUR_OPTIMISTIC	4
  private static final int	CURSOR_CONCUR_OPTIMISTIC_VALUES	8
  private static final int	CURSOR_CONCUR_READ_ONLY	1
  private static final int	CURSOR_CONCUR_SCROLL_LOCKS	2
  private static final int	CURSOR_TYPE_AUTO_FETCH	8192
  private static final int	CURSOR_TYPE_DYNAMIC	2
  private static final int	CURSOR_TYPE_FASTFORWARDONLY	16
  private static final int	CURSOR_TYPE_FORWARD	4
  private static final int	CURSOR_TYPE_KEYSET	1
  private static final int	CURSOR_TYPE_PARAMETERIZED	4096
  private static final int	CURSOR_TYPE_STATIC	8

• net.sourceforge.jtds.jdbc.MSSqlServerInfo 

  Modifier and Type	Constant Field	Value
  private final int	numRetries	3
  private final int	timeout	2000

• net.sourceforge.jtds.jdbc.net.sourceforge.jtds.jdbc.ParamInfo 

  Modifier and Type	Constant Field	Value
  static final int	INPUT	0
  static final int	OUTPUT	1
  static final int	RETVAL	2
  static final int	UNICODE	4

• net.sourceforge.jtds.jdbc.ProcEntry 

  Modifier and Type	Constant Field	Value
  public static final int	CURSOR	3
  public static final int	PREP_FAILED	4
  public static final int	PREPARE	2
  public static final int	PROCEDURE	1

• net.sourceforge.jtds.jdbc.net.sourceforge.jtds.jdbc.SharedSocket 

  Modifier and Type	Constant Field	Value
  private static final int	TDS_DONE_LEN	9
  private static final int	TDS_DONE_TOKEN	253
  private static final int	TDS_HDR_LEN	8

• net.sourceforge.jtds.jdbc.TdsCore 

  Modifier and Type	Constant Field	Value
  private static final byte	ALTMETADATA_TOKEN	-120
  private static final int	ASYNC_CANCEL	0
  public static final byte	CANCEL_PKT	6
  public static final int	DEFAULT_MIN_PKT_SIZE_TDS70	4096
  static final byte	DONE_CANCEL	32
  private static final byte	DONE_END_OF_RESPONSE	-128
  private static final byte	DONE_ERROR	2
  private static final byte	DONE_MORE_RESULTS	1
  private static final byte	DONE_ROW_COUNT	16
  public static final int	EXECUTE_SQL	2
  public static final byte	LOGIN_PKT	2
  public static final int	MAX_PKT_SIZE	32768
  public static final int	MIN_PKT_SIZE	512
  public static final byte	MSDTC_PKT	14
  public static final byte	MSLOGIN_PKT	16
  public static final byte	NTLMAUTH_PKT	17
  public static final int	PKT_HDR_LEN	8
  public static final byte	PRELOGIN_PKT	18
  public static final int	PREPARE	3
  public static final byte	QUERY_PKT	1
  public static final byte	REPLY_PKT	4
  public static final byte	RPC_PKT	3
  public static final int	SSL_CLIENT_FORCE_ENCRYPT	1
  public static final int	SSL_ENCRYPT_LOGIN	0
  public static final int	SSL_NO_ENCRYPT	2
  public static final int	SSL_SERVER_FORCE_ENCRYPT	3
  static final int	SYB_BIGINT	64
  static final int	SYB_BITNULL	4
  static final int	SYB_DATETIME	2
  static final int	SYB_EXTCOLINFO	8
  static final int	SYB_LONGDATA	1
  static final int	SYB_UNICODE	16
  static final int	SYB_UNITEXT	32
  public static final byte	SYBQUERY_PKT	15
  private static final byte	TDS_ALTROW	-45
  private static final byte	TDS_AUTH_TOKEN	-19
  private static final byte	TDS_CAP_TOKEN	-30
  private static final byte	TDS_CLOSE_TOKEN	113
  private static final byte	TDS_COLFMT_TOKEN	-95
  private static final byte	TDS_COLINFO_TOKEN	-91
  private static final byte	TDS_COLNAME_TOKEN	-96
  private static final byte	TDS_COMP_NAMES_TOKEN	-89
  private static final byte	TDS_COMP_RESULT_TOKEN	-88
  private static final byte	TDS_CONTROL_TOKEN	-82
  private static final byte	TDS_DBRPC_TOKEN	-26
  private static final byte	TDS_DONE_TOKEN	-3
  private static final byte	TDS_DONEINPROC_TOKEN	-1
  private static final byte	TDS_DONEPROC_TOKEN	-2
  private static final byte	TDS_ENV_CHARSET	3
  private static final byte	TDS_ENV_DATABASE	1
  private static final byte	TDS_ENV_LANG	2
  private static final byte	TDS_ENV_LCID	5
  private static final byte	TDS_ENV_PACKSIZE	4
  private static final byte	TDS_ENV_SQLCOLLATION	7
  private static final byte	TDS_ENVCHANGE_TOKEN	-29
  private static final byte	TDS_ERROR_TOKEN	-86
  private static final byte	TDS_INFO_TOKEN	-85
  private static final byte	TDS_LANG_TOKEN	33
  private static final byte	TDS_LOGINACK_TOKEN	-83
  private static final byte	TDS_MSG50_TOKEN	-27
  private static final byte	TDS_OFFSETS_TOKEN	120
  private static final byte	TDS_ORDER_TOKEN	-87
  private static final byte	TDS_PARAM_TOKEN	-84
  private static final byte	TDS_PROCID	124
  private static final byte	TDS_RESULT_TOKEN	-18
  private static final byte	TDS_RETURNSTATUS_TOKEN	121
  private static final byte	TDS_ROW_TOKEN	-47
  private static final byte	TDS_TABNAME_TOKEN	-92
  private static final byte	TDS5_DYNAMIC_TOKEN	-25
  private static final byte	TDS5_PARAMFMT_TOKEN	-20
  private static final byte	TDS5_PARAMFMT2_TOKEN	32
  private static final byte	TDS5_PARAMS_TOKEN	-41
  private static final byte	TDS5_WIDE_RESULT	97
  private static final byte	TDS7_RESULT_TOKEN	-127
  public static final int	TEMPORARY_STORED_PROCEDURES	1
  private static final int	TIMEOUT_CANCEL	1
  public static final int	UNPREPARED	0

• net.sourceforge.jtds.jdbc.TdsData 

  Modifier and Type	Constant Field	Value
  private static final int	DATEN	40
  private static final int	DATETIME2N	42
  private static final int	DATETIMEOFFSETN	43
  static final int	DEFAULT_PRECISION_28	28
  static final int	DEFAULT_PRECISION_38	38
  static final int	DEFAULT_SCALE	10
  private static final int	MS_LONGVAR_MAX	8000
  private static final int	SYB_CHUNK_SIZE	8192
  private static final int	SYB_LONGVAR_MAX	16384
  private static final int	SYBBINARY	45
  private static final int	SYBBIT	50
  private static final int	SYBBITN	104
  private static final int	SYBCHAR	47
  private static final int	SYBDATE	49
  private static final int	SYBDATEN	123
  private static final int	SYBDATETIME	61
  private static final int	SYBDATETIME4	58
  private static final int	SYBDATETIMN	111
  private static final int	SYBDECIMAL	106
  private static final int	SYBFLT8	62
  private static final int	SYBFLTN	109
  private static final int	SYBIMAGE	34
  private static final int	SYBINT1	48
  private static final int	SYBINT2	52
  private static final int	SYBINT4	56
  private static final int	SYBINT8	127
  private static final int	SYBINTN	38
  private static final int	SYBLONGBINARY	225
  static final int	SYBLONGDATA	36
  private static final int	SYBMONEY	60
  private static final int	SYBMONEY4	122
  private static final int	SYBMONEYN	110
  private static final int	SYBNTEXT	99
  private static final int	SYBNUMERIC	108
  private static final int	SYBNVARCHAR	103
  private static final int	SYBREAL	59
  private static final int	SYBSINT1	64
  private static final int	SYBSINT8	191
  private static final int	SYBTEXT	35
  private static final int	SYBTIME	51
  private static final int	SYBTIMEN	147
  private static final int	SYBUINT2	65
  private static final int	SYBUINT4	66
  private static final int	SYBUINT8	67
  private static final int	SYBUINTN	68
  private static final int	SYBUNIQUE	36
  private static final int	SYBUNITEXT	174
  private static final int	SYBVARBINARY	37
  private static final int	SYBVARCHAR	39
  private static final int	SYBVARIANT	98
  private static final int	SYBVOID	31
  private static final int	TIMEN	41
  private static final int	UDT_BINARY	3
  private static final int	UDT_CHAR	1
  private static final int	UDT_LONGSYSNAME	42
  private static final int	UDT_NCHAR	24
  private static final int	UDT_NEWSYSNAME	256
  private static final int	UDT_NVARCHAR	25
  private static final int	UDT_SYSNAME	18
  private static final int	UDT_TIMESTAMP	80
  private static final int	UDT_UNICHAR	34
  private static final int	UDT_UNITEXT	36
  private static final int	UDT_UNIVARCHAR	35
  private static final int	UDT_VARBINARY	4
  private static final int	UDT_VARCHAR	2
  private static final int	VAR_MAX	255
  private static final int	XML	241
  private static final int	XSYBBINARY	173
  private static final int	XSYBCHAR	175
  private static final int	XSYBNCHAR	239
  private static final int	XSYBNVARCHAR	231
  private static final int	XSYBVARBINARY	165
  private static final int	XSYBVARCHAR	167

• net.sourceforge.jtds.jdbc.TypeInfo 

  Modifier and Type	Constant Field	Value
  static final int	NUM_COLS	18

• net.sourceforge.jtds.jdbc.XASupport 

  Modifier and Type	Constant Field	Value
  private static final java.lang.String	TM_ID	"TM=JTDS,RmRecoveryGuid=434CDE1A-F747-4942-9584-04937455CAB4"
  private static final int	XA_CLOSE	2
  private static final int	XA_COMMIT	7
  private static final int	XA_COMPLETE	10
  private static final int	XA_END	4
  private static final int	XA_FORGET	9
  private static final int	XA_OPEN	1
  private static final int	XA_PREPARE	6
  private static final int	XA_RECOVER	8
  private static final int	XA_RMID	1
  private static final int	XA_ROLLBACK	5
  private static final int	XA_START	3
  private static final int	XA_TRACE	0

• net.sourceforge.jtds.jdbc.cache.ProcedureCache 

  Modifier and Type	Constant Field	Value
  private static final int	MAX_INITIAL_SIZE	50

• net.sourceforge.jtds.jdbcx.JtdsDataSource 

  Modifier and Type	Constant Field	Value
  static final java.lang.String	DESCRIPTION	"description"
  static final long	serialVersionUID	266241L

• net.sourceforge.jtds.jdbcx.JtdsXid 

  Modifier and Type	Constant Field	Value
  public static final int	XID_SIZE	140

• net.sourceforge.jtds.ssl.Ssl 

  Modifier and Type	Constant Field	Value
  public static final int	HS_HEADER_SIZE	4
  public static final java.lang.String	SSL_AUTHENTICATE	"authenticate"
  public static final java.lang.String	SSL_OFF	"off"
  public static final java.lang.String	SSL_REQUEST	"request"
  public static final java.lang.String	SSL_REQUIRE	"require"
  public static final int	TLS_HEADER_SIZE	5
  public static final byte	TYPE_ALERT	21
  public static final byte	TYPE_APPLICATIONDATA	23
  public static final byte	TYPE_CHANGECIPHERSPEC	20
  public static final int	TYPE_CLIENTHELLO	1
  public static final int	TYPE_CLIENTKEYEXCHANGE	16
  public static final byte	TYPE_HANDSHAKE	22

• net.sourceforge.jtds.util.BlobBuffer 

  Modifier and Type	Constant Field	Value
  private static final int	BYTE_MASK	1023
  private static final int	INVALID_PAGE	-1
  private static final int	MAX_BUF_INC	16384
  private static final int	PAGE_MASK	-1024
  private static final int	PAGE_SIZE	1024

• net.sourceforge.jtds.util.DESEngine 

  Modifier and Type	Constant Field	Value
  protected static final int	BLOCK_SIZE	8

• net.sourceforge.jtds.util.MD4Digest 

  Modifier and Type	Constant Field	Value
  private static final int	DIGEST_LENGTH	16
  private static final int	S11	3
  private static final int	S12	7
  private static final int	S13	11
  private static final int	S14	19
  private static final int	S21	3
  private static final int	S22	5
  private static final int	S23	9
  private static final int	S24	13
  private static final int	S31	3
  private static final int	S32	9
  private static final int	S33	11
  private static final int	S34	15

• net.sourceforge.jtds.util.MD5Digest 

  Modifier and Type	Constant Field	Value
  private static final int	DIGEST_LENGTH	16