Database Connectors in the Solutions View
After you have connected to a database using the DataSource Explorer view, you can create a new database connector or modify an existing one.
In the Solutions view, you can also delete database connections.
Before you can create a new database connector in the Solutions view, you must connect the Composite Application Framework application project to a database and an existing database connector.
To create a new database connector in the Solutions View, do the following.
To create a Database Connector in the Solutions view
1. On the Solutions view, expand the Web application to expose the Database Connectors node, right-click Database Connectors, and click New Database Connector.
The Database Connection Configuration wizard appears, pre-configured with information about the database to which Composite Application Framework is connected.
2. If needed, modify the values for the JDBC Driver, URL, Username, and Password fields, and click Next.
3. In Managed Bean Name field of the DB Client Properties panel, either accept the default name or type a new one.
4. To allow the database connector to write to the database, clear the Read-only client option, and click Next.
Connectors are read-only by default.
5. In the Table list, choose a database table and click OK.
6. On the Query Columns Selection page, choose the table columns you want to query.
7. (Optional) To add another table, click Add Table, choose a table, and click OK.
For tables that have foreign key relations with the main table, the join condition is added automatically.
8. Click Finish.