Eclipse Based Foundation Toolkit for Heterogenous Database Applications

1. What new data-specific perspectives and capabilities are added after you install Eclipse Based Foundation Toolkit for Heterogenous Database Applications?

The following perspectives and capabilities are added:

• The Data Perspective includes the Data Project Explorer, Data Source Explorer, SQL Results and other commonly used views
• The Database Debug Perspective provides support for debugging DB2 stored procedures.
• The Database Development Perspective provides access to the new perspectives.

Back to top

2. How do I open the Data Perspective?

Follow these steps to open the Data Perspective:

1. From the main menu, select Window > Open Perspective > Other The Open Perspective window opens.
2. Select Data from the list and click OK. The Data Perspective opens.

Back to top

3. How do I create a new connection to an existing database?

From the Data Source Explorer view, right-click the Database Connections folder and select New. The New Connection window opens so that you can create a new connection to any of the supported databases.

Back to top

4. How do I create a new data development project so that I can create and manage SQL scripts, stored procedures, and user-defined functions using my existing connection?

In the Data Perspective, on the menubar select File > New > Data Development Project. The New Data Development Project window opens so that you can create a new project using your existing connection.

Back to top

5. I am trying to debug a DB2 stored procedure, but the Debug menu action is disabled. How do I fix this?

When you deploy a DB2 stored procedure, you must remember to select the Enable debugging checkbox.

Back to top

6. How do I install the MySQL JDBC drivers?

Follow these steps to install the MySQL drivers:

1. From the Data Source Explorer view, right-click theDatabase Connections folder and select New. The New Connection window opens.
2. From the Select a database manager: list, select MySQL. The JDBC driver and Properties will change.
3. From the JDBC driver: dropdown, select the appropriate MySQL version.
4. Next to the JDBC driver: dropdown, click on the triangle button. This button has a tooltip of "Edit Jar List...". The Edit Jar List window opens.
5. Confirm that the name and location of the JDBC driver jar file is correct. If it is not, use the Add JAR/Zip or Edit Jar/Zip to add the necessary JDBC driver jar files. The MySQL JDBC drivers can be downloaded from http://www.mysql.com/products/connector/j/.

Back to top

7. The SQL and XQuery text editor marks any some syntax as invalid even though the syntax might be correct. How do I disable syntax validation?

Syntax validation can be disabled by following these steps:

1. On the menubar, select Window > Preferences > Data Management > SQL Development > SQL and XQuery Editor.
2. In the Validation section, clear the Validate statement syntax check box.

Back to top

8. Where can I find additional help on-line?

See the IBM Integrated Data Management Information Center.

Back to top