WebSphere Adapter for Email

Creating and configuring the data source

Once you have created the EMAILDB database, you must configure WebSphere® Integration developer to recognize it as the data source.

  1. Open WebSphere Integration Developer. The Business Integration perspective will open by default.
  2. Click on the Server tab to bring it to the front.
  3. Right-click WebSphere Process Server 6.0 and select Start. This will start WebSphere Process Server.
  4. Click the Console tab and confirm that the server is active and ready for transaction requests. When the server is ready the Server <server profile> is open for e-business message will be displayed.
  5. Open the test server's administrative console window by right-clicking the server profile on the Server tab and selecting Run Administrative Console. The port number for the administrative console may differ based on your setup. If your port number is different from the default, use your specific port number.
  6. In the user ID field, enter the default administrative user ID "admin" and click Log in.
  7. Create the JDBC data source in WebSphere Process Server with a JNDI name jdbc/EMAILDB.
    1. Open the WebSphere Process Server administrative console by right-clicking the server instance and selecting Open administrative console.
    2. Select Resources > JDBC Providers > Cloudscape JDBC Provider > Data sources.
    3. Select new for Data sources.
    4. For the JNDI Name type jdbc/EMAILDB.
    5. For the Database name, type EMAILDB.
  8. Return to Data Sources and select the data source you just created. Then, click Test connection.

Result

If the connection was successful, Test connection for data source Cloudscape JDBC Driver DataSource on server 1 at node <node name> was successful is displayed.
Note: The test connection must be successful to execute the rest of the scenario.

Terms of use |

Last updated: Mon 30 Oct 2006 03:44:38

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