Constant Field Values

net.sourceforge.*

• net.sourceforge.jtds.jdbc.CharsetInfo
  Modifier and Type

  Constant Field

  Value

  private static final String

  CHARSETS_RESOURCE_NAME

  "net/sourceforge/jtds/jdbc/Charsets.properties"
• net.sourceforge.jtds.jdbc.ClobImpl
  Modifier and Type

  Constant Field

  Value

  private static final 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 String

  APP_NAME

  "jTDS"

  public static final String

  AUTO_COMMIT

  "true"

  public static final String

  BATCH_SIZE_SQLSERVER

  "0"

  public static final String

  BATCH_SIZE_SYBASE

  "1000"

  public static final String

  BIND_ADDRESS

  ""

  public static final String

  BUFFER_MAX_MEMORY

  "1024"

  public static final String

  BUFFER_MIN_PACKETS

  "8"

  public static final String

  CACHEMETA

  "false"

  public static final String

  CHARSET

  ""

  public static final String

  DATABASE_NAME

  ""

  public static final String

  DOMAIN

  ""

  public static final String

  INSTANCE

  ""

  public static final String

  LANGUAGE

  ""

  public static final String

  LAST_UPDATE_COUNT

  "true"

  public static final String

  LOB_BUFFER_SIZE

  "32768"

  public static final String

  LOGFILE

  ""

  public static final String

  LOGIN_TIMEOUT

  "0"

  public static final String

  MAC_ADDRESS

  "000000000000"

  public static final String

  MAX_STATEMENTS

  "500"

  public static final String

  NAMED_PIPE

  "false"

  public static final String

  NAMED_PIPE_PATH_SQLSERVER

  "/sql/query"

  public static final String

  NAMED_PIPE_PATH_SYBASE

  "/sybase/query"

  public static final String

  PACKET_SIZE_50

  "0"

  public static final String

  PACKET_SIZE_70_80

  "0"

  public static final String

  PASSWORD

  ""

  public static final String

  PORT_NUMBER_SQLSERVER

  "1433"

  public static final String

  PORT_NUMBER_SYBASE

  "7100"

  public static final String

  PROCESS_ID

  "123"

  public static final String

  PROG_NAME

  "jTDS"

  public static final String

  SERVER_TYPE_SQLSERVER

  "sqlserver"

  public static final String

  SERVER_TYPE_SYBASE

  "sybase"

  public static final String

  SOCKET_KEEPALIVE

  "false"

  public static final String

  SOCKET_TIMEOUT

  "0"

  public static final String

  SSL

  "off"

  public static final String

  TCP_NODELAY

  "true"

  public static final String

  TDS_VERSION_42

  "4.2"

  public static final String

  TDS_VERSION_50

  "5.0"

  public static final String

  TDS_VERSION_70

  "7.0"

  public static final String

  TDS_VERSION_80

  "8.0"

  public static final String

  TDS_VERSION_90

  "9.0"

  public static final String

  USE_UNICODE

  "true"

  public static final String

  USECURSORS

  "false"

  public static final String

  USEJCIFS

  "false"

  public static final String

  USEKERBEROS

  "false"

  public static final String

  USELOBS

  "true"

  public static final String

  USENTLMV2

  "false"

  public static final String

  USER

  ""

  public static final String

  WSID

  ""

  public static final String

  XAEMULATION

  "true"
• net.sourceforge.jtds.jdbc.Driver
  Modifier and Type

  Constant Field

  Value

  public static final String

  APPNAME

  "prop.appname"

  public static final String

  AUTOCOMMIT

  "prop.autocommit"

  public static final String

  BATCHSIZE

  "prop.batchsize"

  public static final String

  BINDADDRESS

  "prop.bindaddress"

  public static final String

  BUFFERDIR

  "prop.bufferdir"

  public static final String

  BUFFERMAXMEMORY

  "prop.buffermaxmemory"

  public static final String

  BUFFERMINPACKETS

  "prop.bufferminpackets"

  public static final String

  CACHEMETA

  "prop.cachemetadata"

  public static final String

  CHARSET

  "prop.charset"

  public static final String

  DATABASENAME

  "prop.databasename"

  public static final String

  DOMAIN

  "prop.domain"

  public static final String

  INSTANCE

  "prop.instance"

  public static final String

  LANGUAGE

  "prop.language"

  public static final String

  LASTUPDATECOUNT

  "prop.lastupdatecount"

  public static final String

  LOBBUFFER

  "prop.lobbuffer"

  public static final String

  LOGFILE

  "prop.logfile"

  public static final String

  LOGINTIMEOUT

  "prop.logintimeout"

  public static final String

  MACADDRESS

  "prop.macaddress"

  static final int

  MAJOR_VERSION

  1

  public static final String

  MAXSTATEMENTS

  "prop.maxstatements"

  static final int

  MINOR_VERSION

  3

  static final String

  MISC_VERSION

  ".1"

  public static final String

  NAMEDPIPE

  "prop.namedpipe"

  public static final String

  PACKETSIZE

  "prop.packetsize"

  public static final String

  PASSWORD

  "prop.password"

  public static final String

  PORTNUMBER

  "prop.portnumber"

  public static final String

  PREPARESQL

  "prop.preparesql"

  public static final String

  PROCESSID

  "prop.processid"

  public static final String

  PROGNAME

  "prop.progname"

  public static final String

  SENDSTRINGPARAMETERSASUNICODE

  "prop.useunicode"

  public static final String

  SERVERNAME

  "prop.servername"

  public static final String

  SERVERTYPE

  "prop.servertype"

  public static final String

  SOKEEPALIVE

  "prop.sokeepalive"

  public static final String

  SOTIMEOUT

  "prop.sotimeout"

  public static final int

  SQLSERVER

  1

  public static final String

  SSL

  "prop.ssl"

  public static final int

  SYBASE

  2

  public static final String

  TCPNODELAY

  "prop.tcpnodelay"

  public static final 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 String

  USECURSORS

  "prop.usecursors"

  public static final String

  USEJCIFS

  "prop.usejcifs"

  public static final String

  USEKERBEROS

  "prop.usekerberos"

  public static final String

  USELOBS

  "prop.uselobs"

  public static final String

  USENTLMV2

  "prop.usentlmv2"

  public static final String

  USER

  "prop.user"

  public static final String

  WSID

  "prop.wsid"

  public static final String

  XAEMULATION

  "prop.xaemulation"
