ALTERNATE_ SERVER_NAME
|
Specifies the alternate server name used by the
primary and secondary database in a mirrored SAP SQL Anywhere
environment. The primary and secondary database use the same
alternate server name so that client applications can connect to
the current primary server without knowing in advance which of
the two servers is the primary server.
The JDBC URL syntax is jdbc:sybase:Tds:<hostname>:<port#>/database?connection_property=value;.
However, when ALTERNATE_SERVER_NAME is set, SAP jConnect ignores
the values of the hostname
and port variables. Instead,
SAP jConnect uses the SAP SQL Anywhere UDP discovery protocol to
determine the current primary server.
For information about database mirroring, see the
SAP SQL Anywhere Server - Database
Administration Guide.
You can also use ALTERNATE_SERVER_NAME with an SAP SQL Anywhere
server that is not mirrored. However, you will always get the
same host and port values from the singleton server.
Default value is null.
This property is static.
|
APPLICATIONNAME
|
Specifies an application name. This is a user-defined property.
You can program the server side to interpret the value provided
to this property.
Default value is null.
This property is static.
|
BE_AS_JDBC_ COMPLIANT_AS_ POSSIBLE
|
Adjusts other properties to ensure that SAP
jConnect methods respond in a way that is as compliant as
possible with the JDBC 3.0 standard.
These properties are affected (and overridden) when this property
is set to true:
-
CANCEL_ALL (set to false)
-
LANGUAGE CURSOR (set to false)
-
SELECT_OPENS_CURSOR (set to
true)
-
FAKE_METADATA (set to true)
-
GET_BY_NAME_USES_COLUMN_LABEL (set
to false)
Default value is false.
This property is static.
|
CACHE_COLUMN_ METADATA
|
If you repeatedly use PreparedStatement or
CallableStatement objects that perform
SELECT queries, setting
CACHE_COLUMN_METADATA to true might improve
performance. When set to true, the statement remembers the
ResultSet metadata information associated
with the SELECT query results from the first
execution of the statement. On subsequent executions, the
metadata is re-used without being reconstructed. This saves CPU
time through the use of additional memory.
Use the SUPPRESS_ROW_FORMAT connection property when
connecting to SAP Adaptive Server 15.7 ESD #1 and later.
Default value is false.
This property is static.
|
PRE_CACHE_DATATYPE_INFO
|
If you repeatedly use Statement or its derived
interfaces to obtain datatype metadata, setting
PRE_CACHE_DATATYPE_INFO to true might
improve performance.
When PRE_CACHE_DATATYPE_INFO is set to true,
information about all user-defined datatypes that serve various
ResultsetMetadata APIs, like
isCaseSensitive and
isSearchable, is cached at connection
time. Subsequent access to this information is then available
from the cache.
When PRE_CACHE_DATATYPE_INFO is false (the default),
SAP jConnect does not cache any user-defined datatype
information.
Note: Depending on the number of user-defined datatypes that
exist in the database to which the connection is being
obtained, the time it takes to establish the connection may
increase.
Default value is false.
This property is dynamic.
|
CANCEL_ALL
|
Specifies the behavior of the Statement.cancel
method: -
If CANCEL_ALL is false, invoking Statement.cancel cancels
only the Statement object on which it is
invoked. Thus, if stmtA is a Statement object, stmtA.cancel cancels the
execution of the SQL statement contained in stmtA in the database,
but no other statements are affected. stmtA is canceled
whether it is in cache waiting to execute or has
started to execute and is waiting for results.
-
If CANCEL_ALL is true, invoking
Statement.cancel cancels not
only the object on which it is invoked, but also any
other Statement objects on the
same connection that have executed and are waiting
for results.
This example sets CANCEL_ALL to false.
props is a Properties
object for specifying connection
properties: props.put("CANCEL_ALL", "false");
To cancel the execution of all Statement
objects on a connection, regardless of whether or not they have
begun execution on the server, use the extension method
SybConnection.cancel.
This property is static.
|
CAPABILITY_TIME
|
Used only when JCONNECT_VERSION >= 6. When SAP jConnect is
connected to a server that supports the TIME datatype, and all parameters of type java.sql.Time or escape literals {t ...} are
processed as TIME. Versions of
SAP jConnect earlier than 6.0 treat such parameters as DATETIME and prepend '1970-01-01'
to the java.sql.Time parameter. If the underlying
datatype is datetime or
smalldatetime the date
part also gets stored in the database. In SAP jConnect 6.0 or
later, when TIME is processed,
the server converts time to the underlying datatype and prepends
its own base year. This result in incompatibilities between old
and new data. If you are using datetime or smalldatetime datatypes for java.sql.Time, then for backward
compatibility, leave CAPABILITY_TIME as false. Leaving this property as
false forces SAP SAP jConnect to process java.sql.Time parameters or
escape literals {t ...} as
DATETIME regardless of the
server capability of handling TIME datatype. Setting this property to true
causes SAP jConnect to process java.sql.Time parameters as TIME datatype when connected to
SAP Adaptive Server. SAP recommends that you leave this property
as false if you are using smalldatetime or datetime columns to store time values.
Default value is false.
This property is static.
|
CAPABILITY_ WIDETABLE
|
If you do not require JDBC ResultSetMetaData like Column
name as a performance improvement, set this property to false.
The result is that less data is exchanged over the network,
which improves performance. Unless you are using EAServer, SAP
recommends that you use the default setting.
Default value is false.
This property is static.
|
CHARSET
|
Specifies the character set for strings passed
to the database. If the CHARSET value is null, SAP jConnect uses the
default character set of the server to send string data to the server. If you
specify a CHARSET, the
database must be able to handle characters in that format. If
the database cannot do so, a message is generated indicating
that character conversion cannot be properly completed.
If you are using SAP jConnect 6.05 or later and
the DISABLE_UNICHAR_SENDING is
set to false, SAP jConnect detects when a client is trying to
send characters to the server that cannot be represented in the
character set that is being used for the connection. When that
occurs, SAP jConnect sends the character data to the server as
unichar data, which allows
clients to insert Unicode data into unichar/univarchar columns and parameters.
Default value is null.
This property is static.
|
CHARSET_ CONVERTER_CLASS
|
Specifies the character set converter class you
want SAP jConnect to use. SAP jConnect uses the version setting
from SybDriver.setVersion,
or the version passed in with the JCONNECT_VERSION property, to determine the
default character-set converter class to use.
Default value is version dependent.
This property is static.
|
CLASS_LOADER
|
A property you set to an DynamicClassLoader object that you
create. The DynamicClassLoader loads Java classes that are
stored in the database but are not in the CLASSPATH at
application start-up time.
Default value is null.
This property is static.
|
CONNECTION_ FAILOVER
|
Used with the Java Naming and Directory Interface (JNDI).
Default value is true.
This property is static.
|
CRC
|
When this property is set to true, the update counts that are
returned are cumulative counts that include updates directly
affected by the statement executed and any triggers invoked as a
result of the statement being executed.
Default value is false.
This property is static.
|
DATABASE
|
Use this property to specify the database name
for a connection when the connection information is obtained
from a SAP interfaces
file. The URL of an interfaces file cannot supply the database
name.
Default value is null.
This property is static.
|
DEFAULT_QUERY_ TIMEOUT
|
When this connection property is set, it is used as the default
query timeout for any statements created on this connection.
Default value is 0 (no timeout).
This property is dynamic.
|
DELETE_WARNINGS_FROM_EXCEPTION_CHAIN
|
Specifies whether to retain or remove SQLWarning from the
SQLException chain.
Default value is true.
This property is static.
|
DISABLE_UNICHAR_ SENDING
|
When a client application sends unichar characters to the server
(along with non-unichar
characters), there is a slight performance hit for any character
data sent to the database. This property defaults to false in
SAP jConnect 6.05 and later. Clients using older versions of SAP
jConnect who want to send unichar
data to the database must set this property to
false.
Default value is version dependent.
This property is static.
|
DISABLE_ UNPROCESSED_ PARAM_WARNINGS
|
Disables warnings. During results processing for
a stored procedure, SAP jConnect often reads return values other
than row data. If you do not process the return value, SAP
jConnect raises a warning. To disable these warnings (which
might improve performance), set this property to true.
Default value is false.
This property is static.
|
DYNAMIC_PREPARE
|
Determines whether dynamic SQL prepared statements are
precompiled in the database.
Default value is true.
This property is dynamic.
|
EARLY_BATCH_ READ_THRESHOLD
|
Specifies the number of rows after which a reader thread should
be started to drain out the server responses for a batch.
Set this value to -1 if the early read is never required.
Default value is -1.
This property is static.
|
ENABLE_BULK_ LOAD
|
Specifies whether to use bulk load to insert rows to the
database.
Valid values are: -
null – disables bulk load.
-
ARRAYINSERT_WITH_MIXED_STATEMENTS – enables bulk load
with row-level logging and allows your application
to execute other statements during the bulk-load
operation.
-
ARRAYINSERT – enables bulk load with row-level
logging, but your application cannot execute other
statements during the bulk-load operation.
-
BCP – enables bulk load with page-level logging; your
application cannot execute other statements during
the bulk-load operation.
-
LOG_BCP – same as BCP except the complete transaction
is dumped for possible full recovery.
Default value is null.
This property is dynamic.
|
ENABLE_LOB_ LOCATORS
|
Specifies whether SAP jConnect should create a
client-side materialized LOB or server-side LOB locator.
Valid values are:
-
false – SAP jConnect uses
client-side materialized LOBs. That is, the entire
LOB data is processed and cached on the client
side.
-
true – works only when autocommit is set to
false, otherwise internally, the value changes to
false. When set to true, server locators are used
instead of storing the LOB data on client side.
Default value is false.
This property is dynamic.
|
ENABLE_SERVER_ PACKETSIZE
|
Specifies if the connection packet size is set to the value
suggested by the server. If true, the driver does not use
PACKETSIZE connection property, and the
server is free to use any value between 512 and the maximum
packet size. If false, the PACKETSIZE
connection property is used.
Default value is true.
This property is static.
|
ENCRYPT_ PASSWORD
|
Allows a secure login. When this property is true, both login and
remote site passwords are encrypted before being sent to the
server. Passwords are no longer sent in clear text.
ENCRYPT_PASSWORD has precedence over
RETRY_WITH_NO_ENCRYPTION.
Default value is false.
This property is static.
|
ESCAPE_ PROCESSING_ DEFAULT
|
Circumvents processing of JDBC function escapes
in SQL statements. By default, SAP jConnect parses all SQL
statements submitted to the database for valid JDBC function
escapes. If your application is not going to use JDBC function
escapes in its SQL calls, you can set this connection property
to false to avoid this processing, which might provide a slight
performance benefit.
Additionally, ESCAPE_PROCESSING_DEFAULT helps with back-end
servers such as SAP® IQ that use curly braces as part of
the SQL syntax.
Default value is true.
This property is static.
|
EXECUTE_BATCH_ PAST_ERRORS
|
Specifies whether SAP jConnect allows a batch
update operation to ignore nonfatal errors encountered while
executing individual statements and to complete the batch
update, or aborts the batch update operation.
Default value is false.
This property is static.
|
EXPIRESTRING
|
Contains the license expiration date. Expiration is set to Never
except for evaluation copies of SAP jConnect.
Default value is never.
This property is static and read-only.
|
FAKE_METADATA
|
Returns fake metadata. When you call the
ResultSetMetaData methods
getCatalogName, getSchemaName, and
getTableName and this property is true,
the call returns empty strings ("") because the server does not
supply useful metadata.
When this property is false, calling these methods throws a “Not
Implemented” SQLException.
If you have enabled wide tables and are using an
SAP Adaptive Server 12.5 or later, this property setting is
ignored because the server supplies useful metadata.
Default value is false.
This property is static.
|
GET_BY_NAME_ USES_COLUMN_ LABEL
|
Provides backward compatibility with versions of
SAP jConnect earlier than 6.0.
With SAP Adaptive Server version 12.5 and later,
SAP jConnect has access to more metadata than was previously
available. Prior to version 12.5, column name and column
alias meant the same thing. SAP jConnect can now
differentiate between the two when used with a 12.5 or later SAP
Adaptive Server with wide tables enabled.
To preserve backward compatibility, set this property to true. If
you want calls to getByte,
getInt, get* (String
columnName) to look at the actual name for the
column, set this property to false.
Default value is true.
This property is static.
|
GET_COLUMN_ LABEL_FOR_NAME
|
Maintains backward compatibility with SAP
jConnect 5.5 or earlier, where a call to ResultMetaData.getColumnName
returns the column label rather than the column name.
Default value is false.
This property is static.
|
GSSMANAGER_ CLASS
|
Specifies a third-party implementation of the
org.ietf.jgss.GSSManager class.
You can set this property to a string or a
GSSManager object.
If you set the property to a string, the value should be the
fully qualified class name of the third-party GSSManager
implementation. If you set the property to an object, the object
must extend the org.ietf.jgss.GSSManager
class.
Default value is null.
This property is static.
|
HOMOGENEOUS_ BATCH
|
Invokes the SAP Adaptive Server optimized
batching protocol to speed up batch operations for PreparedStatement objects.
Valid values are:
Default value is true.
This property is dynamic.
|
HOSTNAME
|
Identifies the name of the current host.
Default value is none. The max length is 30 characters and, if
exceeded, it is truncated to 30.
This property is static.
|
HOSTPROC
|
Identifies the application process on the host machine.
Default value is none.
This property is static.
|
IGNORE_DONE_IN_ PROC
|
Intermediate update results (as in stored procedures) are not
returned; only the final result set is.
Default value is false.
This property is static.
|
IGNORE_WARNINGS
|
Specifies whether or not to check for and
generate warning messages. This property checks only for
warnings regarding the loss of precision when storing timestamp
values into SAP Adaptive Server date and time
datatypes, which have lower precision than the Java
timestamp.
Valid values are: -
true – SAP jConnect does not check
for and generate warning messages, thus improving
performance.
-
false – the default value, which
directs SAP jConnect to check and generate warning
messages.
Before setting IGNORE_WARNINGS to true,
thoroughly test the impact of such a configuration on your
application.
Default value is false.
This property is static.
|
IMPLICIT_CURSOR_ FETCH_SIZE
|
Use this property with the SELECT_OPENS_CURSOR property to
force SAP jConnect to open a read-only cursor on every select query that is sent to the
database. The cursor has a fetch size of the value set in this
property, unless overridden by the Statement.setFetchSize method.
Default value is 0.
This property is static.
|
INTERNAL_QUERY_ TIMEOUT
|
Use this property to set the query timeout used
by statements internally created and executed by SAP jConnect.
This may prevent application failures if internal commands do
not complete in a reasonable time.
Default value is 0(no timeout).
This property is dynamic.
|
IS_CLOSED_TEST
|
Allows you to specify what query, if any, is sent to the database
when Connection.isClosed is called.
Default value is null.
This property is static.
|
J2EE_TCK_ COMPLIANT
|
When this property is true, the SAP jConnect
driver enables behavior that is compliant with the J2EE 1.4
technology compatibility kit (TCK) test suite, which causes some
loss of performance. Therefore, SAP recommends using the default
value of false.
Default value is false.
This property is static.
|
JAVA_CHARSET_ MAPPING
|
Specifies a user-defined character set mapping
that supersedes the default SAP Adaptive Server character set
mapping.
Default value is none.
This property is static.
|
JCE_PROVIDER_ CLASS
|
Specifies the Java Cryptography Extension (JCE) provider used in
RSA encryption algorithms.
Default value is bundled JCE provider.
This property is static.
|
JCONNECT_VERSION
|
Sets version-specific characteristics.
Default value is 7.
This property is static.
|
LANGUAGE
|
Specifies the language in which messages from
SAP jConnect and the server appear. The setting must match a
language in syslanguages
because server messages are localized according to the language
setting in your local environment. The languages supported are
Chinese, US English, French, German, Japanese, Korean, Polish,
Portuguese, and Spanish.
Default value is version dependent.
This property is static.
|
LANGUAGE_ CURSOR
|
Determines that SAP jConnect uses language
cursors instead of protocol cursors.
Default value is false.
This property is static.
|
LITERAL_PARAMS
|
When true, any parameters set by the setXXX
methods in the PreparedStatement interface
are inserted literally into the SQL statement when it is
executed.
If false, parameter markers are left in the SQL statement and the
parameter values are sent to the server separately.
Default value is false.
This property is static.
|
NEWPASSWORD
|
Specifies the new password used in password expiration
handling.
Default value is null.
This property is static.
|
OPTIMIZE_FOR_ PERFORMANCE
|
Specifies whether or not to enable SAP jConnect
performance-enhancing properties. This property controls only
the IGNORE_WARNINGS
property.
Valid values are: -
true – SAP jConnect runs in enhanced
performance mode.
-
false – the default value, which
means that SAP jConnect runs in normal mode.
Before setting OPTIMIZE_FOR_PERFORMANCE to true,
thoroughly test the impact of such a configuration on your
application.
Default value is false.
This property is static.
|
OPTIMIZE_STRING_ CONVERSIONS
|
Specifies whether or not to enable string conversion
optimization.
This optimization behavior might improve SAP
jConnect performance when a client uses character datatypes in
SQL prepared statements.
Valid values are:
-
0 – string conversion optimization is not
enabled.
-
1 – enables string conversion
optimization when SAP jConnect uses UTF8 or server
default character set.
-
2 – enables string conversion optimization for
all cases.
Default value is 0.
This property is static.
|
PACKETSIZE
|
Identifies the network packet size. If you are
using SAP Adaptive Server 15.0 or later, SAP recommends that you
do not set this property, and allow SAP jConnect and SAP
Adaptive Server to select the network packet size that is
appropriate for your environment.
Default value is 512.
This property is static.
|
PASSWORD
|
Identifies the login password.StringString.
Set automatically if using the getConnection(String,
String, String), method, or explicitly if
using getConnection(String, Props).
Default value is none.
This property is static.
|
PRELOAD_JARS
|
Contains a comma-separated list of .jar file names that are
associated with the CLASS_LOADER that you specify. These .jar files are loaded at connect
time, and are available for use by any other connection using
the same SAP jConnect driver.
Default value is null.
This property is static.
|
PROMPT_FOR_ NEWPASSWORD
|
Specifies whether to perform a transparent password change or to
prompt for the new password.
Valid values are: -
true – prompts you to manually set the new
password.
-
false – SAP jConnect checks the
value of NEWPASSWORD and, if it is not null, uses
this value to replace the expired password.
Default value is false.
This property is static.
|
PROTOCOL_ CAPTURE
|
Specifies a file for capturing TDS communication
between an application and an SAP Adaptive Server.
Default value is null.
This property is dynamic.
|
PROXY
|
Specifies a gateway address. For the HTTP protocol, the URL is
http://host:port.
To use the HTTPS protocol that supports encryption, the URL is
https://host:port/servlet_alias.
Default value is none.
This property is static.
|
QUERY_TIMEOUT_ CANCELS_ALL
|
Forces SAP jConnect to cancel all statements on
a connection when a read timeout is encountered. This behavior
can be used when a client has calls execute() and the timeout occurs because of a
deadlock (for example, trying to read from a table that is
currently being updated in another transaction).
Default value is false.
This property is dynamic.
|
RELEASE_LOCKS_ON_CURSOR_ CLOSE
|
Specifies whether SAP Adaptive Server releases
shared read-only cursor locks at isolation levels 2 and 3 when a
cursor is closed:
Default value is false.
This property is static.
|
REMOTEPWD
|
Contains remote server passwords for access through
server-to-server remote procedure calls.
Default value is none.
This property is static.
|
REPEAT_READ
|
Determines whether the driver keeps copies of columns and output
parameters so that columns can be read out of order or
repeatedly.
Default value is true.
This property is static.
|
REQUEST_HA_ SESSION
|
Indicates whether the connecting client wants to begin a high
availability (HA) failover session.
You cannot reset the property once a connection has been made.
For additional flexibility for requesting failover sessions,
code the client application to set
REQUEST_HA_SESSION at runtime.
Setting this property to true causes SAP
jConnect to attempt a failover login. If you do not set this
connection property, a failover session does not start, even if
the server is configured for failover.
Default value is false.
This property is static.
|
REQUEST_ KERBEROS_SESSION
|
Determines whether SAP jConnect uses Kerberos
for authentication. If you set this property to true, you must
also enter a value for the SERVICE_PRINCIPAL_NAME property.
You may also want to provide a value for the
GSSMANAGER_CLASS property.
Default value is false.
This property is static.
|
RETRY_WITH_NO_ ENCRYPTION
|
Allows server to retry logging in using clear text passwords.
When both ENCRYPT_PASSWORD and RETRY_WITH_NO_ENCRYPTION properties are set to
true, SAP jConnect first logs in using the encrypted password.
If login fails, SAP jConnect logs in using the clear text
password.
Default value is false.
This property is static.
|
RMNAME
|
Sets the Resource Manager name when using distributed
transactions (XA). This property overrides a Resource Manager
name that may be set in an LDAP server entry.
Default value is null.
This property is static.
|
SECONDARY_ SERVER_HOSTPORT
|
Sets the host name and port for the secondary server when the
client is using an HA failover session. The value for this
property should be in the form of
hostName:portNumber. This property is
ignored unless you have also set
REQUEST_HA_SESSION to true.
Default value is null.
This property is static.
|
SELECT_OPENS_ CURSOR
|
Determines whether calls to
Statement.executeQuery automatically
generate a cursor when the query contains a FOR
UPDATE clause.
If you have previously called
Statement.setFetchSize or
Statement.setCursorName on the same
statement, a setting of true for
SELECT_OPENS_CURSOR has no effect.
You may experience some performance degradation when
SELECT_OPENS_CURSOR is set to true.
Default value is false.
This property is static.
|
SEND_BATCHPARAMS_IMMEDIATE
|
Specifies whether SAP jConnect sends the
parameters for the current row immediately after invoking
PreparedStatement.addBatch() or only after
invoking PreparedStatement.executeBatch(). -
true – SAP jConnect sends the
parameters for the current row immediately after
invoking PreparedStatement.addBatch(). This
minimizes usage of client memory and gives the
server more time to process the batch
parameters.
-
false – SAP jConnect sends the batch
parameters only after invoking PreparedStatement.executeBatch().
Default value is false.
This property is dynamic.
|
SERIALIZE_ REQUESTS
|
Determines whether SAP jConnect waits for
responses from the server before sending additional
requests.
Default value is false.
This property is static.
|
SERVER_INITIATED_ TRANSACTIONS
|
Allows the server to control transactions. By
default the property is set to true and SAP jConnect lets the
server start and control transactions by using the SAP
Transact-SQL command set chained
on. If set to false, the transactions are started
and controlled by SAP jConnect by using the Transact-SQL command
begin tran. SAP
recommends that you allow the server to control the
transactions.
Default value is true.
This property is static.
|
SERVICENAME
|
Indicates the name of a back-end database server
that a DirectConnect gateway serves. Also used to indicate which
database to use upon connecting to SAP SQL Anywhere.
Default value is none.
This property is static.
|
SERVERTYPE
|
When connected to an SAP® Open
Switch™, set this property to OSW, which allows SAP
jConnect to send certain instructions to SAP Open Switch that
allows SAP Open Switch to remember initial connection settings
for example, isolation level, textsize, quoted identifier and
autocommit when SAP Open Switch redirects a connection to a
different server instance.
Default value is none.
This property is static.
|
SERVICE_ PRINCIPAL_NAME
|
Used when establishing a Kerberos connection to
SAP Adaptive Server. The value of this property should
correspond both to the server entry in your key distribution
center (KDC) and to the server name under which your database is
running.
The value of the SERVICE_PRINCIPAL_NAME property
is ignored if the REQUEST_KERBEROS_SESSION
property is set to false.
Default value is null.
This property is static.
|
SESSION_ID
|
A TDS session ID. When this property is set, SAP
jConnect assumes that an application is trying to resume
communication on an existing TDS session held open by the
TDS-tunnelling gateway. SAP jConnect skips the login
negotiations and forwards all requests from the application to
the specified session ID.
Default value is null.
This property is static.
|
SESSION_TIMEOUT
|
Specifies the amount of time, in seconds, that
an HTTP-tunnelled session (created using the SAP jConnect
TDS-tunnelling servlet) remains alive while idle. After the
specified time, the connection is automatically closed.
Default value is null.
This property is static.
|
SETMAXROWS_ AFFECTS_SELECT_ ONLY
|
Specifies whether setMaxRows limits only the
rows returned by select statements to be
consistent with the JDBC specification.
Valid values are: -
true – Statement.setMaxRows(int
max) limits only the number of rows
returned as a result of the
select statements.
-
false – Statement.setMaxRows(int
max) limits the number of rows returned
as a result of the select,
insert,
update, and
delete statements.
SETMAXROWS_AFFECTS_SELECT_ONLY is ignored when
connected to SAP Adaptive Server 15.5 or earlier.
Default value is true.
This property is static.
|
SQLINITSTRING
|
Defines a set of commands to be passed to the database server
when a connection is opened. These must be SQL commands that can
be executed using the Statement.executeUpdate
method.
Default value is null.
This property is static.
|
STREAM_CACHE_ SIZE
|
Specifies the maximum size used to cache statement response
streams.
Default value is null (unlimited cache size).
This property is dynamic.
|
STRIP_BLANKS
|
Forces the server to remove the preceding and trailing blanks in
a string value before storing it in the table.
Valid values are:
Default value is false.
This property is static.
|
SUPPRESS_ CONTROL_TOKEN
|
Suppresses control tokens.
Valid values are:
Default value is false.
This property is static.
|
SUPPRESS_PARAM_ FORMAT
|
When executing dynamic SQL prepared statements,
SAP jConnect client can use the SUPPRESS_PARAM_FORMAT connection string property
to suppress parameter format metadata. The client sends less
parameter metadata where possible for better performance.
Valid values are:
-
false – parameter format metadata is
not suppressed in select, insert, and update
operations.
-
true – the default value; parameter
format metadata is suppressed where possible.
Default value is true.
This property is static.
|
SUPPRESS_ROW_ FORMAT
|
In SAP jConnect, client can use the SUPPRESS_ROW_FORMAT connection
string property to force SAP Adaptive Server to send TDS_ROWFMT
or TDS_ROWFMT2 data only when the row format changes for a
dynamic SQL prepared statement. SAP Adaptive Server can send
less data to the client if possible, resulting in better
performance.
Valid values are:
-
false – TDS_ROWFMT or TDS_ROWFMT2
data is sent, even if the row format has not
changed.
-
true – the default; forces the
server to send TDS_ROWFMT or TDS_ROWFMT2 only when
the row format has changed.
Default value is true.
This property is static.
|
SUPPRESS_ROW_ FORMAT2
|
Specifies that SAP Adaptive Server is to send
data using the TDS_ROWFMT byte sequence where possible instead
of the TDS_ROWFMT2 byte sequence.
When connected to SAP Adaptive Server 15.7 ESD
#1 or later, use the SUPPRESS_ROW_FORMAT connection property
instead.
Default value is false.
This property is static.
|
SYBSOCKET_ FACTORY
|
Enables SAP jConnect to use your custom socket
implementation.
Set SYBSOCKET_FACTORY either to: -
The name of a class that implements
com.sybase.jdbcx.SybSocketFactory;
or
-
DEFAULT, which instantiates a new
java.net.Socket( )
Use this property to make an SSL connection to your database.
Default value is null.
This property is static.
|
TEXTSIZE
|
Allows you to set the text size. By default, SAP
Adaptive Server and SAP SQL Anywhere allow 32,627 bytes to be
read from an image or text column. If you have the SAP jConnect
Meta Data tables installed, SAP jConnect changes that value to
2GB. However, setting this value when connected to SAP Open
Switch allows the connection to remember the setting when SAP
Open Switch redirects a connection to a different server
instance.
Default value is 2GB.
This property is static.
|
USE_METADATA
|
Creates and initializes a DatabaseMetaData
object when you establish a connection. The
DatabaseMetaData object is necessary to
connect to a specified database.
SAP jConnect uses DatabaseMetaData for some features, including
Distributed Transaction Management support (JTA/JTS) and dynamic
class loading (DCL).
If you receive error 010SJ, which indicates that
your application requires metadata, install the stored
procedures for returning metadata that come with SAP jConnect.
See Installing Stored Procedures
in the jConnect for JDBC Installation
Guide.
Default value is true.
This property is static.
|
USER
|
Specifies the login ID.
Set automatically if using the getConnection(String,
String, String) method, or explicitly if using
getConnection(String, Props).
Default value is none.
This property is static.
|
VERSIONSTRING
|
Provides read-only version information for the JDBC driver.
Default value is SAP jConnect driver
version.
This property is static.
|