These properties vary according to the database vendor requirements
for JDBC driver implementations. You must 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
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.
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.
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)