jConnect Connection Properties

The connection properties for jConnect and their default values.

These properties are not case-sensitive.

You can use the getClientInfo() and setClientInfo() standard methods to dynamically set the properties indicated as such.

Connection Properties
Property	Description
ALTERNATE_ SERVER_NAME	Specifies the alternate server name used by the primary and secondary database in a mirrored 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, jConnect ignores the values of the `hostname` and `port` variables. Instead, jConnect uses the SQL Anywhere UDP discovery protocol to determine the current primary server. For information about database mirroring, see the SQL Anywhere Server - Database Administration Guide. You can also use `ALTERNATE_SERVER_NAME` with an 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 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 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), 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. Default values are: true – for `JCONNECT_VERSION` <= “3” false – for `JCONNECT_VERSION` >= “4” This property is static.
CAPABILITY_TIME	Used only when `JCONNECT_VERSION` >= 6. When 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 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 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 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 jConnect to process `java.sql.Time` parameters as `TIME` datatype when connected to Adaptive Server. Sybase 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, Sybase 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, 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 jConnect 6.05 or later and the `DISABLE_UNICHAR_SENDING` is set to false, 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, 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 jConnect to use. 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 Sybase 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. Values: true – jConnect removes SQLWarning objects from the SQLException chain. false – jConnect retains the SQLWarning objects in 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 jConnect 6.05 and later. Clients using older versions of 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, jConnect often reads return values other than row data. If you do not process the return value, 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 jConnect should create a client-side materialized LOB or server-side LOB locator. Valid values are: false – 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, 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 Sybase 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 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. Valid values are: true – allows a batch update operation to ignore nonfatal errors encountered and to complete the batch update. false – aborts a batch update when a nonfatal error is encountered. Default value is false. This property is static.
EXPIRESTRING	Contains the license expiration `date`. Expiration is set to Never except for evaluation copies of 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 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 jConnect earlier than 6.0. With Adaptive Server version 12.5 and later, jConnect has access to more metadata than was previously available. Prior to version 12.5, `column name` and `column alias` meant the same thing. jConnect can now differentiate between the two when used with a 12.5 or later 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 jConnect 5.5 or earlier, where a call to ResultMetaData.getColumnName returns the column label rather than the column name. Valid values are: true – ResultMetaData.getColumnName returns column label. false – ResultMetaData.getColumnName returns 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 Adaptive Server optimized batching protocol to speed up batch operations for PreparedStatement objects. Valid values are: true – optimized batching protocol is used. false – unoptimized batching protocol is used even if jConnect is connected to an Adaptive Server that supports new optimized batching protocol. 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 Adaptive Server `date` and `time` datatypes, which have lower precision than the Java timestamp. Valid values are: true – jConnect does not check for and generate warning messages, thus improving performance. false – the default value, which directs 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 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 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 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, Sybase 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 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 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 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 jConnect performance-enhancing properties. This property controls only the `IGNORE_WARNINGS` property. Valid values are: true – jConnect runs in enhanced performance mode. false – the default value, which means that 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 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 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 Adaptive Server 15.0 or later, Sybase recommends that you do not set this property, and allow jConnect and 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 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 – 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 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 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 Adaptive Server releases shared read-only cursor locks at isolation levels 2 and 3 when a cursor is closed: false – does not enable shared cursor locks release on close. true – enables shared cursor locks release on close. 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 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 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, jConnect first logs in using the encrypted password. If login fails, 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 jConnect sends the parameters for the current row immediately after invoking PreparedStatement.addBatch() or only after invoking PreparedStatement.executeBatch(). true – 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 – jConnect sends the batch parameters only after invoking PreparedStatement.executeBatch(). Default value is false. This property is dynamic.
SERIALIZE_ REQUESTS	Determines whether 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 jConnect lets the server start and control transactions by using the Transact-SQL command set chained on. If set to false, the transactions are started and controlled by jConnect by using the Transact-SQL command begin tran. Sybase 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 SQL Anywhere. Default value is none. This property is static.
SERVERTYPE	When connected to OpenSwitch, set this property to OSW, which allows jConnect to send certain instructions to OpenSwitch that allows OpenSwitch to remember initial connection settings for example, isolation level, textsize, quoted identifier and autocommit when OpenSwitch 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 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, jConnect assumes that an application is trying to resume communication on an existing TDS session held open by the TDS-tunnelling gateway. 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 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 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: false – string values sent by the client are stored as is. true – preceding and trailing blanks in a string value are removed before storing it in the table. Default value is false. This property is static.
SUPPRESS_ CONTROL_TOKEN	Suppresses control tokens. Valid values are: false – control tokens are sent. true – control tokens are suppressed. Default value is false. This property is static.
SUPPRESS_PARAM_ FORMAT	When executing dynamic SQL prepared statements, 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 jConnect, client can use the `SUPPRESS_ROW_FORMAT` connection string property to force Adaptive Server to send TDS_ROWFMT or TDS_ROWFMT2 data only when the row format changes for a dynamic SQL prepared statement. 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 Adaptive Server is to send data using the TDS_ROWFMT byte sequence where possible instead of the TDS_ROWFMT2 byte sequence. Valid values are: false – the default value; TDS_ROWFMT2 is not suppressed. true – forces the server to send data in TDS_ROWFMT where possible. When connected to 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 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, Adaptive Server and SQL Anywhere allow 32,627 bytes to be read from an image or text column. If you have the jConnect Meta Data tables installed, jConnect changes that value to 2GB. However, setting this value when connected to OpenSwitch allows the connection to remember the setting when OpenSwitch 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. 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 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 jConnect driver version. This property is static.