WebSphere Adapter for JDBC

Generating artifacts

You configure properties that the adapter uses to set up a communication channel to a specific database. You also need to create a new business integration module where all the artifacts and property values can be saved.

  1. In the Generate Artifacts window, create a new module by clicking New. If the New Integration Project window appears, select Create a module project and click Next.
    Figure 1. Generate Artifacts window
    This screen capture is described in the surrounding text.
  2. In the New Module window, type JDBCOutbound in the Module Name field and click Finish.

    Do not change the default Module Location.

    Figure 2. New Module window
    This screen capture is described in the surrounding text.
  3. In the Generate Artifacts window, select Use discovered connection properties.

    This enables you to set configuration property values that will be used to connect to the enterprise information system at run time. For outbound processing, the properties are displayed for the Managed (J2C) connection factory and Resource adapter properties. Required property fields are marked with an asterisk.

    For more details on the Adapter configuration properties, see the "Reference" section.

    Figure 3. Use discovered connection properties This screen capture is described in the surrounding text.
  4. For the JDBC Authentication Data Entry, type SCA_Auth_Alias, which is the authentication alias you created earlier.

    The name is case-sensitive.

  5. Type the connection properties Username, Password, Database URL and JDBC Driver Class that you set after starting the enterprise service discovery wizard.
    Figure 4. Set the Alias and Managed connection propertiesThis screen capture is described in the surrounding text.
  6. Provide values only for each property field marked with an asterisk.

    You can also set logging and tracing properties if you want the adapter log and trace files to be generated. You can use the property values displayed in the following figure.

  7. When you are finished setting required properties, click Finish.
    Figure 5. Set Resource adapter properties
    This screen capture is described in the surrounding text.

    Verify the results by comparing your output to the tutorial sample file. In the Business Integration perspective, at the Business Integration pane, expand the JDBCOutbound module. Expand the Data Types folder to view a list of all the business objects.

    Figure 6. Verify the results of generating artifacts
    This screen capture is described in the surrounding text.

Terms of use |

Last updated: Tue 12 Dec 2006 03:32:39

(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)