Installing the Sybase JDBC driver

Sybase 15 Driver Jdbc

ConnectionRetryCount Number of times the driver retries the primary database server, and if specified, alternate servers until a successful connection is established. The default is false client load balancing is disabled.

Configuring Kerberos Authentication This section provides requirements and instructions for configuring Kerberos authentication for the Sybase driver. Controls how the driver delimits the start of a local transaction.

Driver Classes

The jConnect Driver Files

The jConnect Driver Files

If client load balancing is enabled, the driver uses a random pattern instead of a sequential pattern in its attempts to connect. Determines whether the driver uses client load balancing in its attempts to connect to the database servers primary and alternate. If the values do not match, the connection fails and the driver throws an exception. When the driver's internal prepared statement pooling is enabled, the driver caches a certain number of prepared statements created by an application. See Using the AuthenticationMethod Property for information about setting the value for this property.

If the port number is unspecified, the port number specified for the primary server is used. If any one validation succeeds, a connection is established. If your application returns long data column values out of order, long data values must be cached on the client.

If the port number of the primary server is unspecified, the default port number of is used. Specifies whether the driver uses the native bulk load protocols in the database instead of the batch mechanism for batch inserts.

You use the ConnectionRetryCount and ConnectionRetryDelay properties to enable and control how connection retry works. This property allows existing applications with batch inserts to take advantage of bulk load without requiring changes to the application code.

The failover method you want the driver to use. LoadBalancing Sets whether the driver will use client load balancing in its attempts to connect to database servers primary and alternate. If the port is unspecified, the port number of the primary server is used.

Adjusting the packet size can improve performance. Setting this property to Direct should be used if your application does not execute prepared statements multiple times.

The jConnect JDBC Driver

See Using the AuthenticationMethod Property for more information about setting a value for this property. The maximum number of pooled prepared statements for this connection. Using this method, the driver must process the entire response to a query before another query is submitted.

The jConnect JDBC Driver

This property is supported only for data source connections. To override the default timeout value set by this connection option, call the Statement.

Sybase JDBC Driver and URL Information

Optionally, set the FailoverPreconnect property if you want the driver to establish a connection with the primary and an alternate server at the same time. The value of this property can include the Kerberos realm name, but it is optional. Typically, the direct method performs better than the cursor method. Table Sybase Connection Properties. The AuthenticationMethod connection property controls which authentication mechanism the driver uses when establishing connections.

For each column in a result set that maps to a column in a table in the database, the Sybase driver returns the table name associated with that column. By default, the Sybase driver skips the additional processing required to return the correct table name for each column in the result set when the ResultSetMetaData. This section provides requirements and instructions for configuring Kerberos authentication for the Sybase driver. This means that the driver, not Sybase, same day courier drivers wanted starts a new transaction if the previous transaction was committed or rolled back. An auto-generated key returned by the Sybase driver is the value of an identity column.

Your database may impose character length restrictions on the value. In this case, performance can be improved by increasing the amount of memory used by the driver before writing data to disk. Because data is cached, you will incur a performance penalty, particularly if the data is read once sequentially. Set this property to true to allow existing applications with batch inserts to take advantage of bulk load without requiring changes to the code. Similar to batch operations, performance improves because far fewer network round trips are required.

Determines which authentication method the driver uses when establishing a connection. An alias for the MaxPooledStatements property. In this case, the getTableName method may return an empty string for each column in the result set. Because result set data may be written to disk, the driver may have to reformat the data to write it correctly to disk.

If this occurs, use the explicit value for this property. DatabaseName The name of the database to which you want to connect. If the value set for this property is greater than the number of prepared statements used by the application, all prepared statements are cached. To improve performance, you can disable long data caching if your application retrieves columns in the order in which they are defined in the result set. Controls how data conversions are handled for null values.

JDBC Drivers

Accounting information to be stored in the database. PacketSize Typically, it is optimal for the client to use the maximum packet size that the server allows.

If this property is not specified, the truststore password is specified by the javax. If a result set that contains only one or two rows of data does not completely fill a larger packet, performance will not improve by setting the value to the maximum packet size. Be aware that increasing the number of rows that are loaded also causes the driver to consume more memory on the client.

When this property is specified, statements are imported into the statement pool from the specified file. If the cancel request times out, because the server is down, for example, the driver throws an exception indicating that the cancel request was timed out and the connection is no longer valid. The Password property provides the password. String InsensitiveResultSetBufferSize Determines the amount of memory used by the driver to cache insensitive result set data. The optimal value depends on the typical size of data inserted, updated, or returned by the application and the environment in which it is running.

Sybase 15 driver jdbc

The default is false the driver tries to connect to an alternate server only when failover is caused by an unsuccessful connection attempt or a lost connection. You can specify one or multiple alternate servers by setting the AlternateServers property. To improve performance when using scroll-insensitive result sets, the driver can cache the result set data in memory instead of writing it to disk. If the value exceeds a restriction, the driver truncates it. For example, if your application calls Statement.