Jdbc driver sybase

(Optional, replication only) To use latency monitoring (rs_ticket) in a replication environment to measure latency to non-Sybase replicate databases, you must install JDBC™ drivers to enable Sybase Control Center for Replication to connect to those replicate databases. You can install JDBC drivers at any time after installing Sybase Control Center, even if the Sybase Control Center server is already running.Download the JDBC drivers for your databases. Drivers are typically available with the database server or on the database vendor’s Web site. Oracle 9i, 10g, 11g Driver – Oracle JDBC Thin Driver 11.1 for use with JDK 1.5 (ojdbc5.jar) Microsoft SQL Server 2005 and 2008 Driver – Microsoft SQL Server JDBC Driver 2.0 (sqljdbc.jar) IBM DB2 UDB 8.22, 9.1, 9.5 Driver – IBM DB2 for Unix, Linux, and Windows JDBC Driver 9 (db2jcc.jar and db2jcc_license_cu.jar) Place the drivers in: Windows – %SYBASE%\SCC-3_2\plugins\RMAP\lib UNIX – $SYBASE/SCC-3_2/plugins/RMAP/lib If Sybase Control Center is running, stop it and start it again.

Disables the Client Home Directory and Client OCS Directory controls.Client Home DirectoryBrowse to the root directory of the client to be used.Client OCS DirectorySelect the OCS- directory corresponding to the client version that you want to use.Connection SettingsSQL INI FileBrowse to locate and select the specific, SQL.INI-formatted file containing server-configuration information. The file does not have to be named SQL.INI.Packet Size, Max Connections, and Client Character SetThese settings let you create a set of default parameters used in setting up connections to Sybase ASE datasources. These settings can be overridden when registering a Sybase ASE datasource. For details, see Providing Sybase ASE Connection Information When Registering Datasources.Default Driver SelectionBy default, when you register a datasource, the native driver is automatically selected as the default connection option.NOTE: For details on native driver and JDBC driver support, see the ReadMe file selecting View > Release Notes.The controls in this group let you specify one of the installed or packaged DBMS platform-specific JDBC drivers as the default connection option.Connect using JDBC instead of the Sybase Open ClientFor platforms for which a native driver is supported, this check box enables selection of a JDBC driver as the default connection option.For platforms for which no native driver is available, this check box is disabled.JDBC driver to useIf multiple JDBC drivers are available for this platform, this control lets you select the specific JDBC driver to use as the default.Assign to all disconnected DatasourcesThis control lets you assign either the native driver or the currently selected JDBC driver as the connection option for all datasources defined on the relevant DBMS platform that are currently not connected. If the Connect using JDBC instead of the Sybase Open Client setting is selected, all disconnected datasources are assigned the driver selected from the JDBC driver to use list as the connection option. Otherwise, the native driver is assigned to all disconnected datasources on this DBMS platform.Connection Options - Sybase IQThe Connection > Sybase IQ tab of the Options Editor lets you specify DBMS-specific connection options.Note: For information on opening the Options Editor, see Specifying Application Preferences and Feature Options.Note:

WebLogic Type 4 JDBC Drivers The following sections describe how to configure and use the BEA WebLogic Type 4 JDBC Sybase driver:Database Version SupportDriver ClassesSybase URLSybase Connection PropertiesData TypesSQL Escape SequencesIsolation LevelsUsing Scrollable CursorsLarge Object (LOB) SupportBatch Inserts and UpdatesParameter Metadata SupportAuto-Generated Keys SupportSybase JTA SupportDatabase Version SupportThe BEA WebLogic Type 4 JDBC driver for Sybase (the "Sybase driver") supports the following database versions:Sybase Adaptive Server 11.5 and 11.9Sybase Adaptive Server Enterprise 12.0, 12.5, and 12.5.1Note: XA connections are supported with the Sybase Adaptive Server Enterprise 12.0 and later versions only. XA connections are not supported on Sybase Adaptive Server 11.5 and 11.9.Driver ClassesThe driver class for the BEA WebLogic Type 4 JDBC Sybase driver is:XA: weblogic.jdbcx.sybase.SybaseDataSourceNon-XA: weblogic.jdbc.sybase.SybaseDriverUse these driver classes when configuring a JDBC data source in your WebLogic Server domain.Sybase URLTo connect to a Sybase database, use the following URL format:jdbc:bea:sybase://dbserver:portSybase Connection PropertiesTable 7-1 lists the JDBC connection properties supported by the Sybase driver, and describes each property. You can use these connection properties in a JDBC data source configuration in your WebLogic Server domain. To specify a property, use the following form in the JDBC data source configuration:property=valueNote: All connection string property names are case-insensitive. For example, Password is the same as password.Table 7-1 Sybase Connection Properties Property Description BatchPerformanceWorkaroundOPTIONAL {true | false}. 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.0-compliant batch mechanism is used. 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. The default is false.See Batch Inserts and Updates. CodePageOverrideOPTIONAL 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 value must be a string containing the name of a valid code page supported by your Java Virtual Machine, for example, CodePageOverride=CP950. ConnectionRetryCountOPTIONAL 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 default is 0. ConnectionRetryDelayOPTIONAL The number of seconds the driver waits before retrying connections to a database server when ConnectionRetryCount is set to a positive integer.The default is 3. DatabaseNameOPTIONAL The name of the database to which you want to connect. InsensitiveResultSetBufferSizeOPTIONAL {-1 | 0 | x}. 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,