• net.sourceforge.jtds.jdbc.JtdsConnection
  Modifier and Type

  Constant Field

  Value

  private static final 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 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 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 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 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 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

  0x88

  private static final int

  ASYNC_CANCEL

  0

  public static final byte

  CANCEL_PKT

  0x6

  public static final int

  DEFAULT_MIN_PKT_SIZE_TDS70

  4096

  static final byte

  DONE_CANCEL

  0x20

  private static final byte

  DONE_END_OF_RESPONSE

  0x80

  private static final byte

  DONE_ERROR

  0x2

  private static final byte

  DONE_MORE_RESULTS

  0x1

  private static final byte

  DONE_ROW_COUNT

  0x10

  public static final int

  EXECUTE_SQL

  2

  public static final byte

  LOGIN_PKT

  0x2

  public static final int

  MAX_PKT_SIZE

  32768

  public static final int

  MIN_PKT_SIZE

  512

  public static final byte

  MSDTC_PKT

  0xe

  public static final byte

  MSLOGIN_PKT

  0x10

  public static final byte

  NTLMAUTH_PKT

  0x11

  public static final int

  PKT_HDR_LEN

  8

  public static final byte

  PRELOGIN_PKT

  0x12

  public static final int

  PREPARE

  3

  public static final byte

  QUERY_PKT

  0x1

  public static final byte

  REPLY_PKT

  0x4

  public static final byte

  RPC_PKT

  0x3

  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

  0xf

  private static final byte

  TDS_ALTROW

  0xd3

  private static final byte

  TDS_AUTH_TOKEN

  0xed

  private static final byte

  TDS_CAP_TOKEN

  0xe2

  private static final byte

  TDS_CLOSE_TOKEN

  0x71

  private static final byte

  TDS_COLFMT_TOKEN

  0xa1

  private static final byte

  TDS_COLINFO_TOKEN

  0xa5

  private static final byte

  TDS_COLNAME_TOKEN

  0xa0

  private static final byte

  TDS_COMP_NAMES_TOKEN

  0xa7

  private static final byte

  TDS_COMP_RESULT_TOKEN

  0xa8

  private static final byte

  TDS_CONTROL_TOKEN

  0xae

  private static final byte

  TDS_DBRPC_TOKEN

  0xe6

  private static final byte

  TDS_DONE_TOKEN

  0xfd

  private static final byte

  TDS_DONEINPROC_TOKEN

  0xff

  private static final byte

  TDS_DONEPROC_TOKEN

  0xfe

  private static final byte

  TDS_ENV_CHARSET

  0x3

  private static final byte

  TDS_ENV_DATABASE

  0x1

  private static final byte

  TDS_ENV_LANG

  0x2

  private static final byte

  TDS_ENV_LCID

  0x5

  private static final byte

  TDS_ENV_PACKSIZE

  0x4

  private static final byte

  TDS_ENV_SQLCOLLATION

  0x7

  private static final byte

  TDS_ENVCHANGE_TOKEN

  0xe3

  private static final byte

  TDS_ERROR_TOKEN

  0xaa

  private static final byte

  TDS_INFO_TOKEN

  0xab

  private static final byte

  TDS_LANG_TOKEN

  0x21

  private static final byte

  TDS_LOGINACK_TOKEN

  0xad

  private static final byte

  TDS_MSG50_TOKEN

  0xe5

  private static final byte

  TDS_OFFSETS_TOKEN

  0x78

  private static final byte

  TDS_ORDER_TOKEN

  0xa9

  private static final byte

  TDS_PARAM_TOKEN

  0xac

  private static final byte

  TDS_PROCID

  0x7c

  private static final byte

  TDS_RESULT_TOKEN

  0xee

  private static final byte

  TDS_RETURNSTATUS_TOKEN

  0x79

  private static final byte

  TDS_ROW_TOKEN

  0xd1

  private static final byte

  TDS_TABNAME_TOKEN

  0xa4

  private static final byte

  TDS5_DYNAMIC_TOKEN

  0xe7

  private static final byte

  TDS5_PARAMFMT_TOKEN

  0xec

  private static final byte

  TDS5_PARAMFMT2_TOKEN

  0x20

  private static final byte

  TDS5_PARAMS_TOKEN

  0xd7

  private static final byte

  TDS5_WIDE_RESULT

  0x61

  private static final byte

  TDS7_RESULT_TOKEN

  0x81

  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 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 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 String

  SSL_AUTHENTICATE

  "authenticate"

  public static final String

  SSL_OFF

  "off"

  public static final String

  SSL_REQUEST

  "request"

  public static final String

  SSL_REQUIRE

  "require"

  public static final int

  TLS_HEADER_SIZE

  5

  public static final byte

  TYPE_ALERT

  0x15

  public static final byte

  TYPE_APPLICATIONDATA

  0x17

  public static final byte

  TYPE_CHANGECIPHERSPEC

  0x14

  public static final int

  TYPE_CLIENTHELLO

  1

  public static final int

  TYPE_CLIENTKEYEXCHANGE

  16

  public static final byte

  TYPE_HANDSHAKE

  0x16

• 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