Data source minimum required settings for Sybase

Set the appropriate properties on every data source configured. These settings are for Sybase data sources.

What types of providers can you configure?

We can configure the following types of providers:

• Sybase JDBC 4 Driver

• Sybase JDBC 4 Driver (XA)

• Sybase JDBC 3 Driver

• Sybase JDBC 3 Driver (XA)

• Sybase JDBC 2 Driver

• Sybase JDBC 2 Driver (XA)

Sybase JDBC 4 Driver

The Sybase JDBC 4 Driver is a Type 4 JDBC driver that provides JDBC access to the Sybase database.

This provider:

• Uses jConnect Version 7.0

• Supports one phase data source:
  com.sybase.jdbc4.jdbc.SybConnectionPoolDataSource

• Requires the following JDBC driver files:
  jconn4.jar

• Requires the following DataStoreHelper class:
  com.ibm.websphere.rsadapter.SybaseDataStoreHelper

• Requires a valid authentication alias.

• Requires the following 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: 5000.

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

Sybase JDBC 4 Driver (XA)

The Sybase JDBC 4 Driver (XA) is a Type 4 JDBC driver that provides XA-compliant JDBC access to the Sybase database.

This provider:

• Uses jConnect Version 7.0

• Supports two phase data source:
  com.sybase.jdbc4.jdbc.SybXADataSource

• Requires JDBC driver files:
  jconn4.jar

• Requires the following DataStoreHelper class:
  com.ibm.websphere.rsadapter.SybaseDataStoreHelper

• Requires a valid authentication alias.

• Requires the following 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: 5000.

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

Sybase JDBC 3 Driver

The Sybase JDBC 3 Driver is a Type 4 JDBC driver that provides JDBC access to the Sybase database.

This provider:

• Uses jConnect Version 6.05

• Supports one phase data source:
  com.sybase.jdbc3.jdbc.SybConnectionPoolDataSource

• Requires the following JDBC driver files:
  jconn3.jar

• Requires the following DataStoreHelper class:
  com.ibm.websphere.rsadapter.SybaseDataStoreHelper

• Requires a valid authentication alias.

• Requires the following 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: 5000.

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

Sybase JDBC 3 Driver (XA)

The Sybase JDBC 3 Driver (XA) is a Type 4 JDBC driver that provides XA-compliant JDBC access to the Sybase database.

This provider:

• Uses jConnect Version 6.05

• Supports two phase data source:
  com.sybase.jdbc3.jdbc.SybXADataSource

• Requires JDBC driver files:
  jconn3.jar

• Requires the following DataStoreHelper class:
  com.ibm.websphere.rsadapter.SybaseDataStoreHelper

• Requires a valid authentication alias.

• Requires the following 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: 5000.

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

Sybase JDBC 2 Driver

The Sybase JDBC 2 Driver is a Type 4 JDBC driver that provides JDBC access to the Sybase database.

This provider:

• Uses jConnect Version 5.5

  

  Deprecated feature: Support for Sybase jConnect 5.5 is deprecated. We might want to use a later provider that uses Sybase jConnect 6.05 or jConnect 7.0.depfeat

• Supports one phase data source:
  com.sybase.jdbc2.jdbc.SybConnectionPoolDataSource

• Requires the following JDBC driver files:
  jconn2.jar

• Requires the following DataStoreHelper class:
  com.ibm.websphere.rsadapter.SybaseDataStoreHelper

• Requires a valid authentication alias.

• Requires the following 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: 5000.

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

Sybase JDBC 2 Driver (XA)

The Sybase JDBC 2 Driver (XA) is a Type 4 JDBC driver that provides XA-compliant JDBC access to the Sybase database.

This provider:

• Uses jConnect Version 5.5

  

  Deprecated feature: Support for Sybase jConnect 5.5 is deprecated. We might want to use a later provider that uses Sybase jConnect 6.05 or jConnect 7.0.depfeat

• Supports two phase data source:
  com.sybase.jdbc2.jdbc.SybXADataSource

• Requires JDBC driver files:
  jconn2.jar

• Requires the following DataStoreHelper class:
  com.ibm.websphere.rsadapter.SybaseDataStoreHelper

• Requires a valid authentication alias.

• Requires the following 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: 5000.

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

Related tasks

Configure a JDBC provider and data source

Configure a JDBC provider using the administrative console

Configure a data source using the administrative console

Create a JDBC provider and data source using the JMX API