Because Dialog Designer is a Java-based tool, data sources for Dialog Designer speech applications must be JDBC-compliant. If JDBC drivers are not installed on your computer, they must be installed to work with data sources. To install these drivers, see the documentation that cam with your database software.
The Database tab is located on the Data Sources tab of the Dialog Designer properties pane in the Properties for ProjectName dialog box. For more information about the Properties for ProjectName dialog box, including the procedure to open it, see Setting Project Properties.
Use the Database tab for:
Adding a JDBC Data Source
To add a data source:
- Access the Database tab located on the Data Sources tab of the Dialog Designer properties pane in the Properties for ProjectName dialog box.
- On the Database tab, click Add to add a data source.
- Dialog Designer displays the Create a new datasource dialog box.
- In the Name field, enter the name Dialog Designer is to use to identify the data source.
- Note that this can be any name you choose. It is used only within Dialog Designer.
- In the Driver Class Name field, enter the name of the driver class to use with this data source. For example:
- Driver Class Name: oracle.jdbc.OracleDriver
- Connection URL: jdbc:oracle:thin:@148.147.46.68:1521:orcl
Note:
The WAR file for Tomcat contains the context file that is automatically deployed in
the Tomcat directory for the application. Tomcat uses this context file to create
and manage data source connections. In case you need to modify the data
source information such as the driver class and URL without going though the
design environment, you need to go directly into this context file.
The file exists in the <Tomcat_Home>\conf\Catalina\localhost\ directory with
the <application_name>.xml naming. To modify the driver class or URL, locate
the Resource element which has the corresponding data source in its
dataSourceName attribute, and change the URL or driver attribute of the same
element.
- In the Connection URL field, enter the URL to the data source.
- This URL can be either external to the local system or somewhere on the local system. For more information about what to enter in this field, see the documentation for your database software.
- If the data source requires a user login, in the Username field enter the login user ID, and in the Password field enter the login password. For more information about what to enter in these fields, see the documentation for your database software.
- Click OK.
Editing a JDBC Data Source
To edit a data source:
Note:
Before you attempt to perform this procedure, verify that you have the appropriate
JDBC driver installed and configured. For more information about installing and
configuring the JDBC driver, see Database Preferences.
- Access the Database tab located on the Data Sources tab of the Dialog Designer properties pane in the Properties for ProjectName dialog box.
- On the Database tab, select the data source to be edited.
- Click Edit.
- Dialog Designer displays the Edit the datasource dialog box.
- Edit the fields as desired.
- The only field you cannot change is the Name field, which is display-only.
- Click OK.
Deleting a JDBC Data Source
To delete a data source:
- Access the Database tab located on the Data Sources tab of the Dialog Designer properties pane in the Properties for ProjectName dialog box.
- On the Database tab, select the data source to be deleted.
- Click Delete.
Dialog Designer deletes the data source.
Creating (or Removing) Failover Data Sources
To create a list of failover data sources:
- Access the Database tab located on the Data Sources tab of the Dialog Designer properties pane in the Properties for ProjectName dialog box.
- On the Database tab, select a data source that will have a failover data source.
- A Configure Failover Path dialog box is displayed. Click Add to select a failover data source.
- A Data Sources dialog box is displayed, listing possible data sources that can be selected as failover data sources. Click one to select it, then click OK.
Note:
The list of data sources in this dialog box is a subset defined in the Database tab.
- The selected data source is shown in the Configure Failover Path dialog box. Click OK, to save the data source's failover designation.
- If desired, more than one data source can be designated as a failover data source. In this case, repeat steps 3 and 4 for as many data sources desired. To give priority to the different data sources that will be used as failovers, click the Up and Down buttons in the Configure Failover Path dialog box as necessary.
- To remove a data source designated as a failover data source, click Remove.
