The actual cache instance.
LRU cache of previously parsed SQL
A memory cached scrollable/updateable result set.
Creates a cached result set with the same columns (and optionally data)
as an existing result set.
Creates a cached result set containing one row.
Constructs a new cached result set.
Constructs a cached result set based on locally generated data.
Serialized version of a parsed SQL query (the value stored in the cache
for a parsed SQL).
A cached TdsCore
instance to reuse on new statements.
Encapsulates the cached Object and implements the linked list used to
implement the LRU logic.
Constructs a new cache entry encapsulating the supplied key and
value.
Default cacheMetaData
property.
Cache as many results as possible (up to the first
ResultSet
).
Cache the remaining results to free up connection.
Maximum cache size or 0 to disable.
cal - static field in class net.sourceforge.jtds.jdbc.
Support Static utility Calendar object.
Calculate the buffer size to use when buffering the InputStream
for named pipes.
Per thread instance of Calendar used for conversions.
This class would be better implemented as a java.lang.reflect.Proxy.
Processes the JDBC {call procedure [(?,?,?)]} type escape.
Delgates calls to the statement; SQLExceptions thrown from the statement
will cause an event to be fired on the connection pool listeners.
Send (only) one cancel packet to the server.
Send a TDS cancel packet to the server.
True if the query has been cancelled by another thread.
A cancel packet is pending.
Indicates pending cancel that needs to be cleared.
Remove a redundant timer before it expires.
Establish if a String can be converted to a byte based character set.
Boolean.TRUE
if identifiers are case sensitive (the server
was installed that way).
Database owning this column
Table catalog (database) name.
The Java character set name.
Default charset
property.
Character set descriptor (if different from default)
Java charset for encoding.
Loads and stores information about character sets.
Character set descriptor (if different from default)
The character set to use for converting strings to/from bytes.
Constructs a CharsetInfo
object from a character set
descriptor of the form: charset preceded by a numeric value indicating
whether it's a multibyte character set (>1) or not (1) and a vertical
bar (|), eg "1|Cp1252" or "2|MS936".
Server charset to Java charset map.
Name of the Charsets.properties
resource.
True if user specifies an explicit charset.
Check that the exception is caused by the failure to open a
cursor and not by a more serious SQL error.
Check the exception chain for errors and throw any found
as an SQLException.
Checks that this connection is in local transaction mode.
Checks that the connection is still open.
Check that this statement is still open.
Check that this statement is still open.
Check that this connection is still open.
Check that this statement is still open.
Check that the connection is still open.
Check that this resultset is scrollable.
Check that this resultset is updateable.
Releases parameter and result set data and metadata to free up memory.
Overrides clear() to also clear the LRU list.
Delgates calls to the statement; SQLExceptions thrown from the statement
will cause an event to be fired on the connection pool listeners.
Clear the IN parameter value and status.
Clear the OUT parameter value and status.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Empty the server response queue.
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
Delgates calls to the statement; SQLExceptions thrown from the statement
will cause an event to be fired on the connection pool listeners.
An in-memory or disk based representation of character data.
Constructs a new empty Clob
instance.
Constructs a new initialized Clob
instance.
Creates a shallow copy of this ParamInfo
instance.
Logically closes the file or physically close it if the open count is
now zero.
Closes the output stream.
Closes the output stream.
Closes the output stream.
Releases this Connection
object's database and JDBC
resources immediately instead of waiting for them to be automatically
released.
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
Closes the database connection.
Closes the database connection.
Closes this response stream.
Close the named pipe and virtual sockets and release any resources.
Close the socket (noop if in shared mode).
Close the socket and release all resources.
Delgates calls to the statement; SQLExceptions thrown from the statement
will cause an event to be fired on the connection pool listeners.
Close the TdsCore
connection object and associated streams.
Inform the server that this connection is closing.
Close current result set (if any).
True if this connection is closed.
True if this result set is closed.
True if this statement is closed.
Deallocate a stream linked to this socket.
This class is a descriptor for result set columns.
SQL Server 2000 collation.
The cached column meta data.
Column meta data (Sybase only).
Number of visible columns in row.
Cache to optimize findColumn(String) lookups
The array of column descriptors.
The array of column meta data objects for this result set.
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
Comparable implementation that orders by dataType, then by how closely
the data type maps to the corresponding JDBC SQL type.
True if output is complete TDS packet.
The result set concurrency.
The parent connection object
The connection owning this statement object.
Connection object for server specific parsing.
The Connection object that created this object.
jTDS implementation of the java.sql.Connection interface.
Create a new database connection.
Implements JDBC 3.0 specific functionality.
Create a new database connection.
Mutual exclusion lock on connection.
This class would be better implemented as a java.lang.reflect.Proxy.
Constructs a new connection proxy.
Consume packets from the server response queue up to (and including) the
first response terminator.
Convert an existing data object to the specified JDBC type.
Converts a LOB to the equivalent Java type, i.e.
Converts a LOB type constant to the equivalent Java type constant, i.e.
Used by answerNtlmChallenge.
Copy an existing result set column descriptor array.
Copies over possible SQL keyword eg 'SELECT'
Inserts a String literal in the output buffer.
Builds a new parameter item.
Copies an embedded parameter name to the output buffer.
Copies an embedded stored procedure identifier over to the output buffer.
Copy an existing result set row.
Copies over an embedded string literal unchanged.
Creates the NTLMv2 blob from the given target information block and
client challenge.
Creates a random access disk file to use as backing storage for the LOB
data.
Creates a
SharedSocket
object representing a connection to a named
pipe.
Creates a
Socket
through reflection when
Driver.JDBC3
is
true
.
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
Creates a timestamp in the format used in NTLMv2 responses.
The current database name.
The number of the current page in memory.
The current result set row.
The descriptor object for the current TDS token.
The entry references a prepared cursor handle.
Support general cursor operations such as delete, update etc.
Close a server side cursor.
Creates a new scrollable result set in memory or a named server cursor.
Create a new Cursor result set using the internal sp_cursoropen procedure.
Fetches the next result row from the internal row array.
Fetch the next result row from a cursor using the internal sp_cursorfetch procedure.
The cursor name to be used for positioned updates.
The cursor name to be used for positioned updates.
Actual position of the cursor.
Map of jdbc to server data types for convert
base implementation of MD4 family style digest as outlined in
"Handbook of Applied Cryptography", pages 344 - 347.
generate an integer based working key based on our secret key
and what we processing we are planning to do.
Dummy result set for getGeneratedKeys.
Overrides get()
so that it also updates the LRU list.
Get runtime message using supplied key.
Retrieves a ProcEntry object from the cache.
Returns a statement handle associated with the specified key or
null
if the key specified does not have an associated
statement handle.
Get runtime message using supplied key and substitute parameter
into message.
Get runtime message using supplied key and substitute parameters
into message.
Get runtime error using supplied key and substitute parameters
into message.
Retrieves the application name for this connection.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
Obtain the counts from a batch of SQL updates.
Retrieves the batch size to be used internally.
Get a description of a table's optimal set of columns that
uniquely identifies a row.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Retrieve the BLOB data as an InputStream
.
Retrieves the bind address for this connection.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Obtain this object's backing BlobBuffer
object.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Returns the directory where data should be buffered to.
Retrieves the maximum amount of memory in Kb to buffer for all connections.
Retrieves the minimum number of packets to buffer per Statement
for this connection.
Retrieve the current output packet size.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Retrieve the unique identifier as a byte array.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Returns the BLOB data as a byte array.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Get the byte array value of the parameter.
Retrieves the statement cache, creating it if required.
Retrieves the cached TdsCore
or null
if
nothing is cached and resets the cache (sets it to null
).
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
Get the catalog names available in this database.
What's the separator between catalog and table name?
What's the database vendor's preferred term for "catalog"?
Retrieves the charset name.
Retrieve the Java charset to use for encoding.
Retrieve the character set name used to translate byte arrays to
or from Strings.
Retrieves the CharsetInfo
instance asociated with the
specified collation.
Retrieves the CharsetInfo
instance asociated with the
specified server charset.
Retrieves the CharsetInfo
instance asociated with the
specified LCID.
Retrieves the CharsetInfo
instance asociated with the
specified sort order.
Retrieve the CharsetInfo
instance used by this connection.
Retrieve the character set descriptor used to translate byte arrays to
or from Strings.
Retrieve the fully qualified java class name for the
supplied JDBC Types constant.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Retrieve the SQL Server 2000 default collation.
TDS 8 supplies collation information for character data types.
Retrieves the column meta data array.
Get the specified column's data item.
Return the column descriptor given a column index.
Get the specified column's data item.
Retrieve the column count excluding hidden columns
Get a description of the access rights for a table's columns.
Retrieve the column descriptor array.
Retrieve the current result set column descriptors.
Get a description of table columns available in a catalog.
JDBC 2.0 Retrieves the connection that produced this metadata object.
Returns a new database connection.
Returns a ConnectionProxy.
Delgates calls to the statement; SQLExceptions thrown from the statement
will cause an event to be fired on the connection pool listeners.
Returns the connection for a given ResultSet
,
Statement
or Connection
object.
Returns a new database connection for the user and password specified.
Get a description of the foreign key columns in the foreign key table
that reference the primary key columns of the primary key table
(describe how one table imports another's key).
Retrieve the current row data.
Retrieve the current row data.
Translates a JDBC result set concurrency into SQL Server native @ccOpt
value for use with stored procedures such as sp_cursoropen,
sp_cursorprepare or sp_cursorprepexec.
Retrieves the next unique cursor name.
Translates a JDBC result set type into SQL Server native @scrollOpt value
for use with stored procedures such as sp_cursoropen, sp_cursorprepare
or sp_cursorprepexec.
Retrieves the DBMS major version.
Returns the database major version.
Retrieves the DBMS minor version.
Returns the database minor version.
Retrieves the database name for this connection.
Retrieves the DBMS product name.
Returns the name of this database product.
Retrieves the DBMS product version.
Returns the version of this database product.
Retrieves the date component of a datetime value.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Utility routine to validate date and time escapes.
Get a DATETIME value from the server response stream.
Retrieve the default fetch size for this statement.
Returns the database's default transaction isolation level.
Retrieves the domain name for this connection.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Returns this JDBC driver's major version number.
Returns this JDBC driver's minor version number.
Returns the name of this JDBC driver.
Returns the version of this JDBC driver.
Get a description of the foreign key columns that reference a table's
primary key columns (the foreign keys exported by a table).
Get all the "extra" characters that can be used in unquoted identifier
names (those beyond a-z, A-Z, 0-9 and _).
Returns an SSLSocketFactory whose behavior will depend on the SSL
setting.
Delgates calls to the statement; SQLExceptions thrown from the statement
will cause an event to be fired on the connection pool listeners.
Delgates calls to the statement; SQLExceptions thrown from the statement
will cause an event to be fired on the connection pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the statement; SQLExceptions thrown from the statement
will cause an event to be fired on the connection pool listeners.
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
Get the server host name.
Tries to figure out what client name we should identify ourselves as.
Returns the savepoint id.
Returns the string used to quote SQL identifiers.
Get a description of the primary key columns that are referenced by a
table's foreign key columns (the primary keys imported by a table).
Get a description of a table's indices and statistics.
Creates a simple InputStream
over the server response.
Returns the singleton SSPIJNIClient
instance.
Retrieves the instance name for this connection.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Returns the JDBC major version.
Returns the JDBC minor version.
Get the JDBC type constant which matches the supplied Class
.
Get the JDBC type constant which matches the supplied Object type.
Get a String describing the supplied JDBC type constant.
Retrieves the status of the lastUpdateCount flag.
Retrieves the length of this BLOB buffer in bytes.
Retrieves the LOB buffer size.
Retrieves the login timeout for this connection.
Get the logging PrintWriter Stream.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Retrieves the MAC (ethernet) address for this connection.
Converts a user supplied MAC address into a byte array.
How many hex characters can you have in an inline binary literal?
What's the maximum length of a catalog name?
What's the max length for a character literal?
What's the limit on column name length?
What's the maximum number of columns in a "GROUP BY" clause?
What's the maximum number of columns allowed in an index?
What's the maximum number of columns in an "ORDER BY" clause?
What's the maximum number of columns in a "SELECT" list?
What's the maximum number of columns in a table?
How many active connections can we have at a time to this database?
What's the maximum cursor name length?
Returns the maximum number of bytes required to output a decimal
given the current
maxPrecision
.
Delgates calls to the statement; SQLExceptions thrown from the statement
will cause an event to be fired on the connection pool listeners.
What's the maximum length of an index (in bytes)?
Retrieves the maximum decimal precision.
Retrive the maximum decimal precision.
What's the maximum length of a procedure name?
Delgates calls to the statement; SQLExceptions thrown from the statement
will cause an event to be fired on the connection pool listeners.
What's the maximum length of a single row?
What's the maximum length allowed for a schema name?
What's the maximum length of a SQL statement?
Retrieves the maximum statement cache size.
How many active statements can we have open at one time to this
database?
What's the maximum length of a table name?
What's the maximum number of tables in a SELECT?
What's the maximum length of a user name?
Get the global buffer memory limit for all instancs of this driver.
Get the statement's warnings list.
Returns the diagnostic chain for this instance.
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Get the minimum number of memory cached packets.
Read a MONEY value from the server response stream.
Delgates calls to the statement; SQLExceptions thrown from the statement
will cause an event to be fired on the connection pool listeners.
Get the next result set or update count from the TDS stream.
Delgates calls to the statement; SQLExceptions thrown from the statement
will cause an event to be fired on the connection pool listeners.
For SQL 2005 This routine will modify the meta data to allow the
caller to distinguish between varchar(max) and text or varbinary(max)
and image or nvarchar(max) and ntext.
Retrieves the connection mutex and acquires an exclusive lock on the
network connection.
Retrieves the named pipe setting for this connection.
Returns the default path for the named pipe for a given serverType.
Retrieve the TDS native type code for the parameter.
Retrieves the network packet size.
Retrieve the next data row from the result set.
Returns the next savepoint identifier.
Get a comma separated list of math functions.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Obtains a list of statement handles or procedures that can now be
dropped.
Returns a Collection
of obsolete statement handles that may
be released, or null
if no statement handles are obsolete.
Retrieve the value of an output parameter.
Get the output parameter value.
Read the next TDS packet from the network.
Retrieves the packet size for this connection.
Check the supplied index and return the selected parameter.
Constructs a parameter definition string for use with
sp_executesql, sp_prepare, sp_prepexec, sp_cursoropen,
sp_cursorprepare and sp_cursorprepexec.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Retrieve the parameter meta data from a Sybase prepare.
Retrieves the parameter meta data array.
Retrieves the password for this connection.
Convert two bytes (in network byte order) in a byte array into a Java
short integer.
Returns a new pooled database connection.
Returns a new pooled database connection for the user and password specified.
Get the server port number.
Call getInfo() before calling this method.
Retrieves the port number for this connection.
Retrieves the Prepared SQL method.
Get a description of a table's primary key columns.
Get a description of a catalog's stored procedure parameters and result
columns.
Get a description of stored procedures available in a catalog.
What's the database vendor's preferred term for "procedure"?
Retrieves the next unique stored procedure name.
Retrieves the program name for this connection.
Delgates calls to the statement; SQLExceptions thrown from the statement
will cause an event to be fired on the connection pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Retreives the usage count.
Obtain an instance of a server request stream for this socket.
Obtain an instance of a server response stream for this socket.
Delgates calls to the statement; SQLExceptions thrown from the statement
will cause an event to be fired on the connection pool listeners.
Delgates calls to the statement; SQLExceptions thrown from the statement
will cause an event to be fired on the connection pool listeners.
Delgates calls to the statement; SQLExceptions thrown from the statement
will cause an event to be fired on the connection pool listeners.
Delgates calls to the statement; SQLExceptions thrown from the statement
will cause an event to be fired on the connection pool listeners.
Retrieve the return status for the current stored procedure.
Retrieves the host and port for this connection.
Retrieves the current row count on this connection.
Retrieve the current result set data items.
Get the schema names available in this database.
What's the database vendor's preferred term for "schema"?
This is the string that can be used to escape '_' or '%' in the string
pattern style catalog search parameters.
Retrieves the server name for this connection.
Retrieves the server type.
Retrieve the Server type.
Retrieves the server type.
Converts an integer server type to its string representation.
Converts a string server type to its integer representation.
Same as
getServerType(int)
, only it returns the default server
type (
"sqlserver"
) if
serverType
is 0.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Retrive the shared socket.
Returns a socket factory, the behavior of which will depend on the SSL
setting and whether or not the DB server supports SSL.
Retrieves the socket timeout for this connection.
Get a comma separated list of all a database's SQL keywords that are NOT
also SQL92 keywords.
Map an SQL Server error code to an ANSI SQLSTATE code.
Generates a unique statement key for a given SQL statement.
Retrieve the unique stream id.
Retrieves the unique stream id.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Get the string value of the parameter.
Get a comma separated list of string functions.
Retrieve the Sybase capability data.
Get a comma separated list of system functions.
Extracts the first table name following the keyword FROM.
Get a description of the access rights for each table available in a
catalog.
Get a description of tables available in a catalog.
Get the table types available in this database.
Retrieves the tcpNoDelay setting for this connection.
Get the Statement's TDS object.
Calculate the size of the parameter descriptor array for TDS 5 packets.
Retrieve the TDS protocol version.
Retrieve the TDS version number.
Retrieves the TDS version number.
Retrieve the TDS version that is active on the connection
supported by this socket.
Retrieve the TDS protocol version.
Extract the TDS protocol version from the value returned by the server in the LOGINACK
packet.
Converts a string TDS version to its integer representation.
Retrieves the current maximum textsize on this connection.
Retrieves the time component of a datetime value.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Get a comma separated list of time and date functions.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
Retrieves the statement implementation type.
Get a description of all the standard SQL types supported by this
database.
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
JDBC 2.0 Gets a description of the user-defined types defined in a
particular schema.
Retrieve the BLOB data as an Big Endian Unicode
InputStream
.
Delgates calls to the statement; SQLExceptions thrown from the statement
will cause an event to be fired on the connection pool listeners.
Retrieve the update count from the current TDS token.
Retrieves the original connection URL.
What's the URL for this database?
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Indicates whether fast forward only cursors should be used for forward
only result sets.
Retrieves the useJCIFS setting for this connection.
Indicates whether large types (IMAGE and TEXT/NTEXT) should be mapped by
default to LOB types or String
and byte[]
respectively.
Retrieves the boolean indicating whether metadata caching
is enabled.
Indicates whether, when doing Windows authentication to an MS SQL server,
NTLMv2 should be used.
Retrieves the user for this connection.
What's our user name as known to the database?
Retrieve the sendParametersAsUnicode flag.
Read a MSQL 2000 sql_variant data value from the input stream.
Returns the driver version.
Get a description of a table's columns that are automatically updated
when any value in a row is updated.
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
Return the warning chain.
Delgates calls to the statement; SQLExceptions thrown from the statement
will cause an event to be fired on the connection pool listeners.
Retrieves the workstation ID (WSID) for this connection.
Returns a new XA database connection.
Returns a new XA database connection for the user and password specified.
Retrieves the XA Connection ID to pass to server.
Retrieves the XA state variable.
Gets the XA transaction ID when running in emulation mode.
Total memory usage in all instances of the driver
NB.
Increases the size of the in memory buffer for situations where disk
storage of BLOB is not possible.
The global transaction ID.
Converts a calendar date into days since 1900 (Sybase epoch).
Default packetSize
property for TDS 4.2.
Default packetSize
property for TDS 5.0.
Default packetSize
property for TDS 7.0 and TDS 8.0.
Count of packets received.
User requested packet size.
Default packet size based on TDS version
Converts separate time components into a datetime time value.
Mask for page component of read/write pointer.
Default page size (must be power of 2).
sp_cursorfetch
fetchtype parameter.
sp_cursorfetch
numrows IN parameter (for actual fetches).
sp_cursorfetch
numrows OUT parameter (for FETCH_INFO).
sp_cursor
optype parameter.
sp_cursor
rownum parameter.
sp_cursorfetch
rownum IN parameter (for actual fetches).
sp_cursorfetch
rownum OUT parameter (for FETCH_INFO).
sp_cursor
table parameter.
jTDS implementation of ParameterMetaData
.
The parameter list for the call.
The array of parameter meta data objects for the current procedure call.
This class is a descriptor for procedure and prepared statement parameters.
Construct a parameter with parameter marker offset.
Construct an initialised parameter with extra attributes.
Construct a parameter based on a result set column.
Construct a parameter for statement caching.
The cached parameter meta data.
Parameter meta data (Sybase only).
Parameter list to be populated or null
if no parameters
are expected.
Last parameter retrieved was null.
Parses the SQL statement processing JDBC escapes and parameter markers.
Parse the SQL statement processing JDBC escapes and parameter markers.
Parse a string property value into an integer value.
Parse a string property value into a long value.
Parse the driver URL and extract the properties.
Default password
property.
pc1 - static field in class net.sourceforge.jtds.util.
DESEngine pc2 - static field in class net.sourceforge.jtds.util.
DESEngine Peak memory usage for debug purposes.
Retrieves the next input byte without reading forward.
Current number of available permits.
Return the current number of available permits.
The named pipe as a file.
The size of the packet header.
Memory resident packet queue.
Number of packets cached to disk.
jTDS implementation of the PooledConnection
interface.
Default portNumber
property for SQL Server.
Default portNumber
property for Sybase.
Default port number based on server type
Provides support for pattern searching methods.
Parameter decimal precision
The precision of the type.
SQL 2000 prelogin negotiation packet.
The entry references a failed prepare.
The entry references a prepared statement handle.
Prepare SQL using sp_prepare and sp_execute
Default prepareSql
property for SQL Server.
Default prepareSql
property for Sybase.
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
This class would be better implemented as a java.lang.reflect.Proxy.
Method for preparing SQL used in Prepared Statements.
Try to convert the SQL statement into a statement prepare.
Default prepare SQL mode based on server type
Prepares the NTLM TYPE-1 message and returns it as a
byte[]
.
Prepares the NTLM TYPE-3 message using the current user's credentials.
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
Read in entire TLS record or TDS packet and store the TLS record in the
buffer.
Print a diagnostic message to the output stream provided by
the DataSource or the DriverManager.
The entry references a stored procedure.
LRU cache for procedures and statement handles.
Constructs a new statement cache.
Stores information about a cached stored procedure or statement handle.
Format the supplied search pattern to transform the escape \x into [x].
Processes the output of a cursor open or fetch operation.
Queue up update counts into
resultQueue
until the end of the
response is reached or a
ResultSet
is encountered.
Procedures in this transaction.
The procedure name for CallableStatements.
Procedure name in call escape.
Default progName
property.
Exception class used to report errors in the TDS protocol.
Construct a ProtocolException with message.
False if TLS packets are encapsulated in TDS packets.
Overrides put()
so that it also updates the LRU list.
Inserts a new entry, identified by a key, into the cache.
Places the specified statement handle in the cache for the given key.
TDS 8 requires collation information for char data descriptors.
Output a java.sql.Date/Time/Timestamp value to the server
as a Sybase datetime value.
Write a TDS login packet string.
Write the TDS packet to the network.
Write a TDS packet containing the TLS record(s).
The RA file object reference or null if closed.
Construct and throw an XAException
with an explanatory message and the XA error code set.
Construct and throw an XAException
with an explanatory message derived from the
SQLException
and the XA error code set to XAER_RMFAIL
.
Read the next byte from the stream.
Reads the next byte from the stream.
Reads the next byte from the stream.
Reads the next input byte from the server response stream.
Reads a byte array from the server response stream.
Reads a bytes from the stream.
Reads a byte array from the server response stream, specifying a start
offset and length.
Reads a char array from the server response stream.
Reads byte from the BLOB buffer at the specified location.
Reads bytes from the BLOB buffer at the specified location.
Temporary buffer used to de-encapsulate inital TLS packets.
Read the TDS data item from the Response Stream.
Reads len
bytes or throws an IOException
if
there aren't that many bytes available.
Reads an int
value from the server response stream.
Reads a long
value from the server response stream.
Reads a non Unicode String
from the server response stream,
creating the String
from a translated byte
array.
Reads a String
from the server response stream, translating
it from a byte
array using the specified character set.
True if this connection is read only.
Read a physical TDS packet from the network.
Reads in the specified page from the disk buffer.
Process the pre login acknowledgement from the server.
Reads a short
value from the server response stream.
Reads a String
object from the server response stream.
Reads a String
from the server response stream, creating
it from a translated byte
array.
Read the TDS datastream and populate the ColInfo parameter with
data type and related information.
Reads a UCS2-LE (Unicode) encoded String object from the server response
stream.
Reads an unsigned long
value from the server response stream.
Usage count for this statement.
Refreshes a result set row from keyed tables.
Refreshes the row by rereading the result set.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Decrements the usage count.
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
Releases (either closes or caches) a TdsCore
.
Removes a redundant entry from the cache.
Removes a statement key and handle from the cache for the specified key.
Remove a stored procedure from the cache.
Removes the specified listener from the list.
Removes a statement object from the list maintained by the connection
and cleans up the statement cache if necessary.
Class to implement an output stream for the server request.
Construct a RequestStream object.
reset the chaining variables to the IV values.
reset the chaining variables to the IV values.
The XAResource used by the transaction manager to control this connection.
The Stream ID of the object that is expecting a response from the server.
Implements an input stream for the server response.
Constructs a RequestStream
object.
List of queued results (update counts, possibly followed by a
ResultSet
).
The concurrency of result sets created by this statement.
The type of result sets created by this statement.
Retrieve the results pending status.
True to return generated keys.
The return parameter meta data object for the current procedure call.
The stored procedure return status.
Flag as an return value parameter.
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
Connection's current rowcount limit.
Cached row data for forward only result set.
The array of column data objects in the current row.
Indicates that row has been deleted.
Index of current row in rowData.
The number of rows in the result.
Indicates that row has been updated.
TDS Remote Procedure Call.
Execute the TimerThread
main loop.
s - field in class net.sourceforge.jtds.jdbc.
SQLParser Current position in input buffer.
S11 - static field in class net.sourceforge.jtds.util.
MD4Digest S11 - static field in class net.sourceforge.jtds.util.
MD5Digest S12 - static field in class net.sourceforge.jtds.util.
MD4Digest S12 - static field in class net.sourceforge.jtds.util.
MD5Digest S13 - static field in class net.sourceforge.jtds.util.
MD4Digest S13 - static field in class net.sourceforge.jtds.util.
MD5Digest S14 - static field in class net.sourceforge.jtds.util.
MD4Digest S14 - static field in class net.sourceforge.jtds.util.
MD5Digest S21 - static field in class net.sourceforge.jtds.util.
MD4Digest S21 - static field in class net.sourceforge.jtds.util.
MD5Digest S22 - static field in class net.sourceforge.jtds.util.
MD4Digest S22 - static field in class net.sourceforge.jtds.util.
MD5Digest S23 - static field in class net.sourceforge.jtds.util.
MD4Digest S23 - static field in class net.sourceforge.jtds.util.
MD5Digest S24 - static field in class net.sourceforge.jtds.util.
MD4Digest S24 - static field in class net.sourceforge.jtds.util.
MD5Digest S31 - static field in class net.sourceforge.jtds.util.
MD4Digest S31 - static field in class net.sourceforge.jtds.util.
MD5Digest S32 - static field in class net.sourceforge.jtds.util.
MD4Digest S32 - static field in class net.sourceforge.jtds.util.
MD5Digest S33 - static field in class net.sourceforge.jtds.util.
MD4Digest S33 - static field in class net.sourceforge.jtds.util.
MD5Digest S34 - static field in class net.sourceforge.jtds.util.
MD4Digest S34 - static field in class net.sourceforge.jtds.util.
MD5Digest S41 - static field in class net.sourceforge.jtds.util.
MD5Digest S42 - static field in class net.sourceforge.jtds.util.
MD5Digest S43 - static field in class net.sourceforge.jtds.util.
MD5Digest S44 - static field in class net.sourceforge.jtds.util.
MD5Digest Counter for generating unique savepoint identifiers
Savepoint implementation class.
Constructs a savepoint with a specific identifier.
Constructs a savepoint with a specific identifier and name.
Maps each savepoint to a list of tmep procedures created since the savepoint
Removes unused entries trying to bring down the cache to the requested
size.
Table schema (user) name.
Global flag to indicate that security constraints mean
that attempts to create work files will fail.
Simple semaphore class used to serialize access requests over the network
connection.
Create a Semaphore with the given initial number of permits.
sendMSLoginPkt(String,String,String,String,String,String,String,String,String,String,int) - method in class net.sourceforge.jtds.jdbc.
TdsCore Send a TDS 7 login packet.
Send the response to the NTLM authentication challenge.
Send the SQL Server 2000 pre login packet.
Invokes the xp_jtdsxa
extended stored procedure on the
server.
Default serverType
property for SQL Server.
Default serverType
property for Sybase.
The server character set.
The make of SQL Server (sybase/microsoft).
The servertype one of Driver.SQLSERVER or Driver.SYBASE
The make of SQL Server (Sybase/Microsoft).
Turn the logging on or off.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Creates an OutputStream
that can be used to update the
BLOB.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Sets the initial buffer to an existing byte array.
Set the output buffer size
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Sets the content of the BLOB to the supplied byte array value.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Set the character set descriptor to be used to translate byte arrays to
or from Strings.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Forces the closed status on the statement if an I/O error has occurred.
Set the specified column's label.
Set the default collation for this connection.
Update the cached column meta data information.
Sets the column meta data.
Set the specified column's name.
Set the specified column's JDBC type.
Set the charsetInfo
field of ci
according to
the value of its collation
field.
Set the current row's column count.
Sets the column meta data.
Sets the specified column's data value.
Set the specified column's data value.
Set the specified column's data value.
Modify the concurrency of the result set.
Delgates calls to the statement; SQLExceptions thrown from the statement
will cause an event to be fired on the connection pool listeners.
Called by the protcol to change the current database context.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Update the connection instance with information about the server.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the statement; SQLExceptions thrown from the statement
will cause an event to be fired on the connection pool listeners.
Delgates calls to the statement; SQLExceptions thrown from the statement
will cause an event to be fired on the connection pool listeners.
Delgates calls to the statement; SQLExceptions thrown from the statement
will cause an event to be fired on the connection pool listeners.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Sets the prepared statement handle.
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Retrieves the length of the BLOB buffer (in memory version only).
Set the logging PrintWriter stream.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the statement; SQLExceptions thrown from the statement
will cause an event to be fired on the connection pool listeners.
Delgates calls to the statement; SQLExceptions thrown from the statement
will cause an event to be fired on the connection pool listeners.
Set the global buffer memory limit for all instances of this driver.
Set the minimum number of packets to cache in memory before
writing to disk.
Sets the network packet size.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Generic setObject method.
Set the OUT parameter value.
Set the current output packet type.
Update the ParamInfo object for the specified parameter.
Update the cached parameter meta data information.
Sets the parameter meta data.
Delgates calls to the statement; SQLExceptions thrown from the statement
will cause an event to be fired on the connection pool listeners.
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Sets the current row count on this connection.
Sets the server row count (to limit the number of rows in a result set)
and text size (to limit the size of returned TEXT/NTEXT fields).
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
Add a savepoint to the list maintained by this connection.
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
Called by the protocol to change the current character set.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Set the Sybase capability data.
Set the TDS version field.
Sets the current maximum textsize on this connection.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Add a timer request to the queue.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
Sets the statement implementation type.
Delgates calls to the connection; SQLExceptions thrown from the connection
will cause an event to be fired on the connection pool listeners.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Sets up properties for the connect(String, java.util.Properties)
method.
Delgates calls to the prepared statement; SQLExceptions thrown from the
prepared statement will cause an event to be fired on the connection
pool listeners.
Delgates calls to the callable statement; SQLExceptions thrown from the
callable statement will cause an event to be fired on the connection
pool listeners.
Sets the XA state variable.
Sets the XA transaction ID when running in emulation mode.
This class implements inter-process communication (IPC) to the database
server using local named pipes (will only work on Windows).
Creates a new instance of SharedLocalNamedPipe
.
This class implements inter-process communication (IPC) to the
database server using named pipes.
Creates a new instance of SharedNamedPipe
.
This class mananges the physical connection to the SQL Server and
serialises its use amongst a number of virtual sockets.
Construct a SharedSocket
object specifying host name and
port.
Simple LRU cache for any type of object.
Constructs a new LRU cache instance.
The size of this type or < 0 for variable sizes.
Fetch size has been changed.
Discards bytes from the server response stream.
Skips multi-line comments
Skips single-line comments.
Skips a String
from the server response stream.
Consumes the rest of the server response, without parsing it.
Skips embedded white space.
The network TCP/IP socket.
The shared network socket.
The shared network socket.
The shared network socket.
The Shared network socket object.
Default sockeTimeout
property.
Used for acquiring a socket factory when SSL is enabled.
Table of stream objects sharing this socket.
Socket timeout value in seconds or 0.
Sort order to Java charset map.
SP1 - static field in class net.sourceforge.jtds.util.
DESEngine SP2 - static field in class net.sourceforge.jtds.util.
DESEngine SP3 - static field in class net.sourceforge.jtds.util.
DESEngine SP4 - static field in class net.sourceforge.jtds.util.
DESEngine SP5 - static field in class net.sourceforge.jtds.util.
DESEngine SP6 - static field in class net.sourceforge.jtds.util.
DESEngine SP7 - static field in class net.sourceforge.jtds.util.
DESEngine SP8 - static field in class net.sourceforge.jtds.util.
DESEngine Stored procedure unique ID number.
The SQL statement being prepared.
The row has been deleted.
The row is dirty and needs to be reloaded (internal state).
SQL query to determine the server charset on MS SQL Server 6.5.
SQL Server initial connection string.
Cache key for an SQL query, consisting of the query and server type, major
and minor version.
Helper class for handling SQL warnings and errors.
Create an SQL message for a specific server type.
Process JDBC escape strings and parameter markers in the SQL string.
Constructs a new parser object to process the supplied SQL.
The SQL type name for this column.
SQL type name eg varchar(10)
The first SQL keyword in the SQL string.
SSL - static field in class net.sourceforge.jtds.jdbc.
Driver Ssl - interface net.sourceforge.jtds.ssl.
Ssl SSL settings
SSL is required and the server must return a certificate signed by a
client-trusted authority.
SSL Mode - Client requested force encryption.
SSL Mode - Login packet must be encrypted.
SSL Mode - No server certificate installed.
SSL_OFF - static field in class net.sourceforge.jtds.ssl.
Ssl SSL is not used.
SSL is requested; a plain socket is used if SSL is not available.
SSL is required; an exception if thrown if SSL is not available.
SSL Mode - Server requested force encryption.
Indicates type of SSL connection.
The shared SSL network socket;
A JNI client to SSPI based CPP program (DLL) that returns the user
credentials for NTLM authentication.
A reference to ntlm.SSPIJNIClient.
Private constructor for singleton.
Notifies the TdsCore
that a batch is starting.
Interface for a statement cache.
This class would be better implemented as a java.lang.reflect.Proxy.
List of statements associated with this connection.
The status field from a DONE packet.
Does the database treat mixed case unquoted SQL identifiers as case
insensitive and store them in lower case?
Does the database treat mixed case quoted SQL identifiers as case
insensitive and store them in lower case?
Does the database treat mixed case unquoted SQL identifiers as case
insensitive and store them in mixed case?
Does the database treat mixed case quoted SQL identifiers as case
insensitive and store them in mixed case?
Does the database treat mixed case unquoted SQL identifiers as case
insensitive and store them in upper case?
Does the database treat mixed case quoted SQL identifiers as case
insensitive and store them in upper case?
Cached value of the datetime as a String
.
Submit a simple SQL statement to the server and process all output.
Substitute actual data for the parameter markers to simulate
parameter substitution in a PreparedStatement.
Update the SQL string and replace the ? markers with parameter names
eg @P0, @P1 etc.
This class contains static utility methods designed to support the
main driver classes.
Is "ALTER TABLE" with add column supported?
Is "ALTER TABLE" with drop column supported?
Retrieves whether this database supports the ANSI92 entry level SQL
grammar.
Is the ANSI92 full SQL grammar supported?
Is the ANSI92 intermediate SQL grammar supported?
JDBC 2.0 Indicates whether the driver supports batch updates.
Can a catalog name be used in a data manipulation statement?
Can a catalog name be used in an index definition statement?
Can a catalog name be used in a privilege definition statement?
Can a catalog name be used in a procedure call statement?
Can a catalog name be used in a table definition statement?
Retrieves whether this database supports column aliasing.
Is the CONVERT function between SQL types supported?
Is CONVERT between the given SQL types supported?
Is the ODBC Core SQL grammar supported?
Retrieves whether this database supports correlated subqueries.
Are both data definition and data manipulation statements within a
transaction supported?
Are only data manipulation statements within a transaction supported?
If table correlation names are supported, are they restricted to be
different from the names of the tables?
Are expressions in "ORDER BY" lists supported?
Is the ODBC Extended SQL grammar supported?
Are full nested outer joins supported?
Returns true
if getting auto-generated keys is supported after a
statment is executed; returns false
otherwise
Is some form of "GROUP BY" clause supported?
Can a "GROUP BY" clause add columns not in the SELECT provided it
specifies all the columns in the SELECT?
Can a "GROUP BY" clause use columns not in the SELECT?
Is the SQL Integrity Enhancement Facility supported?
Retrieves whether this database supports specifying a LIKE
escape clause.
Retrieves whether this database provides limited support for outer
joins.
Retrieves whether this database supports the ODBC Minimum SQL grammar.
Retrieves whether this database treats mixed case unquoted SQL identifiers as
case sensitive and as a result stores them in mixed case.
Retrieves whether this database treats mixed case quoted SQL identifiers as
case sensitive and as a result stores them in mixed case.
Returns true
if Callable statements can return multiple result sets;
returns false
if they can only return one result set.
Are multiple ResultSets from a single execute supported?
Can we have multiple transactions open at once (on different
connections)?
Returns true
if the database supports named parameters;
returns false
if the database does not support named parameters.
Retrieves whether columns in this database may be defined as non-nullable.
Can cursors remain open across commits?
Can cursors remain open across rollbacks?
Can statements remain open across commits?
Can statements remain open across rollbacks?
Can an "ORDER BY" clause use columns not in the SELECT?
Is some form of outer join supported?
Is positioned DELETE supported?
Is positioned UPDATE supported?
Does the database support the concurrency type in combination with the
given result set type?
Supported concurrencies for SQL Server:
JDBC concurrency | SQL Server concurrency | Row locks | Description |
CONCUR_READ_ONLY | Read only | No | Read-only. |
CONCUR_UPDATABLE | Optimistic concurrency, updatable | No | Row integrity checked with timestamp comparison or, when not available, value comparison (except text and image fields). |
CONCUR_UPDATABLE+1 | Pessimistic concurrency, updatable | Yes | Row integrity is ensured by locking rows. |
CONCUR_UPDATABLE+2 | Optimistic concurrency, updatable | No | Row integrity checked with value comparison (except text and image fields). |
Does the database support the given result set type?
Supported types for SQL Server:
JDBC type | SQL Server cursor type | Server load | Description |
TYPE_FORWARD_ONLY | Forward-only, dynamic (fast forward-only, static with useCursors=true ) | Light | Fast, will read all data (less fast, doesn't read all data with useCursors=true ). |
Returns true
if savepoints are supported; returns
false
otherwise
Can a schema name be used in a data manipulation statement?
Can a schema name be used in an index definition statement?
Can a schema name be used in a privilege definition statement?
Can a schema name be used in a procedure call statement?
Can a schema name be used in a table definition statement?
Is SELECT for UPDATE supported?
Returns true
if the database supports statement pooling;
returns false
otherwise.
Are stored procedure calls using the stored procedure escape syntax
supported?
Retrieves whether this database supports subqueries in comparison
expressions.
Retrieves whether this database supports subqueries in
EXISTS
expressions.
Retrieves whether this database supports subqueries in
IN
statements.
Retrieves whether this database supports subqueries in quantified
expressions.
Retrieves whether this database supports table correlation names.
Does the database support the given transaction isolation level?
Retrieves whether this database supports transactions.
Is SQL UNION ALL supported?
Sybase nullable bit type.
Sybase date and time data types.
Sybase extended column meta data.
Sybase char and binary > 255.
SYBASE - static field in class net.sourceforge.jtds.jdbc.
Driver Sybase ASE.
Sybase initial connection string.
SQL query to determine the server charset on Sybase.
Creates a light weight stored procedure on a Sybase server.
Drops a Sybase temporary stored procedure.
Map to convert Sybase SQL server error codes to ANSI SQLSTATE codes.
Format the supplied procedure call as a valid JDBC call escape.
Length of a sysname object (table name, catalog name etc.) -- 128 for
TDS 7.0, 30 for earlier versions.
Inner static class used to hold table meta data.
First table name in select.
Table name owning this column
First table name in from clause
The array of table names associated with this result.
Tail node of the linked list.
Target to notify when the timeout expires.
Default tcpNoDelay
property.
TDS - static field in class net.sourceforge.jtds.jdbc.
Driver The TDS object used for server access.
The underlying ResponseStream
.
TDS42 - static field in class net.sourceforge.jtds.jdbc.
Driver TDS 4.2 protocol (SQL Server 6.5 and later and Sybase 9 and later).
Process a TDS 4.2 column format token.
Process a TDS 4.2 column names token.
TDS50 - static field in class net.sourceforge.jtds.jdbc.
Driver TDS 5.0 protocol (Sybase 10 and later).
TDS 5.0 Dynamic SQL token.
TDS 5.0 Parameter format token.
TDS 5.0 parameter descriptor token.
TDS 5.0 parameter value token.
TSD 5.0 Wide result set token.
Process TDS5 dynamic SQL aknowledgements.
Process a TDS 5 error or informational message.
Process TDS 5 Sybase 12+ Dynamic results parameter descriptor.
Process TDS 5 Dynamic results parameter descriptors.
Process TDS 5.0 Params Token.
Process a TDS 5.0 result set packet.
Process Sybase 12+ wide result token which provides enhanced
column meta data.
TDS70 - static field in class net.sourceforge.jtds.jdbc.
Driver TDS 7.0 protocol (SQL Server 7.0 and later).
TDS 7.0 Computed Result set column meta data token.
TDS 7.0 Result set column meta data token.
A very poor man's "encryption".
Process a TDS 7.0 result set token.
TDS80 - static field in class net.sourceforge.jtds.jdbc.
Driver TDS 8.0 protocol (SQL Server 2000 and later)
TDS81 - static field in class net.sourceforge.jtds.jdbc.
Driver TDS 8.1 protocol (SQL Server 2000 SP1 and later).
Map of system stored procedures that have shortcuts in TDS8.
TDS Computed result set data row token.
TDS 7.0 NTLM authentication challenge token.
TDS 5.0 capabilities token.
TDS 4.2 Column meta data token.
TDS Cursor results column infomation token.
TDS 4.2 Column names token.
TDS Computed result set names token.
TDS Computed result set token.
Length of a TDS_DONE token.
TDS done in procedure token.
TDS done procedure token.
Environment change: charset changed.
Environment change: database changed.
Environment change: language changed.
Environment change: locale changed.
Environment change: network packet size changed.
Environment change: TDS 8 collation changed.
TDS environment change token.
Length of TDS packet header.
TDS Information message token.
TDS Login acknowledgement token.
TDS Optional command token.
TDS Order by columns token.
TDS Output parameter value token.
TDS 5.0 Result set column meta data token.
TDS Procedure call return status token.
TDS Result set data row token.
Default tds
property for TDS 4.2.
Default tds
property for TDS 5.0.
Default tds
property for TDS 7.0.
Default tds
property for TDS 8.0.
Processes a TDS 5.0 capability token.
Process a column infomation token.
Process a control token (function unknown).
This class implements the Sybase / Microsoft TDS protocol.
Construct a TdsCore object.
Implement TDS data types and related I/O logic.
Private constructor to prevent users creating an
actual instance of this class.
Default TDS version based on server type
Process a DONE, DONEINPROC or DONEPROC token.
Process an environment change packet.
Process a TD4/TDS7 error or informational message.
Simple inner class implementing an InputStream
over the
server response.
Creates a TdsInputStream
instance.
Report unsupported TDS token in input stream.
Process a login acknowledgement packet.
Process a NTLM Authentication challenge.
Process an order by token.
Process output parameters.
Process procedure ID token.
Process stored procedure return status token.
Process a row data token.
Process a table name token.
An input stream that filters out TDS headers so they are not returned to
JSSE (which will not recognize them).
Constructs a TdsTlsInputStream and bases it on an underlying stream.
An output stream that mediates between JSSE and the DB server.
Constructs a TdsTlsOutputStream based on an underlying output stream.
A socket that mediates between JSSE and the DB server.
Constructs a TdsTlsSocket around an underlying socket.
The socket factory for creating sockets based on the SSL setting.
Constructs a TdsTlsSocketFactory.
Inner static class used to hold information about TDS tokens read.
The server protocol version.
The TDS version being supported by this connection.
Prepare SQL using temporary stored procedures
True if this is a local temporary result set.
Current expected terminator character.
Connection's current maximum field size limit.
The time component of the server datetime value.
The time when this timeout will expire.
Indicates time value not used.
Convert a timestamp from a different Timezone.
Syntax mask for time escape.
Cancel has been generated by a query timeout.
Event to be fired when the timeout expires.
List of TimerRequest
s to execute, ordered by time.
Interface to be implemented by classes that request timer services.
Internal class associating a login or query timeout value with a target
TimerListener
.
Simple timer class used to implement login and query timeouts.
Construct a new TimerThread
instance.
Syntax mask for timestamp escape.
Convert a timestamp to a different Timezone.
Cached value of the datetime as a java.sql.Time
.
Size of TLS record header.
xa_open login string unique to jTDS.
Format an XA transaction ID into a 140 byte array.
Retrieves the current datetime value as a Date.
Convert a byte[] object to a hex string.
The current TDS token byte.
Retrieves the current datetime value as a Time, Date or Timestamp.
Retrieves the current datetime value as a String.
Returns the string form of the object.
Retrieves the procedure or handle name.
Retrieve the unique identifier as a formatted string.
Retrieves the current datetime value as a Time.
Retrieves the current datetime value as a Timestamp.
SQL Server custom transaction isolation level.
Default transaction isolation level.
Truncates the BLOB buffer to the specified size.
Cached value of the datetime as a java.sql.Timestamp
.
Type of statement referenced by this entry.
TLS Application data record.
TLS Change Cipher Spec record type.
TLS Hand shake client hello sub type.
TLS Hand shake client key exchange sub type.
Represents an SQL data type as required by getTypeInfo()
.
This class implements a descriptor for TDS data types;
Construct a new TDS data type descriptor.
Convert java clases to java.sql.Type constant.
types - static field in class net.sourceforge.jtds.jdbc.
TdsData Array of TDS data type descriptors.