Connecting to the database

  1. Make sure you have already created a project in Rational® tools. If you have yet to create a project, refer to the help system for 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. Select

    File | New | Other. In the New wizard, expand the

    Portal | Personalization folders, and select Content or User Resource. Click Next.

  3. In the Specify Protocol and Data Model window, choose SQL and Web users, then click Next.

  4. If you have already created a connection to your database in Rational tools, select the

    Use an existing connection radio button and then select the connection in the Existing connections list. Otherwise, leave the

    Create a new connection radio button selected. Click Next.

  5. In the Connection Parameters window, type a unique name in the Connection name field, or leave the

    Use default naming convention check box selected.

  6. Select a database manager from the list. For example, Cloudscape® users must select the Cloudscape, V5.0 or v5.1 choice from the list.

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

  8. Specify the Database and Class locations, if required.

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

  10. Click Next.

  11. 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.

  12. 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.

  13. Click Next.

  14. On the Resource Generation Options page, specify the source folder for your target project (for example,

    <projectName>/src), and a Package. The package must be within the folder you select for a source folder.

  15. Click Finish.

If you are using IBM® DB2®, and the IBM DB2 client is on both Rational Software Delivery Platform and the WAS, 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.

 

Related concepts

Creating SQL user resources

Feedback