Connecting to the database

  1. Make sure you have already created a project in Rational Application Developer. If you have yet to create a project, see the Rational Application Developer help system information on creating a project. This will make sure that you will have a project in which to place the resources that you will create in the following steps.

  2. Click the Create a WPCP Resource button in the toolbar to start the wizard.

  3. In the Specify Protocol and Data Model window, click SQL.

  4. Click Connect to a SQL database for a database model or Use existing database model. If you choose to use an existing database, click Browse, and choose a database from an existing project. This method assumes you are using Rational Application Developer to develop your databases.

  5. Click Web content.

  6. Click Next.

  7. In the Database Connection window, type a unique name in the Connection name field.

  8. Type the Database name.

  9. Type the User ID and Password to access the database.

  10. In the Database vendor type field, click the format you want to use from the drop-down list. You may have to change it from the default. For example, Cloudscape users must select the Cloudscape, V5.0 choice from the drop-down list.

  11. In the JDBC driver field, click the format you want to use from the drop-down list.

  12. The Host, Port number, and Server name fields will be available depending on what your Database vendor type and JDBC driver requires you to specify. The JDBC driver class and Connection URL are enabled only if a type of "other" Driver was chosen from the JDBC driver drop-down list.

  13. For Cloudscape users only: You will need to fill out the Class location field with the name of the Cloudscape jar included with your Portal v5 install.

    To narrow the displayed list of tables, click the Filters button and type a table name filter. For example, D% will narrow the list to just the table names starting with the letter 'D'.

  14. Click Connect to Database.

If you are using IBM DB2, and the IBM DB2 client is on both Rational Application Developer and the Application Server, choose the IBM DB2 UDB local driver. Otherwise, choose IBM DB2 UDB remote. When using IBM DB2 and choosing IBM DB2 UDB remote, run the db2jstrt command on the machine that has the database server. When using the JDBC-ODBC bridge to connect to an ODBC data source, the ODBC data source must be defined as a system data source name (DSN), not as a user DSN.



 

Back