Data source minimum required settings for Microsoft SQL Server
These properties vary according to the database vendor requirements for Java™ Database Connectivity (JDBC) driver implementations. You must set the appropriate properties on every data source that you configure. These settings are for Microsoft SQL Server data sources.
JDBC provider | Microsoft SQL Server feature | Configuration consideration |
---|---|---|
Microsoft SQL Server JDBC Driver | SNAPSHOT isolation level | Set the isolation level constant by invoking
the setTransactionIsolation method with one of the following attributes:
|
READ_COMMITTED_SNAPSHOT isolation level | This isolation level is an implementation of
the Read committed isolation level. The policy enforces optimistic
locking for read operations with Microsoft SQL
Server.
|
|
DataDirect ConnectJDBC type 4 driver for Microsoft SQL Server | SNAPSHOT isolation level | This isolation level implements optimistic locking
for transactions in which Microsoft SQL
Server serializes the data. Configure the ALLOW_SNAPSHOT_ISOLATION
setting on the database, and then set the isolation level in one of
two ways:
|
READ_COMMITTED_SNAPSHOT isolation level | This isolation level is an implementation of
the Read committed isolation level. The policy enforces optimistic
locking for read operations with Microsoft SQL
Server.
|
- Microsoft SQL Server JDBC Driver The Microsoft SQL Server JDBC driver supports this data source:
com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource
The JDBC provider requires the following Java archive (JAR) files:sqljdbc4.jar
The JDBC provider requires the following DataStoreHelper class:com.ibm.websphere.rsadapter.MicrosoftSQLServerDataStoreHelper
The JDBC provider requires a valid authentication alias.The JDBC driver requires the following properties:- serverName
- Specifies the name of the server in which Microsoft SQL Server resides. Example: myserver.mydomain.com
- portNumber
- Specifies the TCP/IP port that Microsoft SQL Server uses for communication. Port 1433 is the default.
- databaseName
- Specifies the name of the database from which the data source obtains connections. Example: Sample.
- Microsoft SQL Server JDBC Driver (XA) This JDBC provider supports this data source:
com.microsoft.sqlserver.jdbc.SQLServerXADataSource
The JDBC provider requires the following Java archive (JAR) files:sqljdbc4.jar
The JDBC provider requires the following DataStoreHelper class:com.ibm.websphere.rsadapter.MicrosoftSQLServerDataStoreHelper
The JDBC provider requires a valid authentication alias.The JDBC driver requires the following properties:- serverName
- Specifies the name of the server in which Microsoft SQL Server resides. Example: myserver.mydomain.com
- portNumber
- Specifies the TCP/IP port that Microsoft SQL Server uses for communication. Port 1433 is the default.
- databaseName
- Specifies the name of the database from which the data source obtains connections. Example: Sample.
- DataDirect ConnectJDBC type 4 driver for Microsoft SQL Server
DataDirect ConnectJDBC type 4 driver for Microsoft SQL Server is a Type 4 JDBC driver that provides JDBC access to the Microsoft SQL Server databases. This provider is for use only with the Connect JDBC driver purchased from DataDirect Technologies.
This JDBC provider supports the following data source:com.ddtek.jdbcx.sqlserver.SQLServerDataSource
Requires JDBC driver files:sqlserver.jar
RequiresDataStoreHelper
class:com.ibm.websphere.rsadapter.ConnectJDBCDataStoreHelper
Requires a valid authentication alias.
Requires properties:-
serverName
The name of the server in which Microsoft SQL Server resides. Example: myserver.mydomain.com -
portNumber
The TCP/IP port that Microsoft SQL Server uses for communication. Port 1433 is the default. -
databaseName
The name of the database from which the data source obtains connections. Example: Sample.
-
- DataDirect ConnectJDBC type 4 driver for Microsoft SQL Server (XA)
DataDirect ConnectJDBC type 4 driver for Microsoft SQL Server (XA) is a Type 4 JDBC driver which provides XA-compliant JDBC access to the Microsoft SQL Server databases. This provider is for use only with the Connect JDBC driver purchased from DataDirect Technologies.
This JDBC provider supports this data source:com.ddtek.jdbcx.sqlserver.SQLServerDataSource.
Requires JDBC driver files:sqlserver.jar
RequiresDataStoreHelper
class:com.ibm.websphere.rsadapter.ConnectJDBCDataStoreHelper
Requires a valid authentication alias.
Requires properties:-
serverName
The name of the server in which Microsoft SQL Server resides. Example: myserver.mydomain.com -
portNumber
The TCP/IP port that Microsoft SQL Server uses for communication. Port 1433 is the default. -
databaseName
The name of the database from which the data source obtains connections. Example: Sample.
-