Search Search. NET OData. Contact Us. These differences are within the allowable error of the double and float data types. The amount of time, in seconds, the driver waits for a connection to be established before returning control to the application and throwing a timeout exception.
If set to 0 the default , the driver does not time out a connection request. Determines whether the driver caches long data images, pictures, long text, or binary data in result sets. 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. If set to -1, the driver does not cache long data in result sets. It is cached on the server. Use this value only if your application retrieves columns in the order in which they are defined in the result set.
If set to 0, the driver caches long data in result sets in memory. If set to x, where x is a positive integer, the driver caches long data in result sets in memory and uses this value to set the size in KB of the memory buffer for caching result set data. Determines the number of bytes for each database protocol packet transferred from the database server to the client machine Sybase refers to this packet as a network packet.
Adjusting the packet size can improve performance. 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. Typically, larger packet sizes work better for large amounts of data.
For example, if an application regularly returns character values that are 10, characters in length, using a value of 32 16 KB typically results in improved performance. If set to 0, the driver uses the default maximum packet size used by the database server. If set to x, an integer from 1 to , the driver uses a packet size that is a multiple of bytes.
The case-sensitive password used to connect to your Sybase database. A password is required only if security is enabled on your database. If so, contact your system administrator to get your password. The TCP port of the primary database server that is listening for connections to the Sybase database. This property is supported only for data source connections.
Determines whether stored procedures are created on the server for prepared statements. If set to StoredProc, a stored procedure is created when the statement is prepared and is executed when the prepared statement is executed.
If set to StoredProcIfParam, a stored procedure is created only if the prepared statement contains one or multiple parameter markers. In this case, it is created when the statement is prepared and is executed when the prepared statement is executed. If the statement does not contain parameter markers, a stored procedure is not created and the statement is executed directly.
If set to Direct, a stored procedure is not created for the prepared statement and the statement is executed directly. A stored procedure may be created if parameter metadata is requested. Setting this property to StoredProc or StoredProclfParam can improve performance if your application executes prepared statements multiple times because, once created, executing a stored procedure is faster than executing a single SQL statement. If a prepared statement is only executed once or is never executed, performance can decrease because creating a stored procedure incurs more overhead on the server than simply executing a single SQL statement.
Setting this property to Direct should be used if your application does not execute prepared statements multiple times. Sets the default query timeout in seconds for all statements created by a connection. If set to a positive integer, the driver uses the value as the default timeout for any statement created by the connection. To override the default timeout value set by this connection option, call the Statement.
If set to -1, the query timeout functionality is disabled. The driver silently ignores calls to the Statement. If set to 0 the default , the default query timeout is infinite the query does not time out. The Sybase driver can return table name information in the ResultSet metadata for Select statements if your application requires that information. If set to 0 the default and the ResultSetMetaData. In this case, the getTableName method may return an empty string for each column in the result set.
If set to 1 and the ResultSetMetaData. The driver also can return schema name and catalog name information when the ResultSetMetaData. A hint to the driver that determines whether the driver requests a database cursor for Select statements. Performance and behavior of the driver are affected by this property, which is defined as a hint because the driver may not always be able to satisfy the requested method. If set to direct the default , the database server sends the complete result set in a single response to the driver when responding to a query.
A server-side database cursor is not created. Typically, responses are not cached by the driver. Using this method, the driver must process the entire response to a query before another query is submitted. If another query is submitted using a different statement on the same connection, for example , the driver caches the response to the first query before submitting the second query. Typically, the direct method performs better than the cursor method.
If set to cursor, a server-side database cursor is requested. When returning forward-only result sets, the rows are retrieved from the server in blocks. The setFetchSize method can be used to control the number of rows that are returned for each request. Performance tests show that, when returning forward-only result sets, the value of Statement. There is no simple rule for determining the setFetchSize value that you should use.
We recommend that you experiment with different setFetchSize values to determine which value gives the best performance for your application. The cursor method is useful for queries that produce a large amount of data, particularly if multiple open result sets are used. Specifies either the IP address or the server name if your network supports named servers of the primary database server.
For example, Specifies the case-sensitive service principal name to be used by the driver for Kerberos authentication. For Sybase, the service principal name is the name of a server configured in your Sybase interfaces file. If you set this property, you also must set the value of the AuthenticationMethod property to Kerberos. The value of this property can include the Kerberos realm name, but it is optional.
If you do not specify the Kerberos realm name, the default Kerberos realm is used. When Kerberos authentication is not used, this property is ignored.
Specifies the directory of the truststore file to be used when SSL server authentication is used. The truststore file contains a list of the Certificate Authorities CAs that the client trusts. This value overrides the directory of the truststore file specified by the javax.
If this property is not specified, the truststore directory is specified by the javax. Specifies the password of the truststore file to be used when SSL server authentication is used.
This value overrides the password of the truststore file specified by the javax. If this property is not specified, the truststore password is specified by the javax. The case-insensitive user name used to connect to your Sybase database. A user name is required only if security is enabled on your database.
If so, contact your system administrator to get your user name. Your application contains queries that return large amounts of data. Learn about the latest features including in the CData Connect Cloud data connectivity platform. CData provides critical integration software to support process automation for local government.
All of our drivers are designed and engineered specifically for each of the driver technologies below. Please download a free day trial of the Sybase Driver that matches your intended environment. Version: Sybase ADO. NET applications that integrate wi Previous versions may be available via the product download archive. CData Software is a leading provider of data access and connectivity solutions. For example, Password is the same as password.
Table Sybase Connection Properties. Determines the method used to execute batch operations. If set to true, the native Sybase batch mechanism is used. If set to false, the JDBC 3. In most cases, using the native Sybase batch functionality provides significantly better performance, but the driver may not always be able to return update counts for the batch. See Batch Inserts and Updates. Specifies the code page the driver uses when converting character data.
The specified code page overrides the default database code page. All character data retrieved from or written to the database is converted using the specified code page.
The number of times the driver retries connections to a database server until a successful connection is established. Valid values are 0 and any positive integer. The number of seconds the driver waits before retrying connections to a database server when ConnectionRetryCount is set to a positive integer. Determines the amount of memory used by the driver to cache insensitive result set data. It must have one of the following values:. If set to -1, the driver caches all insensitive result set data in memory.
If the size of the result set exceeds available memory, an OutOfMemoryException is generated. Because the need to write result set data to disk is eliminated, the driver processes the data more efficiently. If set to 0, the driver caches all insensitive result set data in memory, up to a maximum of 2 GB. If the size of the result set data exceeds available memory, the driver pages the result set data to disk. Because result set data may be written to disk, the driver may have to reformat the data to write it correctly to disk.
If set to x , where x is a positive integer, the driver caches all insensitive result set data in memory, using this value to set the size in KB of the memory buffer for caching insensitive result set data.
If the size of the result set data exceeds the buffer size, the driver pages the result set data to disk. Because the result set data may be written to disk, the driver may have to reformat the data to write it correctly to disk. Specifying a buffer size that is a power of 2 results in more efficient memory use.
0コメント