Data source minimum required settings for Sybase

These properties vary according to the database vendor requirements for JDBC driver implementations. Set the appropriate properties on every data source that you configure. These settings are for Sybase data sources.

You can configure the following types of providers:

• Sybase jConnect for JDBC driver

• Sybase jConnect for JDBC driver (XA)

• Sybase jConnect for JDBC driver

  The Sybase jConnect JDBC driver is a Type 4 JDBC driver that provides JDBC access to the Sybase database. Sybase jConnect JDBC driver supports one phase data source:

  com.sybase.jdbc2.jdbc.SybConnectionPoolDataSource 
  

  Requires JDBC driver files: jconn2.jar. For IPv6 support: For applications that access Sybase in an IPv6 environment, you must use the Sybase jConnect JDBC driver version 6.0 EBF 12884. This implementation uses different classes and therefore requires a different JAR file and a different implementation class designation. You can define the jConnect JDBC driver v6.0 EBF 12884 in the administrative console by selecting User-defined as the database type on the New JDBC provider page. On the JDBC provider general configuration page, replace the default JAR file name with jconn3.jar. For the implementation class, input com.sybase.jdbc3.jdbc.SybConnectionPoolDataSource. The data store helper class and required properties are the same for all Sybase JDBC drivers. Requires DataStoreHelper class:

  com.ibm.websphere.rsadapter.SybaseDataStoreHelper

  Requires a valid authentication alias. Requires properties:

  • serverName The name of the database server. Example: myserver.mydomain.com.

  • databaseName The name of the database from which the data source obtains connections. Example: Sample.

  • portNumber The TCP/IP port number through which all communications to the server take place. Example: 4100.

  • connectionProperties A custom property required for applications containing EJB 2.0 enterprise beans. Value: SELECT_OPENS_CURSOR=true(Type: java.lang.String)

• Sybase jConnect for JDBC driver (XA)

  The Sybase jConnect JDBC driver (XA) is a Type 4 JDBC driver that provides XA-compliant JDBC access to the Sybase database. Sybase jConnect JDBC driver (XA) supports two phase data source:

  com.sybase.jdbc2.jdbc.SybXADataSource 

  Requires JDBC driver files: jconn2.jar. For IPv6 support: For applications that access Sybase in an IPv6 environment, use the Sybase jConnect JDBC driver version 6.0 EBF 12884. This implementation uses different classes and therefore requires a different JAR file and a different implementation class designation. You can define the jConnect JDBC driver v6.0 EBF 12884 in the administrative console by selecting User-defined as the database type on the New JDBC provider page. On the JDBC provider general configuration page, replace the default JAR file name with jconn3.jar. For the implementation class, input com.sybase.jdbc3.jdbc.SybXADataSource. The data store helper class and required properties are the same for all Sybase JDBC drivers. Requires DataStoreHelper class:

  com.ibm.websphere.rsadapter.SybaseDataStoreHelper

  Requires a valid authentication alias. Requires properties:

  • serverName The name of the database server. Example: myserver.mydomain.com

  • databaseName The name of the database from which the data source obtains connections. Example: Sample.

  • portNumber The TCP/IP port number through which all communications to the server take place. Example: 4100.

  • connectionProperties A custom property required for applications containing EJB 2.0 enterprise beans. Value: SELECT_OPENS_CURSOR=true(Type: java.lang.String)

Related tasks

Reference topic