Adding support for developing and testing SQL statements in Java projects

If your Java application runs SQL statements, you can simplify the development and testing of SQL statements by adding data access development support to your Java project. With data access development support, you can test SQL statements by running them from the Java editor and perform other tasks when you develop Java applications that run SQL statements.

About this task

When you enable data access development support for your Java project, you associate a database connection with the project. The workbench uses the database information when you work with SQL statements in your project.

Procedure

To enable data access development support:

  1. In the Package Explorer, right-click your Java project select Data Access Development > Add Data Access Development Support.
  2. In the Add Data Access Development Support wizard, specify an existing database connection or create a new connection and complete the wizard.

    If you enable pureQuery support when you enable data access development support, you can also specify settings for pureQuery support.

Results

With data access development support, you can perform tasks such as:

What to do next

If you did not enable pureQuery support, you can enable it by right-click your Java project and selecting Data Access Development > Add pureQuery Support. IBM® InfoSphere® Optim™ pureQuery Runtime is a high-performance data access platform that is focused on simplifying, developing, securing, managing, and optimizing new and existing applications that access data.

Using pureQuery Runtime in a production environment requires a pureQuery Runtime license.


Feedback