Appendix A
JDBC/ODBC Drivers
Drivers are uniquely different in what they do and the type of functions they support. The JDBC/ODBC eWay allows you to pick and choose which driver is best suited for your application environment. There can be significant differences and limitations between drivers. The performance and functionality of the JDBC/ODBC eWay depends on the selected driver(s). Certain drivers may not support all JDBC features. Consult the documentation for your respective drivers for more information.
This appendix provides database configuration information and environment properties specifications for specific JDBC/ODBC drivers. You should use the information listed in the included tables to define values for required input parameters.
While any standards compliant JDBC/ODBC database driver may be used, the drivers covered in this chapter are used more frequently. For runtime, only drivers that support Connection Pool Data Source and XA Data Source are supported. Connection Pool Data Source takes advantage of the Integration Service's connection pooling in order to improve performance. For the OTD Wizard, the driver Manager Class will work. However, not all drivers support all metadata discovery methods, some of which are needed to build the OTD. Additionally, not all drivers support Updatable ResultSets, Stored Procedures, or Stored Procedures with ResultSets. Check with your driver vendor for what is supported. The ConnectionPoolDataSource should only be used for Outbound eWays. The Inbound eWay uses native JDBC and must use Driver Manager (see Table 6 on page 32).
It is recommended that you use the Oracle eWay when using the native Oracle driver. The JDBC eWay does not support some of the functions available in the Oracle eWay such as creating an OTD from a Prepared Statement, using a Stored Procedure with ResultSets, and CLOB support.
It is also recommended that you use the SQL Server eWay. The JDBC driver available for download from the Microsoft web site may not contain the latest version from the vendor.
Not all drivers support Updatable ResultSets. However, it does allow standard Insert and Update operations when used with the Prepared Statement feature:
Insert into employee (empno) values(?);
Remember to ensure that the input parameter data types match the data types specified in the database table targeted by the Prepared Statements as some drivers always return the data type as a string. Optionally, you may perform the data conversion in the Collaboration.
JDBC/ODBC eWay Adapter User’s Guide | 117 | Sun Microsystems, Inc. |
