You can use the DBAdapter Configurator dialog box to add, modify, and remove SQL statements. While defining or editing SQL statements, you can specify the database connection details.
To define database connection:
1. To create an SQL statement, click Add to open the SQL Statement dialog box. To modify an existing SQL statement, select an SQL statement and click Modify.
The SQL Statement dialog box provides four tabs: Connection, SQL Statement, Input Parameters, and Output Parameters. Initially, only the Connection tab is enabled.
2. Enter the SQL Statement Name.
3. To define Database Parameters, click Choose a Database to open the Database Definitions dialog box that lists available databases.
You can add, modify, and remove Database definitions.
4. To define a database definition, click Add to open the Database Parameters dialog box. To modify an existing database definition, select a Database name and click Modify.
a. Enter a name in the Database Name box.
b. Select a database type from the Database Type drop-down list. Supported Database types include OpenEdge.
c. Enter the Login User name and Password.
d. Select the Database type to populate data in the JNDI Name field and in the Driver and URL fields in the Non-J2EE Datasource parameters panel. You need to modify this data with the proper database information.
e. Click OK to return to the Database Definitions dialog box. The added database definition now displays in the definition list.
5. Select a database and click OK to return to the SQL Statement dialog box.
6. Click Connect to connect to the selected database.
The Status panel displays whether the connection is successful. If it is successful, the message "Successfully connected to database: <database_name> appears in the Status panel. The SQL Statement tab is also enabled so you can specify the SQL statement.
7. Click the SQL Statement tab to define the SQL statements.