Editor lets you specify DBMS-specific connection options.Note: For information on opening the Options Editor, see Specifying Application Preferences and Feature Options.Note: For more general connectivity options, see Connection Options.GroupSettingDescriptionDefault Driver SelectionBy default, when you register a datasource, the native driver is automatically selected as the default connection option.NOTE: For details on native driver and JDBC driver support, see the ReadMe file selecting View > Release Notes.The controls in this group let you specify one of the installed or packaged DBMS platform-specific JDBC drivers as the default connection option.Connect using JDBC instead of the PostgreSQL ODBC driverFor platforms for which a native driver is supported, this check box enables selection of a JDBC driver as the default connection option.For platforms for which no native driver is available, this check box is disabled.JDBC driver to useIf multiple JDBC drivers are available for this platform, this control lets you select the specific JDBC driver to use as the default.Assign to all disconnected DatasourcesThis control lets you assign either the native driver or the currently selected JDBC driver as the connection option for all datasources defined on the relevant DBMS platform that are currently not connected. If the Connect using JDBC instead of the PostgreSQL ODBC driver setting is selected, all disconnected datasources are assigned the driver selected from the JDBC driver to use list as the connection option. Otherwise, the native driver is assigned to all disconnected datasources on this DBMS platform.Connection Options - SybaseThe Connection > Sybase tab of the Options Editor lets you select an installed client other than the active/default client version for IDERA driver connections. It also lets you override default client/server settings.Note: For information on opening the Options Editor, see Specifying Application Preferences and Feature Options.Note: For more general connectivity options, see Connection Options.GroupSettingDescriptionUse Quoted IdentifiersIf you plan to use delimited identifiers, select this option.Sybase Open Client SelectionThis group of controls apply only to use of the IDERA drivers with native Sybase clients.Enable Client SelectionSelecting this check box lets you override the default/active Sybase client specified by the SYBASE, SYBASE_OCS, and/or SYBROOT environment variables. This control enables and

Linux-x86-MySQL Connector/ODBC 8.0.25 MySQL 8.0.26 server MySQL JDBC driver version 8.0.26 Windows-MySQL Connector/ODBC 8.0.26 Linux-x86-MySQL Connector/ODBC 8.0.26 Oracle Server 19.10 Oracle JDBC Driver 19.10.0.0.0 Windows-Oracle Client Version 19.3.0 Linux-x86-Oracle Client Version 19.3.0 Oracle Server 19.11 Oracle JDBC Driver 19.11.0.0.0 Windows-Oracle Client Version 19.3.0 Linux-x86-Oracle Client Version 19.3.0.0 Oracle Server 19.12 Oracle JDBC Driver 19.12.0.0.0 Windows-Oracle Client Version 19.3.0 Linux-x86-Oracle Client Version 19.12.0.0 Oracle Server 21.1 Oracle JDBC Driver 21.1.0.0.0 Windows-Oracle Client Version 19.10 Linux-x86-Oracle Client Version 19.12 Oracle Server 21.3 Oracle JDBC Driver 21.1.0.0.0 Windows-Oracle Client Version 19.10 Linux-x86-Oracle Client Version 19.12 Netezza Server 7.2.1 Netezza JDBC driver 7.2.1.10 Windows-IBM Netezza ODBC driver Version 7.2.1.11 Linux-x86-IBM Netezza ODBC driver Version-7.2.1.11 SQL Server 2017 CU24 Microsoft SQL Server JDBC driver version 9.2.0 Windows-SQL Server Native Client 11 (SQLNCLI11.DLL) Windows-ODBC Driver for SQL Server 17 Linux-x86-DataDirect ODBC Driver 8.0.2 SQL Server 2019 CU10 Microsoft SQL Server JDBC driver version 9.2.0 Windows-Microsoft OLE DB Driver for SQL Server 18.6 (MSOLEDBSQL.DLL) Windows-ODBC Driver for SQL Server 17 Linux-x86-DataDirect ODBC Driver 8.0.2 SQL Server 2019 CU11 Microsoft SQL Server JDBC driver version 9.2.0 Microsoft SQL Server JDBC driver version 9.4.0 Windows-Microsoft ODBC Driver 17.05 for SQL Server Linux-x86-DataDirect Version 08.02 SQL Server 2019 CU12 Microsoft SQL Server JDBC driver version 9.2.0 Microsoft SQL Server JDBC driver version 9.4.0 Windows-Microsoft ODBC Driver 17.05 for SQL Server Linux-x86-DataDirect Version 08.02 Informix V14.10.XC5 server Informix JDBC driver version 4.50.JC4W1 Windows-Informix SDK 4.10 TC14 Linux-x86-Informix SDK 4.10 TC15 Informix V14.10.XC6 server Informix JDBC driver version 4.50.JC4W1 Windows-Informix SDK 4.10 TC14 Linux-x86-Informix SDK 4.10 TC15 Sybase ASE Server 16 SP3 SAP JConnect JDBC driver version 16.1.3 SAP JConnect JDBC driver version 20.0.0 Windows-SAP Client-Library 16.0 Linux-x86-SAP Client-Library 16.0 SP4 Sybase IQ Server 16.1 SP3 SAP JConnect JDBC driver version 16.1.3 Windows-SAP IQ ODBC driver 16.0SP11 Linux-x86-SAP IQ ODBC driver 16.0 SP11 Sybase IQ Server 16.1 SP4 SAP JConnect JDBC driver version 20.0.0 Windows-SAP IQ ODBC driver 16.0SP11 Linux-x86-SAP IQ ODBC driver 16.0 SP11 IBM Performance server/Netezza 11.2.0.0 server Netezza nzjdbc 11.2.0.0 Windows- ODBC driver 11.2.0.0 Linux-x86- ODBC driver 11.2.1.1