| Modifier and Type | Constant Field | Value |
|---|---|---|
private static final java.lang.String |
CHARSETS_RESOURCE_NAME |
"net/sourceforge/jtds/jdbc/Charsets.properties" |
| Modifier and Type | Constant Field | Value |
|---|---|---|
private static final java.lang.String |
EMPTY_CLOB |
"" |
| Modifier and Type | Constant Field | Value |
|---|---|---|
static final int |
DATE_NOT_USED |
-2147483648 |
static final int |
TIME_NOT_USED |
-2147483648 |
| 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" |
| 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" |
| 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 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
static final int |
sqlStateXOpen |
1 |
| 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 |
| 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 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
private static final java.lang.String |
DEFAULT_RESOURCE |
"net.sourceforge.jtds.jdbc.Messages" |
| 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 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
private final int |
numRetries |
3 |
private final int |
timeout |
2000 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
static final int |
NUM_COLS |
18 |
| 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 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
private static final int |
MAX_INITIAL_SIZE |
50 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
static final java.lang.String |
DESCRIPTION |
"description" |
static final long |
serialVersionUID |
266241L |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final int |
XID_SIZE |
140 |
| 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 |
| 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 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
protected static final int |
BLOCK_SIZE |
8 |
| 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 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
private static final int |
DIGEST_LENGTH |
16 |
Generated on September 20 2018