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.
Configure the following types of providers:
- 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 V6.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 V6.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 V5.5
- 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 V5.5
- 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
Set a JDBC provider and data source
Set a JDBC provider
Set a data source
Create and configuring a JDBC provider and data source using the Java Management Extensions API