When you attempt to set up a connection pool with the SAS IOM driver for JDBC, you might receive one of the following errors:

Datasource cannot be used as one phase.... null
DataSource class cannot be used as one phase
ClassCastException: com.sas.rio.MVADriver

Select the Hot Fix tab in this note to access the hot fix for this issue.

The following procedure shows how to use JDBC connection pooling with IBM WebSphere 6.0. In this procedure it is necessary to use the SAS IOM driver for JDBC in conjunction with the Apache Database connection pooling services (DBCP).

The WebSphere Connection Pool requires that the JDBC driver that is being used must implement the XADataSource method. Note that none of the SAS JDBC drivers implement this method at this time.

By using the Apache database connection pooling services to handle the pooling methods that are not implemented at this time, you can setup a JDBC connection pool in WebSphere 6.0.

Preparing for JDBC Connection-Pooling Setup

To set up JDBC connection pooling with IBM WebSphere Application Server 6.0, you must use the following driver and Java components:

• the SAS IOM JDBC driver, which is available in the hox fix that is referenced in this note.
• the latest JAR files from the following Apache projects which are available from the Apache Commons Web site.
  • Apache Commons Pool (contains commons-collections-3.X.X.jar)
  • Apache Commons DBCP (contains commons-dbcp-1.X.X.jar)
  • Apache Commons Collection (contains commons-pool-1.X.jar)

Setting Up WebSphere 6.0

1. Start the WebSphere Application Server.
2. Set your browser to the WebSphere Administrative Console application.
3. Click Logon.
4. Log on to the WebSphere Administrative Console. By default, an account and password are not required.
5. On the left side of the console, navigate through the hierarchy to the Preparing for Application Installation wizard.
6. Click Resources ► JDBC Providers.
7. Click New.
8. In the Step 1 list box, select User Defined. The other boxes will populate automatically.
9. Click Next.
10. In the Name text box, type a descriptive name for the JDBC provider, for example, SAS JDBC Provider.
11. In the Class path text box enter, the paths for the JAR files from the Apache downloads and the JAR files from the SAS IOM JDBC driver that is available from the hot fix. Enter each JAR file on its own line, similar to the following example:
    
    From the Apache Commons Projects:
    C:\temp\commons-collections-3.X.X.jar
    C:\temp\commons-dbcp-1.X.X.jar
    C:\temp\commons-pool-1.X.jar
    
    
    From the SAS IOM driver for JDBC:
    C:\temp\sas.intrnet.javatools.jar
    C:\temp\sas.svc.connection.jar
    
    
12. In the Implementation class name field, type org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS. Note that this character string is case-sensitive.
13. Click Apply.
14. Under the Additional Properties menu, click Data sources.
15. Click New.
16. Type a descriptive name for your data source name, such as SASDB, in the Name text block.
17. Under Data store helper class name, select Generic data store helper.
18. Click Apply.
19. Click the Custom Properties link.
20. Click New and add the two following properties:
    • In the Name field, enter url.
    • In the Value field, enter jdbc:sasiom://your-server-name:IOM-port-number.
21. Click OK.
22. Click New and add the two following properties:
    • In the Name field, enter driver.
    • In the Value field, enter com.sas.rio.MVADriver. Note: This string is case sensitive.
23. Click OK.
24. Click the Save link.
25. Click Save.

Operating System and Release Information

A fix for this issue for SAS JDBC Drivers 9.1.3 is available at: