Webshpere 6.1下SQLServer 2005 驱动程序设置方法

首先必须是websphere 6.1 fixpack 15 以上的版本。

下面的设置方法：

1. download the Microsoft SQL Server 2005 JDBC driver version 1.2

2. unzip it

3. copy the sqljdbc jar into [drive]:/IBM/WebSphere/AppServer/lib

4. restart Web$phere service

5. open admin console

5. create the JDBC provider:

  a. open resources -> jdbc -> jdbc providers

  b. create new provider

  c. database type = "user-defined"

  d. implementation class = "com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource"

  e. give it whatever name you like

  f. hit apply and hit save

6. create the JDBC data source:

  a. open resources -> jdbc -> data sources

  b. create a new datasource

  c. give it a datasoure name and jndi name (later used in your app) and click next

  d. select an existing jdbc provider (the one you just created)

  e. Datastore helper class name = "com.ibm.websphere.rsadapter.MicrosoftSQLServerDataStoreHelper" CMP is up to you. I unchecked it since we use BMP exclusively.

  f. you click finish, but you're not done. Go back into this datasource and at the bottom of the page you need to configure the database name, server name, and port. Then click apply, save, and test the datasource (may need to stop/start Web$phere).

资料来源：

http://blogs.msdn.com/jdbcteam/archive/2008/03/24/ibm-websphere-6-1-now-supports-sql-server-2005-jdbc-driver-v1-2.aspx