Download

IBM WebSphere Adapter for JDBC Samples

The following project interchange file contains the sample files for reference. To download the project interchange file, click the following links:

  • Sample to demonstrate creating stored procedures in Oracle : Tutorial1.zip
  • Sample to demonstrate creating stored procedures in SQLServer : Tutorial2.zip
  • Sample to demonstrate Oracle StructArray : Tutorial3.zip
  • Sample to demonstrate the Batch SQL functionality : Tutorial4.zip
  • Sample to demonstrate inbound functionality : Tutorial5.zip
  • Sample to demonstrate executing stored procedures in DB2 : Tutorial6.zip
  • Sample to demonstrate using an XA Datasource to establish connection to DB2 database : Tutorial7.zip
  • Sample to demonstrate using an XA Datasource to establish connection to Oracle database : Tutorial8.zip
  • Sample to demonstrate PreparedStatementCache in Oracle : Tutorial9.zip
  • Sample to demonstrate WrapperBO in Oracle : Tutorial10.zip
  • Sample to demonstrate executing stored procedures in SQLServer : Tutorial11.zip
  • Sample to demonstrate user-defined queries and using the RetrieveAll operation with DB2 database : Tutorial12.zip
  • Sample to demonstrate checking for the existence of a Business Object : Tutorial13.zip
  • Sample to demonstrate generating wrapper business objects for Inbound : Tutorial14.zip

The following script files support quicker execution of the sample files. To download these SQL scripts, click the following links:

Note: These samples are for reference only. They would not work in your environment. Please see "Build It Yourself" section for generating these samples for your environment.

To import a project into IBM Integration Designer, perform the following steps:

  1. Download the zip file to a temporary directory.
  2. Download the relevant adapter.rar.
  3. Switch to IBM Integration Designer.
  4. From the menu, select File > Import. The import wizard opens.
  5. The select page is displayed. As the import source, select Project interchange.
  6. Click Next.
  7. The import projects page is displayed. Click Browse to select the zip file.
  8. Browse to the temporary directory and select the zip file you downloaded in step 1.
  9. Click Select All.
  10. Click Finish.
  11. Import the adapter RAR file.
  12. Make sure adapter rar file is added to the J2EE dependencies list of the module if it is not available.